RE: exp from 7.3.4 and imp to 9.2.0.4 question
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'sonja.sehovic@xxxxxx'" <sonja.sehovic@xxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 3 Feb 2005 08:30:36 -0500
Sonja,
A simple way of doing this is to not perform a full export. Just =
export the
schema/users that have data. This is my preferred method of =
export/import.
Tom
-----Original Message-----
From: Sonja =A9ehovic [mailto:sonja.sehovic@xxxxxx]=20
Sent: Thursday, February 03, 2005 6:35 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: exp from 7.3.4 and imp to 9.2.0.4 question
Hi,
I'm planning to move my old database which is Oracle 7.3.4 to Oracle =
=3D
9.2.0.4 with exp/imp utility
I've test it with full exp and full imp and it works just fine. But, =
=3D
when I checked imported objects, I noticed that with users objects also =
=3D
arrived some SYSTEM objects from the old version.=3D20
So, I've been wondering is there any way I can prevent oracle from =3D
importing old SYSTEM object into the new database? I know I can do that =
=3D
with importing FROMUSER, TOUSER but I'd rather avoid it.
TIA,
Sonja
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
