Home » RDBMS Server » Server Utilities » exporting using exp
exporting using exp [message #256999] Tue, 07 August 2007 06:39 Go to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Hi all,

I need a clarification..When we export a user's schema, do the associated triggers,procedures,functions also get exported along with the export dump? if not, then how to get the triggers,procedures,functions into another db when we import the export dump?

All the replies r welcome

nani
Re: exporting using exp [message #257008 is a reply to message #256999] Tue, 07 August 2007 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, they are.

Btw, exp is not a backup method.

Regards
Michel
Re: exporting using exp [message #257089 is a reply to message #257008] Tue, 07 August 2007 10:14 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
9i IMPORT/EXPORT

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/part1.htm#435787

10g IMPORT/EXPORT

http://download.oracle.com/docs/cd/B14117_01/server.101/b10825.pdf
Previous Topic: possible to use 'WHEN' in SQL Loader Control file to check for existing data in end table?
Next Topic: expdp utility hanged
Goto Forum:
  


Current Time: Sat Aug 19 00:26:56 CDT 2017

Total time taken to generate the page: 0.21441 seconds