Home » RDBMS Server » Server Administration » Oracle 7.2.2 and Oracle 9i
Oracle 7.2.2 and Oracle 9i [message #54586] Fri, 22 November 2002 09:46 Go to next message
Amit Kumar
Messages: 23
Registered: July 1999
Junior Member
Hi !!
We were at oracle 7.2.2 and have recently installed oracle 9i on another machine. I understand we cant dirrectly move to oracle 9i without going through 7.3.4 first.

However, my database is really small ( fewer than 14 tables each with a couple of thousand records).

I am wondering ..
1) Can I create a new table structure in 9i and directly insert all my records in it ? I need to access it through forms 4.5 and reports 2.5.
2) If i can, do u know of any scripts which do reverse of sqlldr ? That is, they give me records from oracle 7.2.2 in a format which i can feed to sql loader in 9i.

Again thanks to all of you !!
Re: Oracle 7.2.2 and Oracle 9i [message #54589 is a reply to message #54586] Fri, 22 November 2002 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
option 1:

  create a flat file (csv) of records from 7.3.4 db
  recreate the same structure of tables in 9i.
  load these data into 9i using sqllodr

option 2: (not very sure if this works).
  create a database link to 7.3 database(lets call it 734db)in  9i database
  from 9i database issue something like
       create table new_emp as select * from scott.old_emp@734db;

  

Re: Oracle 7.2.2 and Oracle 9i [message #54593 is a reply to message #54586] Fri, 22 November 2002 12:21 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
DB Link will NOT get the constraints (neither will option 1). You will need to create them IN THE RIGHT ORDER, after ALL the data has been loaded.

Good luck.
Previous Topic: locally Managed tablespaces
Next Topic: average row size
Goto Forum:
  


Current Time: Fri Sep 20 02:41:30 CDT 2024