oracle数据库validate作用,DISABLE VALIDATE与SQL*Loader

[oracle@ora11202 ~]$ sqlplus system/oracle@192.168.2.21/orcl

SQL*Plus: Release 11.2.0.2.0 Production on Fri Mar 28 16:49:25 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

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

SQL> create tablespace tbs_nby datafile '/u01/oradata/orcl/tbs_nby.dbf' size 8M autoextend on next 8M maxsize 1024M;

Tablespace created.

SQL> create user nby identified by nby default tablespace tbs_nby;

User created.

SQL> grant create session,resource,unlimited tablespace to nby;

Grant succeeded.

SQL> conn nby/nby

Connected.

SQL> CREATE TABLE nby.t_part(ID number,Name varchar2(10),CONSTRAINT pk_part PRIMARY KEY(ID))

2  partition by range(id