oracle导入imp 00003,oracle 导入数据报错IMP-00003 & ORA-01659

今天帮客户导入数据的时候，报错：

oracle@hgpsfe01:/oracle$ imp vsop/vsop@sfe file=/tmp/Migration/t_sell_05.dat full=y

Import: Release 11.2.0.1.0 - Production on Wed Dec 1 17:08:23 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SYS, not by you

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

export server uses UTF8 NCHAR character set (possible ncharset conversion)

. importing SYS's objects into VSOP

. importing VSOP's objects into VSOP

IMP-00015: following statement failed because the object already exists:

"CREATE TABLE "T_SELL" ("CD_MODEL" NVARCHAR2(18), "CD_SHOP" NVARCHAR2(10), ""

"DT_SELL" DATE, "QTY_IN" NUMBER(8, 0), "QTY_OUT" NUMBER(8, 0), "QTY_STD_INV""

" NUMBER(8, 0), "QTY_INV" NUMBER(8, 0), "QTY_DISPLAY" NUMBER(8, 0), "QTY_TRA"

"NS" NUMBER(8, 0), "QTY_RETURN" NUMBER(8, 0), "TURN_OVER" NUMBER(6, 2), "QTY"

"_ADJUSTMENT" NUMBER(8, 0), "QTY_ADJUSTMENT_DISPLAY" NUMBER(8, 0))  PCTFREE "

"30 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4294967294 NEXT 10485"

"76 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)                   LOG"

"GING NOCOMPRESS"

. importing SYS's objects into SYS

IMP-00017: following statement failed with ORACLE error 1659:

"CREATE INDEX "IDX_T_SELL_DT_DATE_CHAR" ON "VSOP"."T_SELL" (TO_CHAR("DT_SELL"

"",'YYYYMM') )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 429496729"

"4 NEXT 1048576 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)          "

"              LOGGING"

IMP-00003: ORACLE error 1659 encountered

ORA-01659: unable to allocate MINEXTENTS beyond 53 in tablespace SYSTEM

Import terminated successfully with warnings.

结果发现：table 中的数据没有导入。

切换到oracle 用户：

Import: Release 11.2.0.1.0 - Production on Wed Dec 1 17:28:46 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

You can let Import prompt you for parameters by entering the IMP

command followed by your username/password:

Example: IMP SCOTT/TIGER

Or, you can control how Import runs by entering the IMP command followed

by various arguments. To specify parameters, you use keywords:

Format:  IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)

Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N

or TABLES=(T1:P1,T1:P2), if T1 is partitioned table

USERID must be the first parameter on the command line.

Keyword  Description (Default)       Keyword      Description (Default)

--------------------------------------------------------------------------

USERID   username/password           FULL         import entire file (N)

BUFFER   size of data buffer         FROMUSER     list of owner usernames

FILE     input files (EXPDAT.DMP)    TOUSER       list of usernames

SHOW     just list file contents (N) TABLES       list of table names

IGNORE   ignore create errors (N)    RECORDLENGTH length of IO record

GRANTS   import grants (Y)           INCTYPE      incremental import type

INDEXES  import indexes (Y)          COMMIT       commit array insert (N)

ROWS     import data rows (Y)        PARFILE      parameter filename

LOG      log file of screen output   CONSTRAINTS  import constraints (Y)

DESTROY                overwrite tablespace data file (N)

INDEXFILE              write table/index info to specified file

SKIP_UNUSABLE_INDEXES  skip maintenance of unusable indexes (N)

FEEDBACK               display progress every x rows(0)

TOID_NOVALIDATE        skip validation of specified type ids

FILESIZE               maximum size of each dump file

STATISTICS             import precomputed statistics (always)

RESUMABLE              suspend when a space related error is encountered(N)

RESUMABLE_NAME         text string used to identify resumable statement

RESUMABLE_TIMEOUT      wait time for RESUMABLE

COMPILE                compile procedures, packages, and functions (Y)

STREAMS_CONFIGURATION  import streams general metadata (Y)

STREAMS_INSTANTIATION  import streams instantiation metadata (N)

DATA_ONLY              import only data (N)

VOLSIZE                number of bytes in file on each volume of a file on tape

The following keywords only apply to transportable tablespaces

TRANSPORT_TABLESPACE import transportable tablespace metadata (N)

TABLESPACES tablespaces to be transported into database

DATAFILES datafiles to be transported into database

TTS_OWNERS users that own data in the transportable tablespace set

Import terminated successfully without warnings.

重新输入命令：

oracle@hgpsfe01:/oracle$ imp vsop/vsop@sfe file=/tmp/Migration/t_sell_05.dat full=y IGNORE=y indexes=n

解释： ignore： 把一些warning ,给ignore

indexes=n 不要创建inedex