Importing pocedures funcations packages triggers [message #226474] |
Fri, 23 March 2007 23:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|