OraFAQ Forum: Server Utilities » exporting using exp

Home » RDBMS Server » Server Utilities » exporting using exp

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exporting using exp [message #256999]

Tue, 07 August 2007 06:39

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

Report message to a moderator

Re: exporting using exp [message #257008 is a reply to message #256999]

Tue, 07 August 2007 06:58

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, they are.

Btw, exp is not a backup method.

Regards
Michel

Report message to a moderator

Re: exporting using exp [message #257089 is a reply to message #257008]

Tue, 07 August 2007 10:14

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 10:06:55 CST 2024