Oracle Database Administration: The Essential Refe

Examples

The following example creates a new table dept in scott’s schema:

CREATE TABLE scott.dept (
   DEPTNO  NUMBER(2) NOT NULL,
   DNAME   VARCHAR2(14),
   LOC     VARCHAR(15))
   TABLESPACE USERS
   STORAGE (INIITIAL 40K NEXT 4K PCTINCREASE 0)
   PCTFREE 15

The following example creates a copy of scott’s emp table:

CREATE TABLE test_emp 
   AS SELECT * FROM scott.emp