OraFAQ Forum: Server Utilities » How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ?

Home » RDBMS Server » Server Utilities » How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ?

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

How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ? [message #70628]

Tue, 09 July 2002 04:01

marjo
Messages: 9
Registered: January 2002

Junior Member

Hello Friends:
I want to export my entire database from one server to another. But I don't want a particular table to get exported. There are hundreds of tables each having lakhs of records. There are only two users in my DB.
a]] FUEL
b]] GAR
Suggestions will really be appreciated.
Bye.
Marjo.

Report message to a moderator

Re: How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ? [message #70630 is a reply to message #70628]

Tue, 09 July 2002 07:11

Grant
Messages: 578
Registered: January 2002

Senior Member

There isn't an exclude. Your options are, drop the table before export, drop the table after export, or do a select on the tables you want with the TABLES option.

Report message to a moderator

Re: How to Exclude Just One Table but take the FULL DB BACKUP using Exp/Imp in Oracle8i ? [message #70764 is a reply to message #70628]

Sun, 21 July 2002 20:52

sunil bhola
Messages: 58
Registered: July 2002

Member

I will tell you how to do it, but give a day

Report message to a moderator

Previous Topic:	How to use a Query in the Export utility
Next Topic:	EBCDIC and the WHEN clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 06:34:05 CST 2024