| import [message #167844] |
Mon, 17 April 2006 08:11  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
i made a full database export from an oracle 9i on windows xp.
i installed oracle 9i on a new server xp and create the sample database named also orcl the same name as the original.
does an import create the tablespace and the datafiles already created in the original database ?
thanks
|
|
|
|
|
|
|
|
|
|
|
|
| Re: import [message #168402 is a reply to message #168398] |
Thu, 20 April 2006 04:26  |
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
|
Member |
|
|
if it is full yes it will create tablespace just look inside the dump file you will find text to create tablespaces under tablespace definitions
Thanks
Madhu
|
|
|
|
| Re: import [message #169245 is a reply to message #167844] |
Tue, 25 April 2006 22:22 |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
I think you can use transport tablespace option in exp.
In this way, imp will help you creat the tablespaces.
Alex zeng |Skype me: hans9zeng
|
|
|
|
| Re: import [message #169269 is a reply to message #167844] |
Wed, 26 April 2006 00:10 |
Hasan Mannan
Messages: 5
Registered: November 2002
|
Junior Member |
|
|
Hi, import will not create the TS nore Datafiles, the best way you can do it..
its simple just create the TS and datafiles on your new machine and the import the dump file that you have.
you can get the script how to create TS and DF of the same size from your Source DB server by using any third party tool. like TOAD.
Hasan
DBA,Pakistan
|
|
|
|
| Re: import [message #169334 is a reply to message #169269] |
Wed, 26 April 2006 05:40 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Hi, import will not create the TS nore Datafiles,
Says who?
IF it is a full database export, import will ***try*** to create the tablespace again.
If the destination database has the same FIlesystem paths properly defined, tablespaces will
be successfully created.
oracle@mutation#imp scott/tiger full=y show=y log=somelogfile.log
contents of somelogfile.log
1
2 Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
3 With the Partitioning option
4 JServer Release 9.2.0.4.0 - Production
5
6 Export file created by EXPORT:V09.02.00 via conventional path
7 import done in US7ASCII character set and AL16UTF16 NCHAR character set
8 import server uses WE8ISO8859P1 character set (possible charset conversion)
9 . importing SYSTEM's objects into SYSTEM
10 "ALTER SESSION SET CURRENT_SCHEMA= "SYSTEM""
11 "CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE '/u01/app/oracle"
12 "/oradata/mutation/undotbs01.dbf' SIZE 534773760 AUTOEXTEND ON NEXT 52"
13 "42880 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL "
14 "CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 8192 TEMPFILE '/u01/app/oracl"
15 "e/oradata/mutation/temp01.dbf' SIZE 45088768 AUTOEXTEND ON NEXT 65536"
16 "0 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576"
17 "CREATE TABLESPACE "TOOLS" BLOCKSIZE 8192 DATAFILE '/u01/app/oracle/oradata"
18 "/mutation/tools01.dbf' SIZE 10485760 AUTOEXTEND ON NEXT 327680 MAXSI"
19 "ZE 32767M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGIN"
20 "G SEGMENT SPACE MANAGEMENT AUTO"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
