Home » RDBMS Server » Server Utilities » How to take backup for only tables not other objects (Oracle9i ,Windows)
How to take backup for only tables not other objects [message #282155] Wed, 21 November 2007 00:46 Go to next message
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?
Re: How to take backup for only tables not other objects [message #282161 is a reply to message #282155] Wed, 21 November 2007 00:59 Go to previous messageGo to next message
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.
Re: How to take backup for only tables not other objects [message #282167 is a reply to message #282155] Wed, 21 November 2007 01:10 Go to previous message
Michel Cadot
Messages: 64111
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: Mon Dec 05 15:12:41 CST 2016

Total time taken to generate the page: 0.07646 seconds