Home » RDBMS Server » Server Utilities » restore a package only with original import utility (oracle 10.2)
restore a package only with original import utility [message #588823] Fri, 28 June 2013 11:59 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
you can only import the schema that owns the procedure along with ROWS=NO
Re: restore a package only with original import utility [message #588826 is a reply to message #588825] Fri, 28 June 2013 12:06 Go to previous messageGo to next message
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?
Re: restore a package only with original import utility [message #588827 is a reply to message #588826] Fri, 28 June 2013 12:07 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
When all else fails Read The Fine Documentation!

imp help=yes

FROMUSER
Re: restore a package only with original import utility [message #588828 is a reply to message #588827] Fri, 28 June 2013 12:09 Go to previous messageGo to next message
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!
Re: restore a package only with original import utility [message #589135 is a reply to message #588826] Tue, 02 July 2013 10:08 Go to previous message
LKBrwn_DBA
Messages: 449
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:
  


Current Time: Sun Dec 21 16:18:07 CST 2014

Total time taken to generate the page: 0.04940 seconds