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