Discussion Locked
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Please can somebody outlined the steps in creating tablespace in Oracle and how to store objects in it.Give an example please. Thanks.
1 reply
by shanghai sam
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);
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question Unanswered
Best Way to Make Long WordPress Location Guides Mobile Friendly
0 helpful
0 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies