| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export/Import question
Thanks Tom and others that replied,
That was the explanation that I needed. I also was informed that exporting with COMPRESS=Y is a mistake due to sizing issues so I will do another export with COMPRESS=N.
Dave
-----Original Message-----
Sent: Tuesday, September 04, 2001 3:48 PM
To: Multiple recipients of list ORACLE-L
Dave,
You will need to create the tablespaces before you do the import. When you create the tablespaces, you will be creating the physical files to support those tablespaces.
Import simply imports data to tablespaces (or, optionally, other tablespaces).
Sooo, when you re-create your new tablespaces, you can place the physical files anyplace you want on the new server.
hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Tuesday, September 04, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L
I have a question about how the export/import utility works. My situation is that damagement had me put my live and test environments on the same server. Now they realize that this is not a good situation(test has crashed the server a few times and required a re-boot, imagine that). I have Oracle 8.1.7 running on Windoze NT 4.0. I have to move my live database to another server. From reading the fine manuals and from posts that I have seen I have decided to use the export/import utility to make my move. My database is inactive for the weekend. What I am not sure of is this, on my current live database my datafiles(.dbf) reside on drive E. The server I am moving to has a drive F that will be for my data. I have done the export using this command;
EXP MY_NAME/MY_PASSWORD FILE=C:\MY_DUMP.DMP FULL=Y COMPRESS=Y The export ran with no errors or warnings. Now, since my datafiles reside on drive e will the import then be looking for drive e to place the data in. I do not see any option to specify where I want the data to go. Or if I run the import from the f drive of the destination server will the import utility place the data in drive F.
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 05 2001 - 05:40:30 CDT
 |
 |