Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace information from export file (NT)
The import will create users but will not create the Tablespaces.
To see exactly what the import will do, execute the following statement, it will not import the file, but will show you what would happen if you did:
imp user/password_at_TNSName myfile.dat show=Y log=mylogfile.txt
This will output mylogfile.txt with all the create commands and sizing information for each of the segments to be created.
Kenny Gump
Andy Hardy wrote in message ...
>Is there any way of getting the tablespace details from an export file
>as I'd like to know how big the tablespaces should be when I create my
>new database.
>
>In fact, I almost expected an import to attempt to create the
>tablespaces and users from an export file as required?
>
>Andy
>--
>Andy Hardy. PGP key available on request
>===============================================================
Received on Wed Apr 14 1999 - 15:50:03 CDT