1. Create a table T2 so that the structure of T1 table
Create Table T2 AS SELECT * from T1 Where 1 <> 2;
2. Create a table T2 to have the structure and data of the T1 table.
Create Table T2 AS SELECT * AROM T1;
3, modify the specification of the Michael users to the Users, temporary table space is Temp, and create a 15M space quota in the UserS tablespace
Alter User Michael Default TableSpace Uses Temporary TableSpace Temp Quota 15M on Use;
4, build a table statement script example, pay attention to case
Set echo off
Spool matial_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
