<div>
What OS? <br />
What is the question?<br />
<br />
The syntax for export can be found with: exp help=Y<br />
<br />
The easiest is: exp username/password@FRO8A full=Y file=FRO8A.dmp<br />

</div>


What OS?
What is the question?

The syntax for export can be found with: exp help=Y

The easiest is: exp username/password@FRO8A full=Y file=FRO8A.dmp


<div>
Sorry. &nbsp;OS: Solaris 10.<br />
<br />
After the exp I want to drop the tables of FRO8A. Just not sure of the syntax.<br />
<br />

</div>


Sorry.  OS: Solaris 10.

After the exp I want to drop the tables of FRO8A. Just not sure of the syntax.



<div>
Is FRO8A a schema, a database or both?<br />
<br />
Drop just the tables or the entire schema and all objects?<br />

</div>


Is FRO8A a schema, a database or both?

Drop just the tables or the entire schema and all objects?


<div>
A database.<br />
<br />
Drop the tables and the entire schema and all objects.
</div>


A database.

Drop the tables and the entire schema and all objects.

<div>
&gt;&gt;&gt;A database.<br />
&gt;&gt;&gt;Drop the tables and the entire schema and all objects. <br />
<br />
That's sort of contraditing.<br />
<br />
Do you really want to drop the entire database?<br />
<br />
or just a schema (user and associated objects) within the database?
</div>


>>>A database.
>>>Drop the tables and the entire schema and all objects.

That's sort of contraditing.

Do you really want to drop the entire database?

or just a schema (user and associated objects) within the database?

<div>
I would probably use dbca (Database Configuration Assistant) to drop the database.
</div>


I would probably use dbca (Database Configuration Assistant) to drop the database.

<div>
There is also a drop database sql command if you prefer:<br />
<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFJHED" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFJHED</a>
</div>


There is also a drop database sql command if you prefer:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFJHED [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#CACFJHED]

<div>
if use are just trying to drop a schema then<br />
<br />
<br />
drop user THEUSERNAME cascade;<br />
<br />
<br />
if you do<br />
<br />
drop database;<br />
<br />
then you will still need to do some extra cleanup &nbsp;like pfile (but not spfile)<br />
alert logs, trace files, etc.
</div>


if use are just trying to drop a schema then


drop user THEUSERNAME cascade;


if you do

drop database;

then you will still need to do some extra cleanup  like pfile (but not spfile)
alert logs, trace files, etc.

<div>
sdstuber,<br />
<br />
Sorry for the lack of information. I want to drop some users and its associated objects. Not the entire database.
</div>


sdstuber,

Sorry for the lack of information. I want to drop some users and its associated objects. Not the entire database.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I want to first export a database and then drop it.<br />
<br />
I want to do it using the SID but Im sure of the syntax to use. <br />
<br />
Could anyone help?<br />
SID: FRO8A<br />
<br />
Tks,<br />
Joao
</div>
</div>


Hi,

I want to first export a database and then drop it.

I want to do it using the SID but Im sure of the syntax to use. 

Could anyone help?
SID: FRO8A

Tks,
Joao

Oracle 10g - imp/exp then drop

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.