1、创建一个表T2,使之具有T1表的结构
CREATE TABLE T2 AS SELECT * FROM T1 WHERE 1<>2;
2、创建一个表T2,使之具有T1表的结构和数据
CREATE TABLE T2 AS SELECT * FROM T1;
3、修改michael用户的确省表空间为users,临时表空间为temp,并给他在users表空间中创建15M的空间配额
ALTER USER michael DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 15m ON users;
4、建表语句脚本示例,注意大小写
SET ECHO OFF
SPOOL Material_test_items.log
CREATE TABLE Material_test_items
(
Material_test_no VARCHAR2(6) NOT NULL,
Test_date DATE NOT NULL,
Category VARCHAR2(2) NOT NULL,
Mtrl_item_no VARCHAR2(2) NOT NULL,
Mtrl_item_value VARCHAR2(60) NULL ,
Modify_date DATE NULL ,
Modify_user VARCHAR2(30) NULL ,
Insert_user VARCHAR2(30) NULL ,
Insert_date DATE NULL ,
Data_owner VARCHAR2(10) NULL ,
CONSTRAINT material_test_items_PK PRIMARY KEY (Material_test_no, Test_date, Category, Mtrl_item_no))
STORAGE (Initial 65536
Next 65536
Minextents 1
Maxextents 505
Pctincrease 0);
SPOOL OFF
SET ECHO ON
5、user_ind_columns user_cons_columns user_constraints
user_tables dba_tables all_tables
user_views dba_views all_views
user_indexs dba_indexs all_indexs
user_sequences dba_sequences all_sequences
user_synonyms dba_synonyms all_synonyms
6、将一个表中的数据增加到另一个数据库中的同名表中去,这种方法比数据库链省事的多。
COPY FROM username/password@database APPEND table1 USING SELECT * FROM table1;
如果需要将数据替换,就将APPEND替换成REPLACE