OraFAQ Forum: Server Administration » How to use imp corretly when I have a lot of tables in oracle already.

Home » RDBMS Server » Server Administration » How to use imp corretly when I have a lot of tables in oracle already.

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

How to use imp corretly when I have a lot of tables in oracle already. [message #122037]

Thu, 02 June 2005 09:10

GuteNacht
Messages: 16
Registered: April 2005

Junior Member

I have to imp all the tables and views to oracle again.
But firstly I have to remove all the tables in oracle.

How to remove all the objects in oracle when the username is system?

Thank you very much!

Regards

Norah

Report message to a moderator

Re: How to use imp corretly when I have a lot of tables in oracle already. [message #122062 is a reply to message #122037]

Thu, 02 June 2005 11:24

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

Senior Member
Account Moderator

>>How to remove all the objects in oracle when the username is system?

Why do you want to remove the system objects?
Please do so, if you want to loose the support.

Report message to a moderator

Re: How to use imp corretly when I have a lot of tables in oracle already. [message #122790 is a reply to message #122037]

Wed, 08 June 2005 09:24

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

If you have created your tables / objects under system user ...then the best thing would be ...create a new user may be user1 ...and then do as below ..
1. export the system user ..
2. import the dump into user1 using fromuser=system and touser=user1
3. Manually drop the unwanted objects from user1 ...
4. manually drop your personal stuff from system user ..

Cumbersome ..but i dont see any other way ..

Sai Jeedigunta

Report message to a moderator

Re: How to use imp corretly when I have a lot of tables in oracle already. [message #122895 is a reply to message #122037]

Thu, 09 June 2005 01:29

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

Do you have created your objects under system schema?

I never heard someone ever wants to drop system tables? Could you please provide more info?

Report message to a moderator

Re: How to use imp corretly when I have a lot of tables in oracle already. [message #123309 is a reply to message #122037]

Sat, 11 June 2005 12:07

OLarry
Messages: 6
Registered: June 2005

Junior Member

I guess you meant you want to remove non-system tables but the tables you want to remove were created using system schema? I would use graphic tools to do this.. I know some tool will list system tables and non-system tables into two categories, so that you can safely drop tables/views... let me know if you are interested in this Oracle Admin tool.

Report message to a moderator

Previous Topic:	ODBC drivers
Next Topic:	Index-- 4 question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:22:21 CST 2025