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 ...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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. |
|
|||
|
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. |
![]() |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Request for interview question for Testing (QA) | wildkid98 | Testing Tutorials | 17 | 04-23-2008 05:24 AM |
| hai this is kalyani request for the testing tutorial | kalyanvalli | Software Testing | 7 | 02-07-2007 08:34 AM |
| Enterprise Storage Management (ESM) FAQ Revision 2004/06/23 - Part 1/1 | Will Spencer | Tech FAQ | 0 | 06-23-2004 02:58 AM |
| Enterprise Storage Management (ESM) FAQ Revision 2004/04/11 - Part 1/1 | Will Spencer | Tech FAQ | 0 | 04-11-2004 03:24 AM |
| ANN: Build management | Patrick Egan | Software Patterns | 0 | 10-22-2003 08:55 PM |