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: 26766
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: 826
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: 21823
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: drawbacks of extensive import/export cycles
Next Topic: export problem
Goto Forum:
  


Current Time: Mon Dec 23 12:12:46 CST 2024