Re: Export Import Question

From: Madhu Cherukuri <Madhu.Cherukuri_at_worldnet.att.net>
Date: 1998/01/28
Message-ID: <6aoo6d$6ae@bgtnsc01.worldnet.att.net>#1/1

You can not create a database by IMP command. The EXP/EMP is an utility to maintain some backups and cross platform portability only. If you want to use the data of the exported file, first you need to create a fresh database and a user to import it back.
HTH
Madhu Cherukuri

ling_at_redash.qut.edu.au wrote in message <6alu99$69n$1_at_dove.qut.edu.au>...
>Hi Oracle DBAs,
>
>If I have a full database export file created using
>
> exp system/password full=y buffer=10240 file=fullexp.dat
> indexes=y grants=y constraints=y compress=y
>
>can I use the IMP command below to recreate a new database on another
>machine (i.e. without precreating the blank database itself), if the
>machine has the same OS and same environmental variables, path names
>predefined?
>
> imp system/password full=y buffer=10240 file=fullexp.dat ignore=y
> indexes=y grants=y
>
>Thanks in advance,
>
>HH Ling
>QUT, Brisbane, Australia.
Received on Wed Jan 28 1998 - 00:00:00 CST