OraFAQ Forum: Server Utilities » Will view be part of the dump?

Home » RDBMS Server » Server Utilities » Will view be part of the dump?

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

Will view be part of the dump? [message #177697]

Fri, 16 June 2006 02:22

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Will view definition be part of the oracle dump when we export the by schema(user)?

Report message to a moderator

Re: Will view be part of the dump? [message #177708 is a reply to message #177697]

Fri, 16 June 2006 02:59

aciolac
Messages: 242
Registered: February 2006

Senior Member

Try something like that:
>imp userid=system file=expdat.dmp show=y full=y

Option show=y shows only object definions which are in the dump file.

Report message to a moderator

Re: Will view be part of the dump? [message #177709 is a reply to message #177708]

Fri, 16 June 2006 03:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes, view definition is also contained in the .dmp file produced by the Export utility. How would you expect Import to make an exact copy of exported schema if it lacks in something (views, for example)? Would you create all those missing stuff manually?

Report message to a moderator

Re: Will view be part of the dump? [message #177720 is a reply to message #177709]

Fri, 16 June 2006 04:10

msgforsunil
Messages: 26
Registered: November 2005

Junior Member

Thanks for responses. I wanted to know, if in the current schema i have views, will the export command have the view as part of it?

Report message to a moderator

Previous Topic:	Impor error columns xmltype and clob
Next Topic:	How to gather the latest trace file info and insert into a table through forms?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 08:03:16 CST 2024