A database storage unit that groups related logical structures together.

learn more… | top users | synonyms

2
votes
2answers
23k views

How can I resolve this ORA-01652 error when I already added a new file to the TEMP tablespace?

I've inherited basic DBA-like responsibilities on an Oracle database and I'm stuck on a ORA-01652 error while trying to run a query that contains lots of joins and grouping. Here's the error I get: ...
3
votes
1answer
40 views

USERS Tablespace Best Practices for Application Schema

When creating a user/schema to hold external application data, what are best practices for the tablespaces that the user is defaulted to? Should the user created be defaulted to the USER tablespace ...
3
votes
1answer
143 views

DB2 9.7, create or replace tablespace possible?

I am creating my tablespaces in the sql scripts that create the database schema. This causes a problem in continuous integration processes, where consecutive execution of the script is not possible ...
2
votes
1answer
166 views

Estimating tablespace size

I'm trying to estimate the size of a tablespace using these steps: Space Estimations for Schema Objects and I was little confused about some of the steps. In step 3 for calculating the rowsize I ...
1
vote
1answer
146 views

SQL Server 2012 enlarge database space

I tried to enlarge a database size of database instance on my SQL Server 2012. I manually added a new .MDF file under database instance After restart on shrink database dialog I can see available ...
0
votes
1answer
99 views

List all privileges granted on tablespace

Frineds, DB: 11gR2 OS: Unix So I'm moving all objects of a tablespace-A to new tablespace-B. Is there a way to list all privileges/quota granted for tablespace-A? Since tablespace-A can have ...
0
votes
1answer
2k views

Undo tablespace full, how to free it

My undo tablespace is full after some modifications. Las column is % of space used. xxx_undo_01.dbf UNDO 2147483648 16777216 2048 2032 16 0,78 99,22 Now i cannot execute any query ...
-1
votes
1answer
1k views

Oracle Partition Table Space Issue

I have a table with list partitions on it. When i insert data i see that all the partitions have default initial size of 8 MB and I also noticed that when i truncate full table and check size it still ...
4
votes
0answers
146 views

Postgres multidisk master replicating to single disk slave

I have an odd situation. I have a postgreSQL database master with multiple large tablespaces divided across 3 physical disks. I am setting up a slave that will be used to offload long, ...
1
vote
0answers
482 views

Oracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm using IMPDP with the "network_link" for perform export/import in a single-pass. It runs fine until I get this error. ORA-39171: Job is experiencing a resumable wait. ORA-30036: unable to ...
1
vote
0answers
890 views

How do I import a dump for a deleted tablespace?

I'm trying to import a database dump, however I am encountering this error: ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error: ORA-00959: tablespace '_$deleted$5$0' does not ...
0
votes
0answers
84 views

Discard tablespace of temporary innodb table in MySQL

I have following problem, i need to discard tablespace of temporary table(file is present, i want to delete this file too) or somehow completely remove this table. This table can't be shown with ...
0
votes
0answers
52 views

What is the best way to analyze free space in a postgres database and the grow of usage?

In Oracle you can in datadictinary analyze free space by using SQL like: select b.tablespace_name, b.file_id, b.file_name, b.bytes/1024 total_KBytes, sum(a.bytes)/(1024) sum_free_Kbytes, ...
0
votes
0answers
15 views

Releasing space after deleting datafiles

I'm deleting old backup tablespaces with option using contents and datafiles in TOAD. Datafiles were deleted, but no space was released: Filesystem GB blocks Free %Used Iused %Iused ...
0
votes
0answers
360 views

How to find out the maximum number of datafiles per tablespace in Oracle?

According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022". I know there are queries for some of the other limits mentioned ...
0
votes
0answers
276 views

While altering tablespace shows error tablespace does not exist

SQL> select * from v$tablespace where name = 'EXAMPLE'; TS# NAME INC BIG FLA ENC CON_ID 4 EXAMPLE YES NO YES 3 Above query shows that ...
0
votes
0answers
600 views

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert ...