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

Thread: Export / Import

Hybrid View

  1. #1
    Join Date
    May 2001
    Posts
    49

    Question

    I am trying to export all the tables from Scott schema and I created a
    Parameter file

    FILE=scott.dmp
    TABLES=(*)
    ROWS=Y
    COMPRESS=Y
    feedback=10

    I issued command C:\>exp scott/tiger parfile=abcd.dat

    I got warning EXP-00011:Scott.* does not exist
    Export terminated successfully with warnings.


    I tried to do Import c:\>imp sys/sys parfile=scott.dat
    My parameter file is

    file=scott.dmp
    fromuser=scott
    touser=mery
    tables=(*)
    ignore=y

    Import terminated successfully without warnings


    Now when I connect as user mery and issued command
    select * from tab;
    I get no rows selected.
    What is the problem over here??
    Any Help..
    Thanks
    Rekha

  2. #2
    Join Date
    Mar 2001
    Posts
    635
    Hi

    Just change the files with the following contents

    1) abcd.dat

    file=scott.dmp
    feedback=10

    2) scott.dat

    file=scott.dmp
    fromuser=scott
    touser=mery
    ignore=y

    Then Execute the export as follows

    c:\> exp scott/tiger parfile=abcd.dat

    By Default it will export all objects of the user to the dmp file by the name scott.dmp will be created

    Then Execute the import as follows

    c:\> imp sys/change_on_install parfile=scott.dat

    I have used the password as change_on_install because that is the default password of sys which you might have allready changed.Before executing make sure the user mery has connect,resource privilege

    Regards
    Santosh

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi rekha,
    U cannot use * in tables parameter.In order to take the export of all the tables in SCOTT user schema use OWNER=SCOTT in ur parameter file .
    The correct syntax of ur paramter file will look like this
    e.g. a.txt

    userid=scott
    file=scott_exp.dmp
    log=scott_exp.log
    owner=scott
    rows=y
    indexes=y
    consistent=y

    Run the export with the following command
    c:\>exp parfile=a.txt


    Similarly for importing data u can use the following paramter file and comand

    e.g. b.txt
    userid=scott
    file=scott_exp.dmp
    log=scott_imp.log
    fromuser=scott
    touser=scott
    rows=y
    indexes=y

    Run the following command with the import command

    c:\>imp parfile=b.txt


    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    May 2001
    Posts
    49
    Thanks
    Rekha

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