<div>
Hi,<br />
&nbsp; &nbsp;You can connect to the database using a DBA privileged user name and drop the user like this:<br />
Drop user lefteye cascade;<br />
This is an irreversable action and all objects belonging to this user and the username is also dropped.<br />
HTH<br />
Regards,<br />
Badri.
</div>


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.

<div>
To be on the safe side, keep an export dump of the schema before drop.
</div>


To be on the safe side, keep an export dump of the schema before drop.

<div>
so after I log in I would type &quot;Drop user lefteye cascade;&quot;
</div>


so after I log in I would type "Drop user lefteye cascade;"

<div>
<div class="content wysiwyg-content">
How to remove an entire schema from the command line in SQLPLUS? Oracle 9i<br />
what rights should DBA have?<br />
Service = Bugs<br />
Schema = Lefteye<br />
<br />
<br />
Drop schema didn’t work. Or I just typed it wrong. &amp;#61516;<br />

</div>
</div>


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. &#61516;


Remove an entire schema

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.