tonydba
asked on
size of tbs
I have a 2gb tablespace
There is no space in the mount point
4gb is to imported
What we will do ?
There is no space in the mount point
4gb is to imported
What we will do ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That means there is no space now in the tablespace..
Big data is coming..
Big data is coming..
Try tablespace compression.
Please go through below document http://www.dba-oracle.com/oracle11g/sf_Oracle_11g_Data_Compression_Tips_for_the_DBA.html
Please go through below document http://www.dba-oracle.com/oracle11g/sf_Oracle_11g_Data_Compression_Tips_for_the_DBA.html
@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?
@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?
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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.