Re: .dmp file

that seems to be just what I need, so what is the reverse of this?

for exp???

Sybrand Bakker wrote:

> You need to
> create the instance/database
> create a second rollback segment in the tablespace system
> pre-create all tablespaces if you want to change filenames
> run the import
> generic import commandline
> imp <username/password>@<database> full=y buffer=8192000 file=<yourfilename>
> log=fullimp.log commit=y ignore=y.
> For the rest of options refer to imp help=y or the Oracle Server Utilities
> Guide.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Robert W. Stanford <stanford_at_cableone.net> wrote in message
> news:38CCF6CB.45BB726E_at_cableone.net...
> > I'm all cool there....do I need to create all of the tables previously?
> >
> > buckeye714_at_my-deja.com wrote:
> >
> > > Yes, you have to create the instance first. You also need to know what
> > > version of Oracle the export file was created from. Also, to save
> > > yourself some frustration, find out how big the tablespaces and rollback
> > > segments need to be before you start the import. I hate to get halfway
> > > through an import and then run out of space.
> > >
> > > HTH,
> > > Patrick
> > >
> > > In article <38CB9E6D.D906EF80_at_cableone.net>,
> > > "Robert W. Stanford" <stanford_at_cableone.net> wrote:
> > > > like, I would have to create an instance for it first?
> > > >
> > > > "Robert W. Stanford" wrote:
> > > >
> > > > > An associate has given me a file with an extension of .dmp
> > > > >
> > > > > is the a command for sql + that I can use just to plug this in and
> > > > > recreate it's db instance automatically?
> > > > >
> > > > > thanks in advance.
> > > > >
> > > > > R.
> > > >
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
Received on Mon Mar 13 2000 - 00:00:00 CST