Oracle之创建表与修改表详解(五)
ss topre;
表已更改。
SCOTT@orcl#alter table mybook4 modify pre not null;
表已更改。
SCOTT@orcl#alter table mybook4 modify prenumber(10,2);
表已更改。
SCOTT@orcl#alter table mybook4 modify pre number(4,1);
表已更改。
SCOTT@orcl#alter table mybook4 modify pre default 0.0;
表已更改。
SCOTT@orcl#alter table mybook4 rename to book4;
表已更改。
SCOTT@orcl#select table_name,tablespace_name fromuser_tables;
TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------------------------------
DEPT USERS
EMP USERS
BONUS USERS
SALGRADE USERS
NEWEMP USERS
QUEST_SOO_EVENT_CATEGORIES USERS
QUEST_SOO_BUFFER_BUSY USERS
QUEST_SOO_PLAN_TABLE USERS
QUEST_SOO_LOCK_TREE USERS
QUEST_SOO_VERSION USERS
QUEST_SOO_SB_EVENT USERS
TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------------------------------
QUEST_SOO_SB_BUFFER_BUSY USERS
QUEST_SOO_SB_IO_STAT USERS
QUEST_SOO_PARSE_TIME_TRACK USERS
QUEST_SOO_SCHEMA_VERSIONS USERS
QUEST_SOO_AT_APPNAME USERS
QUEST_SOO_AT_SQL_EXEC_ERROR USERS
QUEST_SOO_AT_PARSE_WAITS USERS
QUEST_SOO_AT_EXECUTION_PLAN USERS
QUEST_SOO_AT_PARSE_CURSOR USERS
QUEST_SOO_AT_PARSE_ERROR USERS
QUEST_SOO_AT_SESSION_ID USERS
TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------------------------------
QUEST_SOO_AT_SQL_BINDS USERS
QUEST_SOO_AT_SQL_EXECUTIONS USERS
QUEST_SOO_AT_SQL_FETCH USERS
QUEST_SOO_AT_SQL_STATEMENT USERS
QUEST_SOO_AT_SQL_STMT_PIECES USERS
QUEST_SOO_AT_SQL_WAITS USERS
QUEST_SOO_AT_TRACE_FILE USERS
QUEST_SOO_AT_WAIT_NAMES USERS
QUEST_SOO_AT_OPERATIONS USERS
MYBOOK USERS
BOOK4 USERS
TABLE_NAME TABLESPACE_NAME
------------------------------------------------------------------------------------------------------------------------
MYBO