OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Partial export

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

Partial export [message #194930]

Tue, 26 September 2006 04:08

akouatica
Messages: 6
Registered: November 2005

Junior Member

Hi,

I've a database of 3500 tables . I'd like to perform to backup
1) - one backup for 4 big tables only
2)- one backup for all other tables ( without the 4 big tables)

Please can you help me for the second step (export all tables without 4 tables) ?

Regards

Report message to a moderator

Re: Partial export [message #194985 is a reply to message #194930]

Tue, 26 September 2006 07:37

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

Try writing a script which reports all tables except those 4 and then place output of query in format of export utility.
e .g
select 'exp file=abc.dmp log=abc.dmp tables=||(genreate your table list here)' from dba_tables where table_name not in (your 4 tables which need to be excluded)

Put this sql stmt in shell script...Spool output of sql stmt in a file and then run that file from shell script.

Sandeep

Report message to a moderator

Re: Partial export [message #195100 is a reply to message #194985]

Wed, 27 September 2006 01:50

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Or if you are using 10g then you can use EXCLUDE parameter with "expdp"....

Report message to a moderator

Previous Topic:	Freaking ORA-31626: job does not exist
Next Topic:	how to export oracle9i database from windowxp os

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 15:23:51 CDT 2024