Tablespace Error

Aug
21

Error: SQL0284N The table was not created

Tech Guy on August 21st, 2009

DB2 Error: SQL0284N

Description : The table was not created because the table space tablespace-name following the clause clause is a tablespace-type table space.

Explanation:
The CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement specified a table space named tablespace-name following the clause clause that is not a valid type of table space for this [...]

Continue reading about Error: SQL0284N The table was not created

RedditFacebookStumbleuponDiggDel.icio.us DB2 No comments »
Aug
21

Error: SQL0290N Table space access is not allowed

Tech Guy on August 21st, 2009

DB2 Error: SQL0290N

Description :Table space access is not allowed.

Explanation:
A process attempted to access a table space which is in an invalid state for which the intended access is not allowed.

If the table space is in a quiesced state, only processes which also hold the table space in a quiesced state are [...]

Continue reading about Error: SQL0290N Table space access is not allowed

DB2 No comments »
Aug
21

ORA-01652 unable to extend temp segment by 64 in tablespace

Tech Guy on August 21st, 2009

Solution:
1. Check the datafile location of the tablespace where the space issue has raised.
SQL>Select file_name, from dba_data_files where tablespace_name=’TN’;

2. Check whether there is space in the tablespace from the following query.
SQL>select tablespace_name, sum (bytes/1024/1024) from dba_free_space where tablespace_name=’TN’ GROUP BY tablespace_name;

select tablespace_name, sum (bytes/1024/1024) from dba_free_space GROUP BY tablespace_name, file id;
If there is no space [...]

Continue reading about ORA-01652 unable to extend temp segment by 64 in tablespace

Oracle No comments »