Re: Export only tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 31 Mar 2001 16:44:47 +0200
Message-ID: <tcbruv4389uh5c@beta-news.demon.nl>

"LeguMan" <leguman_at_hotmail.com> wrote in message news:3ac5e6c6$0$27802$456d72a3_at_news.skynet.be...
> Hello,
>
>
> How can i export only all tables (not the user) from a database in Oracle
8i
> entreprise NT4
>
> Ps: Oracle Management Server not running
>
>
> I have find the exp command but i don't find the syntax.
>
>
>
> Thanks,
> LeguMan
>
>
>

The syntax is in the Oracle Server Utilities Manual or by typing exp help=y In this particular case you need to export a single user, the create user statement is not exported. Views and the like can not be surpressed though.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Mar 31 2001 - 08:44:47 CST