Importing pocedures funcations packages triggers [message #226474] |
Fri, 23 March 2007 23:39 |
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 #226532 is a reply to message #226480] |
Sat, 24 March 2007 13:27 |
|
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.
|
|
|