Home » RDBMS Server » Backup & Recovery » Partial export
Partial export [message #194930] Tue, 26 September 2006 04:08 Go to next message
Messages: 6
Registered: November 2005
Junior Member


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) ?


Re: Partial export [message #194985 is a reply to message #194930] Tue, 26 September 2006 07:37 Go to previous messageGo to next message
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.

Re: Partial export [message #195100 is a reply to message #194985] Wed, 27 September 2006 01:50 Go to previous message
Messages: 1080
Registered: June 2005
Location: India
Senior Member

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

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

Current Time: Sun Jul 23 12:16:14 CDT 2017

Total time taken to generate the page: 0.11283 seconds