-
import question
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
-
Ya,
If the table already exists
You can import the table with ignore=Y. Hope it will work properly.
Seelan
-
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.
Eric Hanson
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|