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
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.