OraFAQ Forum: Server Utilities » Tablespace for Importing objects.

Home » RDBMS Server » Server Utilities » Tablespace for Importing objects. (Oracle 9i.2, Windows. )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace for Importing objects. [message #476027]

Mon, 20 September 2010 14:34

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Two different says in different documentation as below.

1) Import required same tablespace to fit the objects, otherwise it throws error.

2) Import by default uses the default tablespace to fit the objects, but some times it uses SYSTEM tablespace also.

please confirm with the correct one.

Thanks

Report message to a moderator

Re: Tablespace for Importing objects. [message #476029 is a reply to message #476027]

Mon, 20 September 2010 14:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

When you quote documentation, provide the link.

Report message to a moderator

Re: Tablespace for Importing objects. [message #476031 is a reply to message #476029]

Mon, 20 September 2010 14:49

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Both are wrong unless SYSTEM is the default tablespace.

Regards
Michel

Report message to a moderator

Re: Tablespace for Importing objects. [message #476035 is a reply to message #476031]

Mon, 20 September 2010 15:30

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Thanks...

1) Then how to import objects in a specific tablespace.

2) or else only way is moving objects from system tablespace to specific tablespace?

3) Or else can we set any specific tablespace as default other than System tablespace?

Thanks in advance.

Report message to a moderator

Re: Tablespace for Importing objects. [message #476039 is a reply to message #476035]

Mon, 20 September 2010 18:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

only SYSTEM or SYS schemas should create objects within SYSTEM tablespace.
Those who obey this rule don't have to be otherwise challenged.
DROP the objects & CREATE the objects in correct tablespaces.

Report message to a moderator

Re: Tablespace for Importing objects. [message #476053 is a reply to message #476039]

Tue, 21 September 2010 02:45

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Which means all the objects are getting imported in to the system tablespace, of system tablespace is default one?

1) if it is true additionally we have to move all the objects from system tablespace to appropriate tablespaces?
which will be burden on DBA, in case large amount of importing. Am I right.

2) Then how to avoid these scenario?

Thanks in advance.

Report message to a moderator