Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    67

    Unanswered: archival and purging

    Hi gurus,
    I am totally new to oracle.I am expert in MSSQL SERVER and just know the basics of oracle.
    I have a third party application which need to be archived and pugred on
    monthly basis, it has around 312 tables and few hundereds of indexes running
    on oracle8, total DB Size is 10GB,We are totally unaware of the DB Design.
    It is taking 2 days for archival and purging which is real painful.
    Even ,The vendor is unsure of the delay reasons.

    Can any one help us in identifing the bottlenecks.
    will removing index and recreating will help?
    any good urls on archival and purging on oracle.

    Thanks in advance
    Rgds
    Srinivas varanasi

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    what do you mean by archiving and purging ? you start with your application monthly from scratch???
    to get the design out of your schema you can reverse engineer it with erm-tools like powerdesigner (I'm working with..) or a couple of other even free-/shareware tools

    if you issue a command drop user <user> cascade on a 10GB Database it will last some time ...
    therefore it might be better to re-create to instance ...

Posting Permissions

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