RE: 8.0.5 to 8.1.7 - export/import
"Oracle Database is Portable" means that it can be ported to any OS platform. Take a full Export of the database and then use the imp utility of Oracle to build the exact database what was there on the previous one. If you want to import certain objects then you need to create the tablespace with the same name as from where you took the export. If that tablespace is not existing then the default tablespace of the user in the Second database would be considered for the import. If the tablespace does exist then even if the users' default tablespace is not the one mentioned then also the object would be imported into the designated tablespace. Regards, Vikas Khanna -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Hi It is Possible to import from NT to Solaris. The table space name should be the same otherwise build the table and then import by ignoring the errors. Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.0.5 to 8.1.7 - export/import
Hi It is Possible to import from NT to Solaris. The table space name should be the same otherwise build the table and then import by ignoring the errors. Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 8.0.5 to 8.1.7 - export/import
Lisa: You should be fine moving this direction. (It's exporting from a newer release and importing into an older release where you need to take extra steps.) The steps you outline look perfect. Good luck! Barb > -- > From: YTTRI Lisa[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Tuesday, April 16, 2002 9:48 AM > To: Multiple recipients of list ORACLE-L > Subject: 8.0.5 to 8.1.7 - export/import > > Hi - > > I believe I can do this, but I would like some confirmation and or > warnings, > etc. We are migrating an application from 8.0.5 on NT to 8.1.7 on Unix > (Solaris 2.6). I would like to do this by creating the 8.1.7 instance and > then importing the data. Is it possible to export from the NT database > (using the 8.0.5 exp command) and then import into the 8.1.7 database on > Unix (using the 8.1.7 imp command)? > > Thank you- > > Lisa > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: YTTRI Lisa > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
