Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: full export

Re: full export

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 09 Aug 1999 09:14:55 -0700
Message-ID: <37AEFE7F.7AEA9AFF@us.oracle.com>


Chris

The main parameter you need is full=y. When you're at the command prompt, issue exp80 help=y and you can see all the parameters. Some are incompatible with full=y, but really all you need are:

  1. A username/password that has been granted the EXP_FULL_DATABASE role (SYSTEM is an obvious candidate)
  2. The FULL=Y parameter

You may want to change the filename, buffer etc., but these two things are all that are mandated.

HTH. Pete

Christoph Kukulies wrote:

> I want to export (EXP80) a DB with all its tables including all users
> synonyms, views etc.
>
> How can I do it using EXP80/IMP80 command line tools?
>
> (This is Oracle 8.0.5)
>
> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de

--
Regards

Pete


Received on Mon Aug 09 1999 - 11:14:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US