Oracle 7.2.2 and Oracle 9i [message #54586] |
Fri, 22 November 2002 09:46 |
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 !!
|
|
|
|
|