All Questions
Tagged with tablespaces index
8 questions
0
votes
0
answers
49
views
Create an index at oracle sql server on tablespace
I want to create an index of type context on a tablespace different from the one the table is. Also I want to pass parameters.
The data type of ATTACH_BIN is BLOB.
CREATE INDEX ATT_INDEX
ON ...
- 1
1
vote
1
answer
1k
views
PostgreSQL: Table and index on different tablespace
In PostgreSQL i have the freedom of choosing to put index (of a table or materialized view) on tablespace other than the one i chose for the table (or materialized view) itself.
Is there any ...
- 219
0
votes
1
answer
2k
views
How to import an existing schema and tablespace into a postgres database, from a filesystem-level backup
Follow-up question from:
Have postgres' pg_dump export an index
Say I have an existing database, and I want to add to it another schema with content. I saved that content previously through a ...
- 135
4
votes
1
answer
922
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 ...
- 977
2
votes
1
answer
210
views
How do I recover my database after losing a tablespace with indexes?
I'm thinking of moving all the indexes in my PostgreSQL 9.3 database to a tablespace on an SSD for improved performance. This SSD is not in a RAID array and I need to consider a scenario where it ...
- 471
7
votes
1
answer
133k
views
Oracle - ORA-01654: unable to extend index in tablespace
I referred to the below related question, but it was not helpful in my case:
ORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace>
I ...
- 337
1
vote
1
answer
4k
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 ...
- 213
1
vote
1
answer
2k
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?
- 11