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

Thread: Tables missing after ALTER DATABASE CHARACTERSET

Threaded View

  1. 02-17-2009, 05:08 PM #1
    rshivagami
    rshivagami is offline Senior Member
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Tables missing after ALTER DATABASE CHARACTERSET

    The charactersets in one of my databases was changed from UTF8 to AL32UTF8 to support some XML data. The change was performed by someone else by issuing 'ALTER DATABASE CHARACTER SET AL32UTF8; ' . There were no errors and the database came back up , but after some time I noticed that some of the tables that had CLOB datatype columns are missing - meaning the tables are totally gone. I am not sure if this is related to the characterset change - I hope it is not. What is the best way to find this out ? I do not have auditing turned on. Where can I check ? It is Oracle 11g.

    Thanks.
    Last edited by rshivagami; 02-17-2009 at 05:35 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width