OraFAQ Forum: Server Utilities » restore a package only with original import utility

Home » RDBMS Server » Server Utilities » restore a package only with original import utility (oracle 10.2)

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

restore a package only with original import utility [message #588823]

Fri, 28 June 2013 11:59

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

I am trying to restore a package only from a dump file that was exported by original exp command. I know you can do it with data pump, but unfortunately this is dump file is not exported by expdp. Can I do that. I really do not want to import the whole database.

Thanks!

[Updated on: Fri, 28 June 2013 11:59]

Report message to a moderator

Re: restore a package only with original import utility [message #588825 is a reply to message #588823]

Fri, 28 June 2013 12:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

you can only import the schema that owns the procedure along with ROWS=NO

Report message to a moderator

Re: restore a package only with original import utility [message #588826 is a reply to message #588825]

Fri, 28 June 2013 12:06

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

so this will restore all tables,SPs, views, packages.. just no data, right? how could I map to a different schema then since I do not want to overwrite anything else?

Report message to a moderator

Re: restore a package only with original import utility [message #588827 is a reply to message #588826]

Fri, 28 June 2013 12:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When all else fails Read The Fine Documentation!

imp help=yes

FROMUSER

Report message to a moderator

Re: restore a package only with original import utility [message #588828 is a reply to message #588827]

Fri, 28 June 2013 12:09

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

My bad, totally forgot about fromuser and touser since I have not use exp and imp for long time.
Thank you so much!

Report message to a moderator

Re: restore a package only with original import utility [message #589135 is a reply to message #588826]

Tue, 02 July 2013 10:08

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

How about creating a text file and extracting the package definition from there?

 imp / FILE=expdat.dmp SHOW=Y FULL=Y > expdat.txt

[Updated on: Tue, 02 July 2013 10:19] by Moderator

Report message to a moderator

Previous Topic:	"kfed read" online log outdated, while asmcmd cp is right
Next Topic:	Import a Flat File into Oracle and update another table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:42:09 CST 2025