tablespace Questions
28
I am running a local server of MySQL 5.6.10 on MacOS 10.8.3 and manage my database via Navicat essentials for MySQL.
The error I get is that after running and managing my database just fine for a c...
Hydric asked 28/3, 2013 at 23:49
4
Solved
What's the psql command to view all existing tablespaces?
\l+ displays all existing databases with their configured tablespace, but it won't display tablespaces which have been created but don't ...
Sisal asked 14/2, 2020 at 12:28
3
Solved
When i tried to create a table in my User_DB schema i am getting an error as ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA. I run the following query to get all the T...
Spathose asked 6/5, 2016 at 11:23
7
Solved
I've created a new tablespace called indexes, and I'm trying to remove the old tablespace indexes_old, which used to contain some tables and indexes. When I try to drop the tablespace, I get:
=>...
Heterocyclic asked 11/2, 2011 at 15:39
3
Solved
I'm trying to create a tablespace in postgres, but I'm getting ownership problems. The command I'm using is:
CREATE TABLESPACE magdat OWNER maggie LOCATION '/home/john/BSTablespace'
I get the er...
Benediction asked 6/3, 2011 at 1:45
5
Solved
While investigating an issue, I came across this error:
30503 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at f...
Yand asked 14/6, 2016 at 7:13
3
Solved
I am using PostgreSQL 9.2 on RedHat 6. I am looking for the database table and column which stores the location for a PostgreSQL tablespace. I thought it would be in PG_TABLESPACE, but
select * fro...
Voiced asked 5/2, 2016 at 10:32
4
I have a database with three tables. I need to move historic partitioned data to other schema
Now that i´m planning to creatre the new "historic" tables. I don´t know how to measure the size of par...
Thermy asked 27/2, 2013 at 13:48
12
Solved
Our application has failed a few times because an 'ORA-01536: space quota exceeded for tablespace', and we would like to be able to prevent this by checking regularly the free space on the tablespa...
Prelude asked 6/10, 2011 at 8:56
3
Solved
I tried to generate some test data by running the following sql.
BEGIN
FOR i IN 1..8180 LOOP
insert into SPEEDTEST
select 'column1', 'column2', 'column3', 'column4', 'column5', 'column6', 'col...
Anagrammatize asked 25/11, 2014 at 14:32
2
Solved
I have created this tablespace
CREATE TABLESPACE IA643_TBS
DATAFILE 'IA643_dat' SIZE 500K
AUTOEXTEND ON NEXT 300K MAXSIZE 100M;
I tried to drop it using this command
DROP TABLESPACE IA643_TBS;
...
Identify asked 23/10, 2014 at 20:35
2
Solved
I recently needed to import a .dmp into a new user I created. I also created a new tablespace for the the user with the following command:
create tablespace my_tablespace
datafile 'C:\My\Oracle\I...
Minna asked 20/5, 2015 at 20:16
2
Solved
I am executing PostgreSQL functions to update a table which has a huge amount of data and the update happens for about 100000 records everyday. During the update I get an error saying:
"could not ...
Damages asked 13/4, 2015 at 9:49
4
Solved
I am creating a table like
create table tablename
as
select * for table2
I am getting the error
ORA-01652 Unable to extend temp segment by in tablespace
When I googled I usually found ORA-016...
Clabo asked 7/8, 2012 at 5:6
2
Solved
Is there way to list only temp tablespaces in Oracle? I found following query which is listing all the tablespaces, I just need only temp tablespaces.
SQL> select tablespace_name from dba_table...
Dewaynedewberry asked 3/8, 2015 at 5:50
2
Solved
How to find out which 'tablespace' a particular 'index' belongs to. (oracle)
(need to use it via jdbc)
Hath asked 3/5, 2011 at 9:3
1
Solved
I had created a user in oracle 12c standard edition.
Now I tried to create a table using the username and password in sql developer, but I am getting the following error.
SQL Error: ORA-01950: no...
Reserved asked 1/7, 2017 at 7:28
1
Solved
I get following error message when trying to insert an object in the database:
com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:
DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=T...
Myocardium asked 4/1, 2017 at 15:32
6
Solved
I have a partitioned table that belongs to tablespace report. I want to move it to tablespace record instead.
One possibility is to drop the table and recreate it in the new tablespace, but that i...
Squamation asked 4/1, 2010 at 10:16
2
Solved
As it says on the Oracle XE overview page:
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 4GB of user da...
Encroachment asked 27/3, 2011 at 9:23
1
Solved
I need to check space used by a tablespace but I have no dba privs. Is there a way to do this?
Woolery asked 12/2, 2015 at 11:53
2
Solved
i have many tables that i can insert rows, but i get this error only for one table;
Error starting at line 1 in command:
INSERT INTO ERRORLOG (MESSAGE) VALUES ('test')
Error report:
SQL Error: ORA...
Wolfish asked 14/1, 2015 at 10:16
3
Solved
Hi Can some let me know why we created different table space for Index and data.
Monotint asked 30/11, 2009 at 12:25
1
Solved
I'm getting this error:
ORA-01950: no privileges on tablespace 'USERS'
I have a default tablespace and I'm able to create tables, however, they do not show at the objects tab in Toad.
I ...
Hanukkah asked 10/2, 2014 at 7:10
5
Solved
I need to determine the MAXSIZE that was set for a tablespace when it was created (Oracle 10g)
I'm sure I'm missing something obvious, but the information isn't immediately apparent in the informa...
Schuh asked 2/3, 2010 at 15:0
1 Next >
© 2022 - 2025 — McMap. All rights reserved.