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: 64119
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: Tue Dec 06 08:24:39 CST 2016

Total time taken to generate the page: 0.11587 seconds