OraFAQ Forum: Server Utilities » Solution to move user objects to new

Home » RDBMS Server » Server Utilities » Solution to move user objects to new_tablespace

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

Solution to move user objects to new_tablespace [message #73480]

Sun, 09 May 2004 03:01

Deepak Bisht
Messages: 13
Registered: October 2001

Junior Member

hi,
i'm using 8.0.6 and having problem with exp80/imp80 utility. i created my tables in system tablespace
and now i want to move tables from system tablespace to new tablespace.for this i m using imp80 command
but i found some of the objects which i created in system tablespace r not imported in my new tablespace like synonms,procedures,grants.

Report message to a moderator

Re: Solution to move user objects to new_tablespace [message #73483 is a reply to message #73480]

Mon, 10 May 2004 06:57

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

I'm not sure I understand your problem - synonyms, procedures and grants don't belong to a tablespace. They are owned by a user(schema) and their definitions are stored in the data dictionary located in the SYSTEM tablespace.

Best regards.

Frank

Report message to a moderator

Previous Topic:	calling sqlldr from my oracle forms
Next Topic:	update and insert using sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:22:06 CDT 2024