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

Thread: exp of packages,functions,triggers

Hybrid View

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    Is there any way just to export packages,functions,triggers,views etc but without tables and its data? what is the proper syntax? Thanks for help.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    The best thing will be to use a Schema generation tool and use Reverse Engineering to create the SQL for the functions, procedures, triggers etc.

    But if you don't have such a tool and must use Export/Import then you will have to export at least at USER level to export the procedures, functions etc.

    There is a parameter ROWS that you can set to 'N' so that it does not export the table data.

    It will still export the table definitions though.

    In the database where you want to import, it will create the empty tables if they don't already exist (in this case you can drop those tables after the import)

    If the tables already exist it will show error (you may set IGNORE=Y to ignor esuch errors) and import the procedures, functions triggers etc.

    - Rajeev
    Rajeev Suri

  3. #3
    Join Date
    Jul 2000
    Posts
    296
    You can create a script to create these objects from the data dictionary views, USER_SOURCE, USER_VIEWS and USER_TRIGGERS.

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