OraFAQ Forum: Server Utilities » How to take backup for only tables not other objects

Home » RDBMS Server » Server Utilities » How to take backup for only tables not other objects (Oracle9i ,Windows)

Wed, 21 November 2007 00:46

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,
How to take export for tables only not releated objects like views,procedure..

what is the command?

Wed, 21 November 2007 00:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You have to use logical backup method using EXPORT utility.
use EXP utility with TABLES keyword.
cmd>emp help=y ---for more details.

Wed, 21 November 2007 01:10

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't understand what you want.
Do you want to export only tables that are not referenced by view or procedure?

Regards
Michel

Previous Topic:	How to accept dynamic file name (file name format : FN_DDMMYYYY.DAT )for SQL Loader ?
Next Topic:	DataPump Error

Goto Forum:

]

Current Time: Sun Jun 30 01:55:33 CDT 2024