Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1220
  • Last Modified:

Remove an entire schema

How to remove an entire schema from the command line in SQLPLUS? Oracle 9i
what rights should DBA have?
Service = Bugs
Schema = Lefteye


Drop schema didn’t work. Or I just typed it wrong. 
0
Martin_01
Asked:
Martin_01
  • 2
  • 2
1 Solution
 
gvsbnarayanaCommented:
Hi,
   You can connect to the database using a DBA privileged user name and drop the user like this:
Drop user lefteye cascade;
This is an irreversable action and all objects belonging to this user and the username is also dropped.
HTH
Regards,
Badri.
0
 
sujith80Commented:
To be on the safe side, keep an export dump of the schema before drop.
0
 
Martin_01Author Commented:
so after I log in I would type "Drop user lefteye cascade;"
0
 
gvsbnarayanaCommented:
Yes, but make sure that there is no session open with the username lefteye ... if any session is open with a username, then you can't drop that user.
HTH
Regards,
Badri.
0
 
Martin_01Author Commented:
Thanks :)
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now