A database storage unit that groups related logical structures together.

learn more… | top users | synonyms

1
vote
1answer
59 views

Oracle - Using index on unique constraint, what the deal?

Using Druid to generate SQL script for Oracle, I have seen a difference between the version 3.10 and 3.13 and I would like to understand what going on. SQL generated by Druid 3.10 : CREATE TABLE ...
1
vote
0answers
47 views

SQL Server vs Oracle [closed]

I am transitioning from SQL Server DBA to Oracle DBA. I have minimal experience with Oracle, and I have found that the best way for me to traverse if by correlating terminology and database engine ...
1
vote
1answer
61 views

Understanding of schema and tablespaces - recommendation for a later seperation [closed]

DLDR: I would like to get a confirmation of my understanding of tablespaces and schemas (see image) a recommendation how to organize schemas and tablespace to make a later separation easy. ...
0
votes
1answer
26 views

Instant File Initialisation on Windows Oracle Server

I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile. Is it possible to allow Oracle the same capability as SQL Server using ...
1
vote
1answer
37 views

Critical tablespace usage UNDOTBS (96%)

This tablespace is in my case 8GB. I'm on oracle 10g and got critical warning: Tablespace usage critical: UNDOTBS (96%) I also executed this command: select sum (bytes/1048576) MB FROM ...
0
votes
0answers
30 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
1answer
147 views

How to split a MySQL table file?

I have a table in a MySQL database for which innodb_file_per_table is enabled. One of my tables is about 20GB and growing. How can I partition the table into separate files? Suppose that I have a ...
1
vote
2answers
108 views

Different table size on sp_spaceused and standard report “Disk Usage by Top Tables”

I ran sp_spaceused and Disk Usage by Top Tables standard report for a table. The results for sp_spaceused are: name rows reserved data index_size unused SomeTable <1301755> ...
0
votes
0answers
14 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
1answer
71 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
53 views

Postgres tablespace on mounted usb

I've got postgres 9.1 running on raspbian installed with apt-get. I've got NTFS usb HDD mounted in /mnt/usb. What I'd like to achieve is to create a tablespace pointing to /mnt/usb/postgres so I ...
0
votes
0answers
193 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
2answers
158 views

MySQL - Changing from system tablespace to file per table

The MySQL database I am working on has the InnoDB tables and indexes stored in the system tablespace which is now > 20Gb. Some years ago I managed a MySQL database that made use of a file per table ...
0
votes
0answers
12 views

looking for mysql tablespaces introduction

What would be a good place to read about the advantages of splitting data across several MySQL table spaces (as well as limitations that come along with that) ?
1
vote
2answers
92 views

Does changing a Postgresql table's tablespace compact it like “vacuum full” or “cluster”?

I need to reclaim disk space in a table in a Postgresql 9.3.2 database to be used for other tables. The standard suggestions to accomplish this are: "VACUUM FULL" or "CLUSTER" or copy the contents ...
6
votes
2answers
274 views

Why doesn't a delete increase unused space in a table?

