Re: Tablespace information from export file (NT)

From: Charles Wolfe <cwolfe_at_ix.netcom.com>
Date: Wed, 14 Apr 1999 18:12:39 -0400
Message-ID: <7f33si$7v9@sjx-ixn10.ix.netcom.com>

Actually, import is quite capable of creating tablespaces. Please refer to the attached excerpt:

hth

Regards,
Chuck

Connected to: Oracle8 Personal Edition Release 8.0.4.0.0 - Production PL/SQL Release 8.0.4.0.0 - Production

Export file created by EXPORT:V08.00.04 via conventional path .. importing SYSTEM's objects into SYSTEM "ALTER SCHEMA = "SYSTEM""
"CREATE TABLESPACE "USER_DATA" DATAFILE 'C:\ORAWIN95\DATABASE\USR1ORCL.ORA'"
" SIZE 3145728 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 "
"MAXEXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT" "CREATE TABLESPACE "ROLLBACK_DATA" DATAFILE 'C:\ORAWIN95\DATABASE\RBS1ORCL."
"ORA' SIZE 5242880 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENT"
"S 1 MAXEXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT" "CREATE TABLESPACE "TEMPORARY_DATA" DATAFILE 'C:\ORAWIN95\DATABASE\TMP1ORCL"
".ORA' SIZE 2097152 DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTEN"
"TS 1 MAXEXTENTS 121 PCTINCREASE 50) ONLINE PERMANENT" Kenny Gump <kgump_at_mylanlabs.com> wrote in message news:3714ff1f.0_at_news.mountain.net...
> 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 - 17:12:39 CDT