[oracle] 資料表相關

建立 資料表 加 tablespace
CREATE TABLE BRADY.persons(
person_id NUMBER GENERATED BY DEFAULT AS IDENTITY,
first_name VARCHAR2(50) NOT NULL,
last_name VARCHAR2(50) NOT NULL,
PRIMARY KEY(person_id)
) TABLESPACE CCH_TABLESPACE
STORAGE ( INITIAL 50K);
http://mylinoraclesql.blogspot.com/2014/02/create-table.html
顯示 所有資料表
SELECT TABLE_NAME, TABLESPACE_NAME
FROM user_tables
ORDER BY table_name;
SELECT table_name, OWNER, TABLESPACE_NAME
FROM all_tables
ORDER BY table_name;
SELECT TABLE_NAME, OWNER, TABLESPACE_NAME
FROM DBA_TABLES;
https://www.oracletutorial.com/oracle-administration/oracle-show-tables/