Home » RDBMS Server » Backup & Recovery » Importing pocedures funcations packages triggers
Importing pocedures funcations packages triggers [message #226474] Fri, 23 March 2007 23:39 Go to next message
anitar
Messages: 4
Registered: January 2007
Location: Aurangabad
Junior Member
hi all,
i want to know is it possible -only to import proceduers,functions and packges from a dmp file
if yes ? how we can do that? and as if we are not importig the tables so is it not possible to import the triggers


regards

anitar
Re: Importing pocedures funcations packages triggers [message #226475 is a reply to message #226474] Fri, 23 March 2007 23:44 Go to previous messageGo to next message
BlackSwan
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
IMO, NO.
Re: Importing pocedures funcations packages triggers [message #226480 is a reply to message #226475] Sat, 24 March 2007 01:02 Go to previous messageGo to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
assuming that ur requirment is only to get "import proceduers,functions and packges", you could use dbms_metadata package to get their ddls.
Re: Importing pocedures funcations packages triggers [message #226532 is a reply to message #226480] Sat, 24 March 2007 13:27 Go to previous message
Littlefoot
Messages: 21151
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Alternate solution is to do a "fake" import by using the SHOW=Y and LOG=some_logfile.txt options. It would NOT import anything, but will enable you to edit 'some_logfile.txt' file, take out all CREATE PROCEDURE/TRIGGER/whatever code you need and execute it.
Previous Topic: ora-600[6002]
Next Topic: allocating channel for backup, help
Goto Forum:
  


Current Time: Wed Aug 23 22:09:43 CDT 2017

Total time taken to generate the page: 0.01526 seconds