Hi Gurus,

I am trying to create a new instance of our production database on a new
machine.

I precreated all the tablespaces and the application user on the target
database.

On the source database, I did a ful database export with the following
parameters through a pipe:

exp userid=system/psswd file=fullexportcompress_pipe rows=Y indexes=Y
compress=N grants=Y constraints=Y full=Y log=fullimpeexp.log

On the target database I am using the following import parameters:

imp userid=system/psswd file=import_pipe full=Y buffer=10000000 ignore=Y
commit=Y log=fullimp.log

However, I am getting the following errors:

IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace
ADVANCE_DATA
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "TEMP_XXX" ("I_SESSION_ID" VARCHAR2(10), "TEMP_DONOR_ID""
" VARCHAR2(10), "TEMP_RECEIPT_NUMBER" VARCHAR2(10), "TEMP_DATE_OF_RECORD"
DA"
"TE, "TEMP_ASSOCIATED_AMOUNT" NUMBER(14, 2), "TEMP_ASSOCIATED_CREDIT_AMT"
NU"
"MBER(14, 2), "TEMP_CREDIT2_AMT" NUMBER(14, 2), "TEMP_ANNUAL_SW"
VARCHAR2(1)"
", "TEMP_TYPE" VARCHAR2(1)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
L"
"OGGING STORAGE(INITIAL 2097152 NEXT 2099200 MINEXTENTS 1 MAXEXTENTS 4096
PC"
"TINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
""
"DATA""
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace DATA

When I look at the tablespace in OEM, it is maxed out. Even though the
source tablespace is 5GB and the target tablespace is 9GB.

I can see through TOAD that the initial extents for some of the tables are
'2097152', how can this be if I used compress=N during the export?

Please help.
-- Session.


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Oracle LazyDBA home page