
- Forum
- Database
- Oracle Database
- tablespace management
tablespace management
This is a discussion on tablespace management within the Oracle Database forums, part of the Database category; when I am importing one users schema(A) into anothers schema(B), all the imported objects are in the tablespace of exported ...
-
tablespace management
when I am importing one users schema(A) into anothers schema(B),
all the imported objects are in the tablespace of exported user(A) even when
I am mentioned other default tablespace for that user.
I want the imported objects to be in default tablespace of his own(B).
for that what I have to do.
Please answer for this question.
-
07-13-2007, 07:19 PM #2
- Join Date
- Jul 2007
- Location
- Birmingham-UK
- Answers
- 12
Are you importing one user's schemal objects into another's as a DBA?
Well,try this, Make sure both users do not have the DBA-role. then log in as one user and use the from user to user option and set the default tablespace.

Reply With Quote





