Re: Export user

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/22
Message-ID: <956406031.23621.0.pluto.d4ee154e@news.demon.nl>#1/1

Szymon Manduk <sm_at_profidata.com.pl> schreef in berichtnieuws tweM4.29628$hK2.582740_at_news.tpnet.pl...
> Hello !
>
> Is it possible to export user and all his objects from one database and
> import to another ?
>
> TIA
>
> Simon
>
> Oracle8i 1.5.0 / Windows NT
>
>
>
>

Yes,
in parameter mode use
exp username/password@<database> file=<filename> owner=<youruser> compress=N log=<any filename> buffer=8192000

Then pre-create the user on the target database (the export file won't do that for you) and import the file.

To get a list of options for exp and imp use exp help=y or imp help=y.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Apr 22 2000 - 00:00:00 CDT