size of tbs

Posted on 2014-04-04
Medium Priority
Last Modified: 2014-06-10
I have a 2gb tablespace

There is no space in the mount point

4gb is to imported

What we will do ?
Question by:tonydba
LVL 23

Accepted Solution

David earned 2000 total points
ID: 39978480
If you cannot reduce the size of the input, nor make space in the mount point, your SA will have to allocate more storage capacity to the mount point.

A traditional Oracle tablespace may be associated with multiple data files, where the data files may be on separate mount points.  I presume you're not inferring ASM.
LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39979042
I donot understand your question correctly, you are saying that you have 2GB tablespace available and 4GB data needs to be imported, but there is no space in mount point. Correct?
How did you calculated 4GB? If you are referring to existing tablespace size, then actual space needed might not be 4GB.
If you are referring that Table size is 4GB, then again actual data might be lesser than object size.
If you are referring flat file size of 4GB, then you need more than 4GB in Oracle.

Author Comment

ID: 39986495
That means there is no space now in the tablespace..

Big data is coming..
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 15

Expert Comment

by:Devinder Singh Virdi
ID: 39986593
Try tablespace compression.
Please go through below document http://www.dba-oracle.com/oracle11g/sf_Oracle_11g_Data_Compression_Tips_for_the_DBA.html
LVL 23

Expert Comment

ID: 39986616
@virdi If the tablespace is full and cannot extend, for whatever reason, how would compression manage the temporary storage needed?  I don't know.

@Tony, does your storage system have physical space available for the tablespace to expand?  I infer not from "no space in the mount point".

Can your SA not allocate additional storage for your datafiles?

Have you explored what caused the existing storage to fill up, apparently undetected?
LVL 23

Expert Comment

by:Steve Wales
ID: 40124028
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question