Home » RDBMS Server » Backup & Recovery » logical backup without a specific table
logical backup without a specific table [message #197657] Thu, 12 October 2006 03:46 Go to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
How can I take a logical backup of the database without taking the backup of one specific table? Actually I need to give this to our client but we don't want to give them backup of one specific table.

Report message to a moderator

Re: logical backup without a specific table [message #197707 is a reply to message #197657] Thu, 12 October 2006 06:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Define logical backup in your terms.
In my terms, Logical backup is something like an exported dump.
>>How can I take a logical backup of the database without taking the backup of one specific table?
So,
export the schema. Give the dump.

Report message to a moderator

Re: logical backup without a specific table [message #197861 is a reply to message #197707] Thu, 12 October 2006 23:54 Go to previous messageGo to next message
lokeshonline
Messages: 29
Registered: April 2006
Junior Member
I have a schema say XYZ. It owns 100 tables. Out of these there is one table say Table_1. I want to take the export dump of the schema XYZ but it should not include the table Table_1. Is there any way of doing it?

Report message to a moderator

Re: logical backup without a specific table [message #197942 is a reply to message #197861] Fri, 13 October 2006 06:32 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
in 10g you exclude a particular object.
In all lower editions you need to specify all the tables in TABLES=() parameter.
It would be easier to script this.
write a sql to spool the names of tables you want (select table_name from user_tables where table_name not in MY_TABLE) in csv format. save the file and user PARFILE option.
Search the board. Long back, I have already posted a script to do this.

Report message to a moderator

Previous Topic: Dropped System Scheam
Next Topic: Trying to recover dropped table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 18:41:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.