If I populate the following table: IF OBJECT_ID ('dbo.CleanTableTest', 'U') IS NOT NULL DROP TABLE dbo.CleanTableTest; GO CREATE TABLE dbo.CleanTableTest (FileName nvarchar(4000), ...
0
votes
1answer
373 views

How to create a tablespace on Windows 7 for Postgresql 9.2?

I try to run this simple command: CREATE TABLESPACE tb_rec OWNER postgres LOCATION 'd:/tablespaces'; However, the tablespace is not created and I got this message: ERREUR: n'a pas pu ...
0
votes
1answer
62 views

Altering multiple tablespaces at once in Oracle

I need help in altering multiple tablespaces at once in Oracle Database 11g. My particular scenario is that this command will be used in a shell script to set all of the tablespaces in read-write mode ...
3
votes
1answer
138 views

How do databases deal with file system fragmentation?

Especially analytic databases that try to optimize for queries that scan large portions of tables instead of randomly accessing specific rows. For example Redshift has a concept of a sort key that, ...
1
vote
0answers
13k 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: ...
0
votes
0answers
180 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
1answer
62 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
105 views

oracle tablespaces

I export db from user which is related on tablespace USER on local PC and import to user which is related to tablespace DATATAB on server....my question is: will data be stored in DATATAB tablespace ...
2
votes
2answers
246 views

Restoring a tablespace to a different database

Any ideas as to how we can re-create a tablespace on a different server? We have a cold backup, so we can copy the datafiles to the target server. Can we just create a new instance on the target ...
0
votes
1answer
142 views

How do tablespaces differ in DB2 from databases in MySQL or SQL Server? [closed]

In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously. What are ...
3
votes
0answers
100 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
votes
1answer
677 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 ...
0
votes
1answer
298 views

Tablespace of an index organized table

I want to find the tablespace of an index organized table with primary key. With dba_segments I can only find the tablespace for the primary key. But how can I find the tablespace for the table?
1
vote
2answers
93 views

what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?

I have a 10 billion records table so I need to improve space allocation. My table has only fields of type floating point (single-precision). What is the best choice, NUMBER or BINARY_FLOAT or ...
2
votes
1answer
98 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 ...
0
votes
0answers
441 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 ...
1
vote
1answer
683 views

How do I access a old saved tablespace after reinstalling postgres?

So a lot of things might have gone wrong here. I first installed postgres 9.3 on mac 9.1 via homebrew to manage some data. I am using postgres.app. Turns out my harddrive was too small so I decided to ...
0
votes
1answer
58 views

Orace tablespace extension operation

Could somebody clarify whether tablespace expansion procedure in Oracle 11g database requires any downtime or could impact availability of the database? My understanding that this can be done "on the ...
1
vote
1answer
1k views

Tablespace resize in Oracle 10g

I'm trying to resize a couple of tablespaces but the following query is only valid in Oracle 11g. alter tablespace 2 DATAFILE '/appli2/oracle/xxx/oradata02/xxx_undo_01.dbf' resize 3g; In oracle ...
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 ...
2
votes
2answers
314 views

What are the performance benefits of segregating database objects into different tablespaces?

As the question states, what are the benefits of doing this given the following information/constraints: I will not be using partitioning I will not be placing the tablespaces and its datafiles into ...
2
votes
2answers
958 views

MySQL Cluster - Got error 1601 'Out extents, tablespace full' from NDB

I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: CREATE DATABASE test1; use test1; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' ENGINE = NDB; ...
1
vote
1answer
2k views

Is there a way to determine automatic storage table spaces?

First off, we are on both Windows and AIX and are using DB2 ESE 9.7 FP 4. I am trying to determine dynamically whether or not table spaces are set up via automatic storage or not (so we can ...
0
votes
1answer
135 views

Tablespaces in oracle

I understand that tablespace is a logical collection of tables and database objects. It could be made up of multiple data files (which is the physical collection of objects). Apart from this, what is ...
1
vote
1answer
4k views

Oracle, Create table with inline constraint declarations using a different tablespace

I have two questions about inline constraints declarations for Oracle tables: Is it a bad practice? If so, why? How could one declare a different tablespace for the primary key and index like it's ...
1
vote
1answer
870 views

db2 LUW help for an oracle user : create database hangs without any output, but database got created

I am new to db2 but have worked on oracle before. Trying to create a database and it succeeds, but the session where I issued a database creation command hangs. I have installed db2 10.5 on a 64 bit ...
2
votes
1answer
426 views

Any advantage of creating table in temporary tablespace - Oracle

My on-site DBA told me to create the particular table on temporary tablespace.Is there any advantage of such action?
0
votes
1answer
2k views

DB2 LUW: Should temporary tablespaces share bufferpools with other tablespaces?

We are in the process of tuning a massive application our company has just written. Part of that tuning includes tuning the databases. We run DB2 LUW on AIX. Specifically we are at 9.7 Fix Pack 4 ...
-1
votes
1answer
176 views

How to put one table on one disk and anther table on another (a ramdisk)?

I need to build a database with one table stored on one disk and anther table stored on a different disk (a ramdisk). Is it possible to do it? As far as I know, using two separate databases, one ...
1
vote
1answer
3k views

Oracle database created whats next? Create Schema or Create Tablespace?

I'm a programmer that's being thrown to the DBA/Sysadmin island all by myself with a volleyball that I named Wilson. I'm trying to survive here. I'm supposed to create a database for an application. ...
1
vote
1answer
460 views

Why we need auxiliary instance in TSPITR

Need help! I've read Database Backup and Recovery User's Guide 11g but I can't uderstand why we need auxiliary instance to perform tspitr. We can do complete recovery of tablespace within same ...
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 ...
4
votes
3answers
29k 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
109 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? ...