[oracle@ora10g exp]$ cat imp.conf
userid=u1/u1
buffer=10000
log=imps.log
file=scott.dmp
feedback=10000
indexes=n
fromuser=scott
touser=u1
imp parfile=imp.conf
加上了 indexes=n 为什么 导入的数据还是有 索引
SQL> select * from user_indexes;
INDEX_NAME INDEX_TYPE TABLE_OWNER
------------------------------ --------------------------- ------------------------------
TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH TABLESPACE_NAME INI_TRANS
------------------------- ----------- --------- -------- ------------- --------------- ----------
MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD
---------- -------------- ----------- ----------- ----------- ------------ -------------
INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG BLEVEL LEAF_BLOCKS DISTINCT_KEYS
-------------- ---------- --------------- ---------- --- ---------- ----------- -------------
AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE
----------------------- ----------------------- ----------------- ---------- ---------- -----------
LAST_ANAL DEGREE INSTANCES PAR T G
--------- ---------------------------------------- ---------------------------------------- --- - -
S BUFFER_ USE DURATION PCT_DIRECT_ACCESS ITYP_OWNER
- ------- --- --------------- ----------------- ------------------------------
ITYP_NAME
------------------------------
PARAMETERS
----------------------------------------------------------------------------------------------------
GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO
--- ------------ ------ -------- --- --- ---
PK_EMP NORMAL U1
EMP TABLE UNIQUE DISABLED USERS 2
255 65536 1 2147483645
10 YES 0 1 14
1 1 1 VALID 14 14
10-OCT-14 1 1 NO N N
N DEFAULT NO
NO NO NO NO
PK_DEPT NORMAL U1
DEPT TABLE UNIQUE DISABLED USERS 2
255 65536 1 2147483645
10 YES 0 1 4
1 1 1 VALID 4 4
10-OCT-14 1 1 NO N N
N DEFAULT NO
NO NO NO NO
PK_D NORMAL U1
D TABLE UNIQUE DISABLED USERS 2
255 65536 1 2147483645
10 YES 0 1 2
1 1 1 VALID 2 2
10-OCT-14 1 1 NO N N
N DEFAULT NO
NO NO NO NO