-
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
-
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
-
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
-
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
-
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
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|