A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g
It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the table creation statement is changed. Here is an experiment:
SQL> select * from v $ version;
BANNER
------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production
1. initialize data
Drop table CALL_LOG purge;
Create table CALL_LOG
(
LOG_ID NUMBER (10) not null,
INVOKE_TIME TIMESTAMP (6)
)
Partition by range (INVOKE_TIME) INTERVAL (NUMTODSINTERVAL (1, 'day '))
(
Partition CALL_LOG_P_2015_03_01 values less than (to_date ('192 _ 03_01 ', 'yyyy-mm-dd '))
);
Insert into CALL_LOG (LOG_ID, INVOKE_TIME) values (4, sysdate-4 );
Insert into CALL_LOG (LOG_ID, INVOKE_TIME) values (5, sysdate-3 );
Insert into CALL_LOG (LOG_ID, INVOKE_TIME) values (6, sysdate-2 );
Insert into CALL_LOG (LOG_ID, INVOKE_TIME) values (7, sysdate-1 );
Commit;
2. export and import data
Exp is not supported because it is a new feature and exp is not supported.
Exp test/test@10.10.15.150 file = d:/CALL_LOG.dmp tables = SOA_CALL_LOG
C: \ Users \ Administrator> exp test/test@10.10.15.150 file = d:/CALL_LOG.dmp tables = SOA_CALL_LOG
Export: Release 11.2.0.1.0-Production on Tuesday June 16 16:49:27 2015
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect 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
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
The server uses the AL32UTF8 character set (possible Character Set conversion)
To export the specified table, use the regular path...
EXP-00006: internal inconsistency Error
EXP-00000: Export termination failed
Expdp test/test directory = DATA_PUMP_DIR dumpfile = CALL_LOG.dmp tables = CALL_LOG
Impdp test/test directory = DATA_PUMP_DIR dumpfile = CALL_LOG.dmp
3. After the import, check that the definition in the table below is fixed.
Create table CALL_LOG
(
LOG_ID NUMBER (10) not null,
INVOKE_TIME TIMESTAMP (6)
)
Partition by range (INVOKE_TIME)
(
Partition CALL_LOG_P_2015_03_01 values less than (TIMESTAMP '00:00:00 ')
Tablespace USERS
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64 K
Next 1 M
Minextents 1
Maxextents unlimited
),
Partition SYS_P28 values less than (TIMESTAMP '00:00:00 ')
Tablespace USERS
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64 K
Next 1 M
Minextents 1
Maxextents unlimited
),
Partition SYS_P29 values less than (TIMESTAMP '00:00:00 ')
Tablespace USERS
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64 K
Next 1 M
Minextents 1
Maxextents unlimited
),
Partition SYS_P30 values less than (TIMESTAMP '00:00:00 ')
Tablespace USERS
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64 K
Next 1 M
Minextents 1
Maxextents unlimited
),
Partition SYS_P31 values less than (TIMESTAMP '00:00:00 ')
Tablespace USERS
Pctfree 10
Initrans 1
Maxtrans 255
Storage
(
Initial 64 K
Next 1 M
Minextents 1
Maxextents unlimited
)
);