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

Thread: deleting schema user

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    deleting schema user

    i have a schema user in oracle. so if i removed this schem auser then all my data is lost?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Re: deleting schema user

    Originally posted by yls177
    i have a schema user in oracle. so if i removed this schem auser then all my data is lost?
    You should still have all of your backups. But yes, when you drop a user, the user gets dropped along with all of his data.

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    I'm not sure myself, so i'm just throwing this into the arena, but what would happen if you dropped the user WITHOUT the cascade option?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    if you dont supply cascade it wont drop.

    Code:
    SQL*Plus: Release 9.2.0.4.0 - Production on Thu Sep 16 09:57:45 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
    With the Partitioning option
    JServer Release 9.2.0.4.0 - Production
    
    SQL> grant connect, resource to dave identified by dave;
    
    Grant succeeded.
    
    SQL> connect dave/dave
    Connected.
    SQL> create table test (num number);
    
    Table created.
    
    SQL> 
    SQL> 
    SQL> connect / as sysdba
    Connected.
    SQL> drop user dave;
    drop user dave
    *
    ERROR at line 1:
    ORA-01922: CASCADE must be specified to drop 'DAVE'
    
    
    SQL>

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Ah ok. Cheers.

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