| Export from 8i to 9i and then from 9i to 8i possiblibilty! [message #74083] |
Fri, 03 September 2004 22:29 |
S. M. Waqas Shabir
Messages: 30
Registered: January 2004
|
Member |
|
|
Hi
I have a database in which i unknowingly done a mistake, i.e., I followed a wrong convention in naming column names.
Now the database has been deployed and have 200 hundred rows in it. i.e It has started its operation formally.
I now have to modify it so as to remove this blunder at this level to avoid further confusions.
My idea is that i install oracle 9i on a backup system. Export the database into that 9i.
Modify column names there as it is very easy in 9i as "alter table modify old-column-name to new-clumn-name"
and then import it back to this main server.
I think this way i will be able to resolve this problem of bad conventioning.
Am i thinking in the right direction? How accurate am i in this appraoch? Any further suggestions will be highly appreciated.
One more point. I dont have extra ordinary knowledge of oracle. I just know a vivid view of oracle and its structure.
Please help!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
