Q
Problem solve Get help with specific problems with your technologies, process and projects.

Creating a 600MB table in a 600MB tablespace

I have a tablespace t1 of size 600MB. It contains three datafiles of 200MB each. Now, I want to create a table of size 600MB. Is it possible? If yes, Please give me the syntax and explain how it gets created.

The answer to this is: it depends!

If your tablespace was created to autoextend and has not yet reached its max extents, then as long as max extents for the tablespace will accommodate the additional table and will grow as needed to 600MB...or more depending on your settings. If the tablespace is not set to autoextend, you could simply create another datafile big enough to hold the new table.

Here's an example of how to add a new datafile:

ALTER TABLESPACE my_tablespace 
ADD DATAFILE '/u01/oradata/orcl/my_ts4.dbf'
SIZE 700M
AUTOEXTEND ON
NEXT 100K
MAXSIZE 100K;

For More Information


This was last published in December 2002

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close