Re: .dmp file

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