Re: Export Import Question

Although if the target machine had the same directory structure you would only have to create the system tablespace , the import will create the rest...

Madhu Cherukuri wrote in message <6aoo6d$6ae_at_bgtnsc01.worldnet.att.net>...
>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 Thu Jan 29 1998 - 00:00:00 CST