-
Hiii,I have a 8i table abc it contains 5000 rows.
I am migrationg all 8i tables from 8i to 9i by using dblinks.
I was migrated all tables except abc tables.
So ,i was looked the rows,some rows data has '&" symbol.
and that column data type is long.
1)i was export the abc table data and i was replace the & by and in export file.
2)i was created abc table in 9i by using sqlscript.
3)now i import the modified export file.
Now it is ok.
but we are delete ing the tables frequently for testing purpose.
So any other solution to migrate the abc table from 8i to 9i.
thanks
kavitha
-
Isn't it urgent also????
Sanjay
-
You can create another abc table with different name on the 9i database. So, you will have 2 abc tables with different name. Whenever you need to restore the abc table, just copy from the second abc table.
Susan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|