"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).

Reply via email to