import question

[pascal01]

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

[seelan]

Ya,
If the table already exists

You can import the table with ignore=Y. Hope it will work properly.

Seelan

[pascal01]

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?

[justadba]

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.

[hacketta1]

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