Search SCM Intranet Enterprise Database: Partition Tablespace Please note that there are two tablespaces in each of the Oracle 9i databases (edbhead and edbbranch) setup for Enterprise Database. The default tablespace is called users and there is a secondary tablespace called parts (being short for partitions). When creating a table, you can specify the tablespace it should be stored in by using the keyword TABLESPACE followed by the name of the tablespace. For (a trival) example: CREATE TABLE trival (trival_char VARCHAR2(20)) TABLESPACE parts; You can use the following query to display all of your tables and the various tablespaces they are stored in: SELECT TABLE_NAME, TABLESPACE_NAME FROM USER_TABLES; I hope this helps you in your tutorials and assignment! CIT DBA 2004-05-17
CIT DBA 2004-05-17
