Home » RDBMS Server » Server Administration » Importing into other Tablespaceof a dmp Exported from SYSTEM Tablespace
Importing into other Tablespaceof a dmp Exported from SYSTEM Tablespace [message #63455] Wed, 06 October 2004 22:40 Go to next message
etryblr
Messages: 28
Registered: December 2003
Junior Member
Hi

I have a dmp exported from SYSTEM TableSpace.I have a USER (Say XYZ)whose default TableSpace is not SYSTEM. And when i import this dump into XYZ, objects are defaulting to SYSTEM Tablespace and not in to the default TableSpace for XYZ.

I want to know hw i can import the objects into the default TableSpace for XYZ.

Thanks in advance

Prashanth

 

Report message to a moderator

Re: Importing into other Tablespaceof a dmp Exported from SYSTEM Tablespace [message #63462 is a reply to message #63455] Thu, 07 October 2004 03:03 Go to previous message
Anu
Messages: 82
Registered: May 2000
Member
Hi!
you just grant quota 0 (zero) on system tablespace to XYZ and specify quota on default tablespace to XYS.

hope this helps,
Anu

Report message to a moderator

Previous Topic: Problem in starting oracle 6 under dos(novell)
Next Topic: import error ora-01874 time zone
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 14:21:32 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.