General discussion

Locked

Creating Tablespace in Oracle.

By ofoeg ·
Please can somebody outlined the steps in creating tablespace in Oracle and how to store objects in it.Give an example please. Thanks.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating Tablespace in Oracle.

by Shanghai Sam In reply to Creating Tablespace in Or ...

Typically, your Oracle DBA creates the tablespace(s) because the setup can effect query speed.

Your administrator can create a "user" that defaults to a specified tablespace. All your objects are stored there automatically.

Syntax from SQLPlus on NT:
CREATE tablespace test_ts datafile 'E:\Oracle\oradata\mikes\test_ts.dbf' size 2M
default storage (initial 50K next 50K pctincrease 10);

Once the tablespace exists, you can also manually specify the tablespace within the CREATE command:

Create table XYZ (field1 char(20), field2...)
tablespace test_ts
Storage (initial 20K next 20K);

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums