| Export Import problem [message #69902] |
Mon, 18 March 2002 22:20  |
kothari Alpesh
Messages: 27
Registered: December 2001
|
Junior Member |
|
|
Hi all,
I have create one user named xyz by mistake i have given system tablespace as default tablespace. and import object in to it. but this is the wrong.
so i take export of this user then drop it and recreate it with default tablespace. but when i am importing this user then i will create all objects in the system tablespace. so what can i do to create objects in the default tablespace...
From
Alpesh Kothari
|
|
|
|
|
|
| Re: Export Import problem [message #69914 is a reply to message #69902] |
Tue, 19 March 2002 05:10  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
alter user USERNAME default tablespace TABLESPACE_NAME;
alter user USERNAME quota 0M on SYSTEM;
alter user USERNAME quota unlimited on TABLESPACE_NAME;
|
|
|
|
| Re: Export Import problem [message #69927 is a reply to message #69902] |
Wed, 20 March 2002 05:13 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Carnage is right but I would use SYSTEM to export/import. You may have a priv problem.
export system/manager full=y
imp system/manager fromuser=MDADM touser=AZFAR1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
