Home » RDBMS Server » Server Utilities » import data from 8.1.6 to ora 9.2
import data from 8.1.6 to ora 9.2 [message #73753] Thu, 01 July 2004 00:46 Go to next message
zaenul
Messages: 1
Registered: July 2004
Junior Member
hi.every body

I plan to upgrade my database from 8.1.6 to 9.2

and I want to use export/import utility to upgrade my database.

Is  ora 9.2 support that method?

 
Re: import data from 8.1.6 to ora 9.2 [message #73754 is a reply to message #73753] Thu, 01 July 2004 02:39 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Just use export utility of ur 8x DB and import of ur 9X DB. There is no other related issue.

Daljit Singh
Re: import data from 8.1.6 to ora 9.2 [message #73768 is a reply to message #73754] Thu, 08 July 2004 00:55 Go to previous message
hh5721
Messages: 1
Registered: July 2004
Junior Member
Make sure:

1). Datafile size (ora9.2) is same or more than (one of table initial extent) in same tablespace.

2) Create tablespace name at ora9.2 same as at ora8.1.6. If not, default user tablespace will be placed.

TQ.
Previous Topic: Sql Loader
Next Topic: Very long import running time
Goto Forum:
  


Current Time: Mon Jul 01 09:08:26 CDT 2024