Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Unanswered: Read Only Tablespace

    Hello, when I execute the sentence:
    alter tablespace SSC_DAT read only

    It takes a long time and doesn't finish.


    What can I do ???

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Just wait?

    PS: Oracle has to make sure there are no locks, etc. on objects in that tablespace.
    Last edited by LKBrwn_DBA; 10-11-04 at 14:01.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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