DROP TABLESPACE(7) SQL Commands DROP TABLESPACE(7)NAME
DROP TABLESPACE - remove a tablespace
SYNOPSIS
DROP TABLESPACE [ IF EXISTS ] tablespacename
DESCRIPTION
DROP TABLESPACE removes a tablespace from the system.
A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be
dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are
using the tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to
temporary files residing in the tablespace.
PARAMETERS
IF EXISTS
Do not throw an error if the tablespace does not exist. A notice is issued in this case.
tablespacename
The name of a tablespace.
NOTES
DROP TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
To remove tablespace mystuff from the system:
DROP TABLESPACE mystuff;
COMPATIBILITY
DROP TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(7)]
SQL - Language Statements 2010-05-14 DROP TABLESPACE(7)
Check Out this Related Man Page
DROP TABLESPACE(7) SQL Commands DROP TABLESPACE(7)NAME
DROP TABLESPACE - remove a tablespace
SYNOPSIS
DROP TABLESPACE [ IF EXISTS ] tablespacename
DESCRIPTION
DROP TABLESPACE removes a tablespace from the system.
A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be
dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are
using the tablespace. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the DROP might fail due to
temporary files residing in the tablespace.
PARAMETERS
IF EXISTS
Do not throw an error if the tablespace does not exist. A notice is issued in this case.
tablespacename
The name of a tablespace.
NOTES
DROP TABLESPACE cannot be executed inside a transaction block.
EXAMPLES
To remove tablespace mystuff from the system:
DROP TABLESPACE mystuff;
COMPATIBILITY
DROP TABLESPACE is a PostgreSQL extension.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], ALTER TABLESPACE [alter_tablespace(7)]
SQL - Language Statements 2010-05-14 DROP TABLESPACE(7)
I have the following code.
sqlString="CREATE USER $1 IDENTIFIED BY $3
DEFAULT TABLESPACE TEMPTABS
TEMPORARY TABLESPACE TEMPSEGS
QUOTA UNLIMITED ON TEMPTABS
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT xxxxxx_ROLE TO $1;
... (2 Replies)
hi buddies
pls help in this matter
i have file like this input file
--------------------------
(PARTITION PARTITION_1 VALUES LESS THAN (101, 16383 ) TABLESPACE PART_1
,PARTITION PARTITION_2 VALUES LESS THAN (101, 32766 ) TABLESPACE PART_2
,PARTITION PARTITION_3 VALUES LESS THAN (101,... (3 Replies)
I am trying to update a script which I had created to monitor tablespace usage.
Originally the sql spooled out to a text file anything with more than 75% used.
I have been asked to change this.
Now the sql must spool out all tablespaces.
The script I have to write should scan the file for... (4 Replies)
Hi,
I need to execute a script to find the tablespace size in oracle.But i get an error.:confused:
Script Executed:-
#!/bin/ksh
ORACLE_SID= oracelinstance
ORACLE_HOME= oracle path
PATH=$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH
sqlplus... (4 Replies)
hello,
i have a dynamic file, which is generated by an ORACLE tool. Now i want to change a string, which begins with TABLESPACE following by "Name of Tablespace". The name of the new TABLESPACE is static.
Example: TABLESPACE new : APPLI
old: TABLESPACE "AMITTEL"
new: TABLESPACE "APPLI"
... (4 Replies)
Hi,
Here is my pattern
CREATE USER LZ
IDENTIFIED BY VALUES 'A0144280ESD70'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP1 PROFILE DEVELOPER_D_1
ACCOUNT UNLOCK
/
The Sed command must look for the Line that contains TEMPORARY TABLESPACE and replace the immediate word... (4 Replies)
this is a little more complex than that. I have a text file and I need to find all the distinct words that appear in a line after the word TABLESPACE
when I grep for just the word tablespace, I get:
how do i parse this a little better so i have a smaller file to read?
This is just an... (4 Replies)
I am trying to replace the line which has string "tablespace" not case senstive....
with below simple script: mysrcipt.sh
sed "s/.*/TABLESPACE USERS/g" create_table > tmp
mv tmp create_table
Is there any better way to do it? If Search string tooooooo long it will be tough to code in... (4 Replies)
I have prepared the below script to monitor the tablespace and alert the users whenever it reaches a threshold limit.
#!/bin/sh
. /home/.profile
sqlplus -s $LOGON << .eof > $scripts/check_tablespace.temp
set pages 0
select tablespace_name, free_percent
from (
SELECT... (4 Replies)
Hi,
I am want find and replace in following content in the file.
i want to repalce a word
TABLESPACE XCRM_<ANY_CHAR>
to TABLESPACE XCRM
Sample File to Replace :
LOB(COMPLEX_VALUE) STORE AS
(
TABLESPACE XCRM_MED_D_NEW
STORAGE(INITIAL 64K BUFFER_POOL DEFAULT)
ENABLE... (3 Replies)
Hi colleagues,
I have the followind script.
db2 -x "select substr(TBSPACE,1,20) TABLESPACE from syscat.tables where tabschema = 'SCHEMA' and tabname like '%XXXX' group by TBSPACE order by TBSPACE" | awk '{print $1}' | while read tablespace
do
db2 "list tablespaces show detail" |grep -p -w... (5 Replies)
hi my code is something like
count=0
echo "oracle TABLESPACE NAME nd TARGET"
while
do
count=`expr $count + 1`
(1) tts_space_name$count=`echo $tts | cut -d "," -f$count`
(2) target$count=grep $(tts_space_name$count)... (2 Replies)
Hi Folks,
I am using db2 command -> db2 list tablespace show detail
Tablespace ID = 10
Name = TSCDDHLMSUM
Type = Database managed space
Contents = All permanent data.... (5 Replies)
Hi ,
Can any one help me out how to remove space from below line
select file_name from dba_data_files where tablespace_name='SYSTEM ----space---- ';
i want as :
select file_name from dba_data_files where tablespace_name='SYSTEM';
my code i use
file=/u01/script/latest/tbs.temp
while... (14 Replies)
Anyone who knows where I can find home made scripts that monitoring a oracle database ?
Bourne, korn or perl scripts ..... monitoring processes and maybe tablespace and so on ... (2 Replies)