How do I import store procedures,packages,triggers..etc without importing tables?
Is the following syntax correct.
Senario 1: For new store procedures then do:
imp system/aaa@bbb file=xxx.dmp log=xxx.log fromuser=john touser=john ignore=Y
Senario 2: For existing store procedures then do:
imp system/aaa@bbb file=xxx.dmp log=xxx.log fromuser=john touser=john ignore=N
If the table already exists
You can import the table with ignore=Y. Hope it will work properly.
I DO NOT want to import tables.... I just want to import new and modified store procedures and functions... Is the syntax in my previous example correct?
No, I don't believe exp & imp will do what you want. My suggestion would be to go out to www.sqltools.net and download the sqltools product. It's freeware and quite good. I use it to extract ddl from my Oracle databases.
There are 10 types of people in the world:
Those who understand binary and those who don't!
Import with show=y, and redirect the output to a file. Edit the file to include only the statements you require and then run it through sqlplus
Click Here to Expand Forum to Full Width