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

Thread: Using import to import a database

  1. #1
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear Moderator/members
    I have a dump file (about 1G) exported from a database with datafiles and binaries that was configured over many drives (C through Q). However, I want to import the same database into another database that resides on a different system with just one drive (C). My questions are the following:

    1) is such an import feasible
    2) how do I need to configure my one drive system in order to import the dump without crashing?

    Thanks in advance.
    roukie-dba

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Easiest way of doing is take cold/hot backup. Change the controfile to reflect Directory for all the datafiles and logfiles. In your case c:..\

    Then copy all the files. And start the database
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    I feel imports are not dependent on where the datafiles are located or drives becaue they interact with the logical design of the database and that is going to be tablespaces.

    Perform a full database export on the source database

    You can create the database and then tablespaces in the target database and perform a full import with the parameter

    ignore=y

    when importing the data to the new database

    Regards
    Santosh

  4. #4
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226

    Thumbs up

    Great suggestions once more Kishore and Santosh. Once more, a big thank you to both of you. You guys are an asset to this forum!!!
    roukie-dba

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Kishore
    Easiest way of doing is take cold/hot backup. Change the controfile to reflect Directory for all the datafiles and logfiles. In your case c:..\

    Then copy all the files. And start the database
    Even easier:
    1. take a cold backup
    2. use the subst command to assign drives D:-Q: to the same directory
    3. startup database
    Jeff Hunter

  6. #6
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Replies to

    1) SANTOSH
    Santosh, when I create the new tablespaces in my single drive, new database, am I supposed to maintain the same configurations e.g. initial extents...and all the rest before doing the export?

    2) KISHORE
    Kishore, with respect to changing the control file to reflect my new db structure, say I have my system TS in my source database having datafile on M:\... and now have to move it to C:\... in my new database, please give me detail example how to rename the control file using the above so I can start my new db up without problems.

    3) JEFF
    Jeff, please expand on the SUBST command you mentioned. I don't know this command and do not know how to use it. Perhaps an example or two would be great.

    Many many thanks again.
    roukie-dba

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    subst is a ms-dos command, substitute Q: for C:

    SUBST [drive1: [drive2:]path]
    SUBST drive1: /D

    drive1: Specifies a virtual drive to which you want to assign a path.
    [drive2:]path Specifies a physical drive and path you want to assign to
    a virtual drive.
    /D Deletes a substituted (virtual) drive.

    Type SUBST with no parameters to display a list of current virtual drives.

  8. #8
    Join Date
    Mar 2001
    Posts
    635
    Hi

    You can keep the same configuration or change it according to your requirement before the full database import.

    Regards
    Santosh

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