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

Thread: export and import

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Red face export and import

    Assuming that I have taken a full database export of a database and I want to import it that to another database on the same machine. I know how to do that if I have to import it to the same database (recover) but not another database. Specifically, how do I do that? An example will be appreciated
    I am running 8i on a UNIX platform

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if byou wanna import to another database using full option make sure the paths of datafiles that form the tablespaces are present

    for example
    original database: tablespace data is formed by data.dbf in /OTACLE/DBS

    if you wanna import to another machine make sure /ORACLE/DBS exists.
    If it's same machine you better go with user imports rather using full exports, you can still use the same export file though. This is because obviously you cant have 2 file with same name in same path in same machine.

  3. #3
    Join Date
    Nov 2000
    Posts
    169
    OK, Pando. This is well understood. Now Assuming I have taken a full database export and I want to import user tables to another database on the same machine, How do I do that?
    Can you please give me specific examples importing to another database on the same machine?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well instead of using full=y you use

    userid=xxxxxx
    file=xxxx
    log=xxxx
    fromuser=user=you_exported_from_another_db
    touser=user_you_want_to_import


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