注意加上主键等约束,默认情况下,该表放在当前用户的默认表空间里面
如要放在别的表空间里面,修改tablespace 参数Create a table.Syntax: CREATE [GLOBAL TEMPORARY] TABLE [schema.]table (tbl_defs,...)
[ON COMMIT {DELETE|PRESERVE} ROWS]
[storage_options | CLUSTER cluster_name (col1, col2,... )
| ORGANIZATION {HEAP [storage_options] | INDEX idx_organized_tbl_clause}]
[LOB_storage_clause][varray_clause][nested_storage_clause]
partitioning_options
[[NO]CACHE] [[NO]MONITORING] [PARALLEL parallel_clause]
[ENABLE enable_clause | DISABLE disable_clause]
[AS subquery]tbl_defs:
column datatype [DEFAULT expr] [column_constraint(s)]
table_constraint
table_ref_constraintstorage_options:
PCTFREE int
PCTUSED int
INITTRANS int
MAXTRANS int
STORAGE storage_clause
TABLESPACE tablespace
[LOGGING|NOLOGGING]idx_organized_tbl_clause:
storage_option(s) [PCTTHRESHOLD int]
[COMPRESS int|NOCOMPRESS]
[ [INCLUDING column_name] OVERFLOW [storage_option(s)] ]nested_storage_clause:
NESTED TABLE nested_item STORE AS storage_table
[RETURN AS {LOCATOR|VALUE} ]partitioning_options:
Partition_clause {ENABLE|DISABLE} ROW MOVEMENT
如要放在别的表空间里面,修改tablespace 参数Create a table.Syntax: CREATE [GLOBAL TEMPORARY] TABLE [schema.]table (tbl_defs,...)
[ON COMMIT {DELETE|PRESERVE} ROWS]
[storage_options | CLUSTER cluster_name (col1, col2,... )
| ORGANIZATION {HEAP [storage_options] | INDEX idx_organized_tbl_clause}]
[LOB_storage_clause][varray_clause][nested_storage_clause]
partitioning_options
[[NO]CACHE] [[NO]MONITORING] [PARALLEL parallel_clause]
[ENABLE enable_clause | DISABLE disable_clause]
[AS subquery]tbl_defs:
column datatype [DEFAULT expr] [column_constraint(s)]
table_constraint
table_ref_constraintstorage_options:
PCTFREE int
PCTUSED int
INITTRANS int
MAXTRANS int
STORAGE storage_clause
TABLESPACE tablespace
[LOGGING|NOLOGGING]idx_organized_tbl_clause:
storage_option(s) [PCTTHRESHOLD int]
[COMPRESS int|NOCOMPRESS]
[ [INCLUDING column_name] OVERFLOW [storage_option(s)] ]nested_storage_clause:
NESTED TABLE nested_item STORE AS storage_table
[RETURN AS {LOCATOR|VALUE} ]partitioning_options:
Partition_clause {ENABLE|DISABLE} ROW MOVEMENT
(
ACCOUNTID VARCHAR2(8),
PAYTELENUMBER VARCHAR2(17),
PAYNAME VARCHAR2(60),
PAYTYPEID NUMBER,
PAYWAYID NUMBER,
BANKNO VARCHAR2(6),
BANKACCOUNT VARCHAR2(40),
OWEFEE NUMBER,
ACCOUNTSTATUSID NUMBER
)
tablespace BILLINGDATA
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 24K
next 344K
minextents 1
maxextents 505
pctincrease 1
);
给你个例子, 建表的时候应该注意表的存储策略,初始化参数,以及每次扩展多少等
若你是个DBA,直接写create table,而不带任何参数,趁早下岗
To define the sample table salgrade in the human_resource tablespace with a small storage capacity and limited allocation potential, issue the following statement: CREATE TABLE salgrade
( grade NUMBER CONSTRAINT pk_salgrade
PRIMARY KEY
USING INDEX TABLESPACE users_a,
losal NUMBER,
hisal NUMBER )
TABLESPACE human_resource
STORAGE (INITIAL 6144
NEXT 6144
MINEXTENTS 1
MAXEXTENTS 5 );
Index-Organized Table Example
The following statement creates an index-organized table: CREATE TABLE docindex
( token CHAR(20),
doc_oid INTEGER,
token_frequency SMALLINT,
token_occurrence_data VARCHAR2(512),
CONSTRAINT pk_docindex PRIMARY KEY (token, doc_oid) )
ORGANIZATION INDEX TABLESPACE text_collection
PCTTHRESHOLD 20 INCLUDING token_frequency
OVERFLOW TABLESPACE text_collection_overflow;例子还有多,参考oracle8i dba,灵活运用。