A database storage unit that groups related logical structures together.

learn more… | top users | synonyms

2
votes
1answer
2k views

DB2 Server Table Space Locked

At work we keep receiving the following DataException seemingly at random when one of our processes tries to write/access a table for one of our clients: com.ibm.db.DataException: A database manager ...
5
votes
3answers
31k views

“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?

Earlier I created a user : SQL>create user suhail identified by password SQL>User created. SQL>Grant create session,create table to suhail; SQL>Grant Succeeded. but when I login as ...
1
vote
1answer
110 views

Partition of tablespace [closed]

My postgres server is running in a windows server and three tablespace are created. Postgresql server is installed in C: drive and the tablespaces are in D: and E: drive. So how to take a backup and ...
2
votes
1answer
1k views

How to create Buffer Pool in Database dedicated only for ONE BIG table?

I have table TICKET with 400K records in database (DB2). I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it? ...
1
vote
1answer
1k views

Oracle delete technique for table's segment size (data compactness)

I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before: ...
2
votes
1answer
13k views

Expanding system tablespace

I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
6
votes
1answer
5k views

Moving postgresql data to different drive

I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my ...
2
votes
1answer
1k views

Why is DBA_SEGMENTS presenting twice the amount of data than the DBA_TABLES?

I tried to compute the audit log table usage using the following steps: Truncate all the audit log table data (i.e. AUD$) Perform test case that inserts and update data, also delete statement but it ...
1
vote
1answer
184 views

How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)

I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the ...
1
vote
0answers
768 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 ...
3
votes
5answers
2k views

Does 'Cities' deserve a separate table?

I have the following Customers table: customer_id - int company_name - nvarchar street - nvarchar city - nvarchar comments - nvarchar The app will only be used in part of one small country ...
4
votes
1answer
3k views

Drop user did not reduce size of tablespace file

I have a development environment in which I frequently copy a certain schema. When I'm done with the copy, I will use OracleEM to drop that user/schema. My problem is that this does not seem to ...
3
votes
1answer
3k views

DB2: Is it good to create the index table space to use 32 KB data page

I found our DB2 server configs all the index into one table space. And it then defines the table space to use 32kb data page. Is this good? How to judge it? Any advice is welcome.
2
votes
1answer
462 views

DB2: Is it good to create the LONG table space to use 32 KB data page

Our DB2 database(V9.7) has only defined one table space to store all the big object like xml. And xml size could be different. Some are about 2kb average. And some are 7kb average. So does it make ...
2
votes
1answer
93 views

Why does connecting to a database use tempspace?

Earlier today we had a problem logging into a database that had just been created automatically. When on the actual box (Linux) sqlplus schema/pw, i.e. a local connection, was fine, though, it was ...
4
votes
2answers
6k views

In Oracle how do you move a Schema to a different Tablespace?

I noticed that a Schema has been created in the USERS Tablespace but our local rule is that it should be in a Tablespace by itself. In Oracle how do you move a Schema to a different Tablespace?
1
vote
2answers
2k views

Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces

Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size? Even more, what should apply for ...
1
vote
1answer
404 views

file not found - how to remove its configuration?

I run oracle 10.2.0.5. I have the following: SQL> select file#, status, error, recover, tablespace_name, name 2 from v$datafile_header 3 where recover='YES' 4 or (RECOVER IS NULL AND ...
4
votes
1answer
7k views

What units used in DBA_TABLESPACE_USAGE_METRICS?

What units are used in the usage metrics (USED_SPACE and TABLESPACE_SIZE columns) described in Oracle's DBA_TABLESPACE_USAGE_METRICS static data dictionary view? The Oracle Database Reference only ...
10
votes
2answers
2k views

Recovering logical space from a tablespace

I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two datafiles and is set up so it takes up 350 GB of physical space. A week ago I queried ...
4
votes
2answers
2k views

Is Tablespace something like Logical Volume?

I'm confused about tablespaces in PostgreSQL. Is it something like LVM? I mean when disk is getting full, can we add another disk, format and then CREATE TABLESPACE tblspace LOCATION ...
3
votes
1answer
5k views

How can I delete a corrupted table space?

Problem: On an Oracle 11.2g DB; We have a corrupted TS that does not allow starting the database instance above mount state. The TS cannot be removed with standard methods (i.e., enterprise manager). ...
1
vote
1answer
256 views

Oracle block usage

I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2. Now three questions arose: Is there some way of analyzing ...
3
votes
1answer
3k views

DB2 9.5 How to get tablespace monitor information?

How can I get information about tablespace in DB2 9.5? I need to review information about if the autoresize option is enabled or disabled.
2
votes
1answer
3k views

How do I create a database+tablespace+user in Oracle 11gR2?

Good evening, I'm trying to figure out how to create a database+tablespace+user in Oracle 11g. I've tried some tutorials, but nothing seems to work. I cannot find Database Configuration Assistant ...
1
vote
1answer
109 views

How can I measure the performance hit of tablespace autoextensions?

I'm not a DBA, nor is there a DBA on the project I'm currently working, so we have tablespaces with autoextend on next 6m. I have no idea if this is low, although I believe so. I want to measure ...
2
votes
1answer
288 views

Tablespace consumed by views

I was in an SQL class where the instructor said "DBAs don't like it when users create views, because they will clobber tablespace." Obviously, I understand that any schema object will consume some ...
3
votes
2answers
2k views

What are the benefits of using a different tablespace for a new user schema?

The tables in the schema are intended to be used read only and is only updated once each three month. My question refers to performance maintenance (backup/restore, export/import) What about the ...