-
All -
Oracle 8.1.5 running on Solaris 7
I have a table with many records (55 million), and i need/want to archive the majority of the data. I want to create another table that contains the archived data, but when I try to populate the table, the system just hangs.
I have tried:
CREATE TABLE radlog_archived AS select * FROM usage_radlog;
but that just gives me errors on the size of the temporary space, etc...
I was wondering if anybody could tell me how to do this..
Thanks,
R
-
You could export the data and then import it under the schema of a different user.
-
You're probably running out of redo log and rollback space. You can try using the nologging option. Just remember that the table will be unrecoverable until the next backup as creation and all transactions will not be logged.
Another option... depending on how many records out of the 55 million you need to keep, it's possible you could do an export/import to a different user and then delete the records you don't need. Just make sure you have enough rollback to do that.
Good luck!
-
What I meant was you could export the table and then import it into a different schema. I would try it in TEST first.
Good luck.
-
I would create radlog_archived empty. I would then populate radlog_archvied from usage_radlog based on some criteria, such as date. Between each "batch", commit your changes.
Otherwise, you might want to look at partitioning.