RE: 8.0.5 to 8.1.7 - export/import

From: Vikas Khanna <vkhanna_at_quark.co.in>
Date: Wed, 17 Apr 2002 01:28:21 -0800
Message-ID: <F001.0044634D.20020417012821@fatcity.com>

"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:ayyappan.subramaniyan_at_ssiworldwide.com] 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: ayyappan.subramaniyan_at_ssiworldwide.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vikas Khanna
  INET: vkhanna_at_quark.co.in

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 Apr 17 2002 - 04:28:21 CDT