Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Unhappy Unanswered: Exporting tables ?

    Hi folks,

    I have small problem........

    I just want to export tables alone from a database and import the same to my database.I dont want other objects like view,storedprocedure,packages and functions to be imported into my database.


    Thanx in advance
    Regards
    Sree

  2. #2
    Join Date
    Jun 2004
    Posts
    2

    export-utility

    hi!

    There exists a parameter-driven oracle-export tool.
    Under Oracle-DB 9.2 for Windows the program is called exp.exe and is located in the oracle-home\bin.

    For more information see the oracle doc for export/import utility
    (http://download-west.oracle.com/docs...1.htm#SUTIL001)

    best regards
    klaus

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    All Oracle versions (at least since Oracle 7; I "saw" Oracle 5 - can't tell I worked with it really) have export utility (just to make clear that export isn't restricted to Oracle 9.2 and Windows platform).

    Of course, it is necessary to read documentation about it to fully understand its capabilities, but - to make a long story short - use the tables parameter to export only tables. For example,

    EXP un/pw TABLES=(table1, table2, ..., tablex) FILE=tabexp.dmp

    To import the tables, you don't have to list them - simply use

    IMP un/pw FILE=tabexp.dmp
    Last edited by Littlefoot; 07-06-04 at 05:03.

  4. #4
    Join Date
    Oct 2003
    Location
    India
    Posts
    55
    Thank you very much.

    Infact i am currently using the exp utility only thing i wanted to know was to how to restrict the export only to tables.
    What is that i have to do if i have to export all the tables.


    Thanx & Regards
    Sree

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm afraid you'll have to list them all ... At least I don't know how to avoid it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •