| Regarding import [message #71878] |
Mon, 27 January 2003 23:03  |
Ashiq Shamsudeen
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Hi ,
I've problem when importing the data's.My problem is i've createad a user BILL and given him default tablepsace RMS and i've given him dba role .I took the dmp from scott user which is in system tablespace.
After importing the dmp to BILL user and i checked the tablspace_name for the objects(user_Tables),its showing still system tablespace for all the tables in BILL user.
Why its showing system?Though i've specified the default tablespace for BILL.
Timely help will be greatly appreciated
thanx
|
|
|
|
| Re: Regarding import [message #71882 is a reply to message #71878] |
Tue, 28 January 2003 05:13  |
Venaktesh
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
Even though u have mentiond the default tablespace for the user while importing itis usingthe dump.
In the dump ther might be syntax that creat table ...
table space system.
So that' why while importing itis taking system tablespace.Which is nothing but explicityly u r mentioning that use system tablespace for this table.
Since BILL has got DBA role he can able to create tables on all the tablespace .He has got unlimited quota on all the tablespace.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
