DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: import question

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Ya,
    If the table already exists

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

    Seelan

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    222
    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?

  4. #4
    Join Date
    Apr 2001
    Posts
    108
    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!

  5. #5
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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
  •  


Click Here to Expand Forum to Full Width