How to find size of tablespace from export file?(b24)


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



Ans:

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@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
 

Hosted by www.Geocities.ws

1