A database storage unit that groups related logical structures together.

learn more… | top users | synonyms

3
votes
1answer
170 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
66 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 ...
2
votes
1answer
308 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 ...
0
votes
1answer
146 views

List all privileges granted on tablespace

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 default user or not and also other ...
0
votes
1answer
3k 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 ...
2
votes
0answers
13 views

In PostgreSQL, can you read from an index during a ALTER INDEX … SET TABLESPACE operation?

I have a PostgreSQL 9.3 server, and there's a large index that I want to move to another tablespace on another disk, because I want to free up space on the original disk. However this is a production ...
1
vote
0answers
42 views

How to recover LogMiner after its tablespace had been deleted?

Here is my story: I created separate table space for Log Miner, create tablespace logminer_ts datafile '/path/to/logminer.dbf' size 50M AUTOEXTEND ON And moved Log Miner to the created table ...
1
vote
0answers
659 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
997 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
28 views

why database fill only one datafile of tablespace?

database tablespaces give error mail to me. It says TABLEINDEX haf %2 free size. But I looked, only 5.th datafile filled %85 and others are not filled (%0 or %1) all datafiles are 32 GB. I send photo. ...
0
votes
0answers
125 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
73 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, max(a....
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
568 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
379 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
671 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 ...