DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Archiving Data

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    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
    On the other hand, you have different fingers.

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    You could export the data and then import it under the schema of a different user.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Jul 2001
    Location
    Minneapolis
    Posts
    15
    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!

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width