Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2015
    Posts
    1

    Unanswered: Changing tablespace for sys.aud$ table

    I have to restart the database or stop the audit_trail before i change the tablespace for this table?


    I need to do this cause tablespace system is growing a lot.

    Thanks for help.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Depending upon what exactly you plan on doing, you may make a change such that Oracle will no longer support your DB.

    No, you don't need to stop AUDIT prior to making any change.
    The records will either end up in the old or new tablespace.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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