the real DBAs aren't around for a few days, so rather than
shoot myself in a tender spot, i thought i'd ask first.
what docs i can find say that the syntax is:
DROP TABLESPACE FOO
seems simple enough, except that the other side is
CREATE TABLESPACE FOO IN BARx
in this shop, BAR is referred to as a database (not sure
that's what DB2 thinks it is). there are multiple
FOO tablespaces spread over many BAR1, BAR2, etc. so,
how does DB2 know which FOO to drop??
thanks,
robert 2 6435
"robert" <gn*****@rcn.co m> wrote in message
news:da******** *************** ***@posting.goo gle.com... the real DBAs aren't around for a few days, so rather than shoot myself in a tender spot, i thought i'd ask first.
what docs i can find say that the syntax is:
DROP TABLESPACE FOO
seems simple enough, except that the other side is
CREATE TABLESPACE FOO IN BARx
in this shop, BAR is referred to as a database (not sure that's what DB2 thinks it is). there are multiple FOO tablespaces spread over many BAR1, BAR2, etc. so, how does DB2 know which FOO to drop??
thanks, robert
You need the SQL Reference manual. You can download the PDF version from the
IBM website.
DROP TABLESPACE BARX.FOO
Here is the stuff from the manual:
DROP TABLESPACE database-name.table-space-name
Identifies the table space to be dropped. The name must identify a table
space
that exists at the current server. The database name must not be DSNDB06.
Omission of the database name is an implicit specification of DSNDB04.
Whenever a table space is directly or indirectly dropped, all the tables in
the
table space are also dropped. The name of a dropped table space cannot be
reused until a commit operation is performed.
A table space in a TEMP database can be dropped only if it does not contain
an active declared temporary table. A LOB table space can be dropped only if
it
does not contain an auxiliary table.
Whenever a base table space that contains tables with LOB columns is
dropped, all the auxiliary tables and indexes on those auxiliary tables that
are
associated with the base table space are also dropped.
"Mark A" <ma@switchboard .net> wrote in message news:<kc******* **********@news .uswest.net>...
i had looked up the syntax in our local copy of
the 390/V6 manual.
i'll get a new copy of the pdf.
thanks,
robert "robert" <gn*****@rcn.co m> wrote in message news:da******** *************** ***@posting.goo gle.com... the real DBAs aren't around for a few days, so rather than shoot myself in a tender spot, i thought i'd ask first.
what docs i can find say that the syntax is:
DROP TABLESPACE FOO
seems simple enough, except that the other side is
CREATE TABLESPACE FOO IN BARx
in this shop, BAR is referred to as a database (not sure that's what DB2 thinks it is). there are multiple FOO tablespaces spread over many BAR1, BAR2, etc. so, how does DB2 know which FOO to drop??
thanks, robert
You need the SQL Reference manual. You can download the PDF version from the IBM website.
DROP TABLESPACE BARX.FOO
Here is the stuff from the manual:
DROP TABLESPACE database-name.table-space-name
Identifies the table space to be dropped. The name must identify a table space that exists at the current server. The database name must not be DSNDB06. Omission of the database name is an implicit specification of DSNDB04. Whenever a table space is directly or indirectly dropped, all the tables in the table space are also dropped. The name of a dropped table space cannot be reused until a commit operation is performed.
A table space in a TEMP database can be dropped only if it does not contain an active declared temporary table. A LOB table space can be dropped only if it does not contain an auxiliary table.
Whenever a base table space that contains tables with LOB columns is dropped, all the auxiliary tables and indexes on those auxiliary tables that are associated with the base table space are also dropped. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Darshak Shah |
last post by:
Hi,
* Question background :
My DB is in ArchiveLog mode.
I have TS in ReadOnly mode.
As i know,
- Oracle allows to DROP table resides in ReadOnly TS (& other objects
also) even though that TS is in ReadOnly mode.
- Oracle will not recover ReadOnly TS during Oracle startup.
|
by: sandeep G |
last post by:
I've a table which has a number & a blob column, both of which are NOT
NULL type. This table is composite partitioned using range & hash on
the same column.
Each partition is sub partitioned into two.
Now if I try to move the partitions to a different tablespace I get an
oracle error sayiing that ERROR: ORA_14257 cannot move partition other
than a Range or Hash partition
Now is there any other way to move the partition to another
|
by: Ian Dobson |
last post by:
Hi, I need to drop a schema from a database but it has 400 tables in it.
Is there an easy way to do it other than
drop table schema1.table1
drop table schema1.table2
etc.. to 400 and then
drop schema schema1?
thanks
|
by: robert |
last post by:
just got out of a "class" on EXPLAIN, from a 390/v6 maven. was told
that ACCESSTYPE = 'R' in the plan_table meant a TableSpace scan.
hmmmm. next step up (or down, depending on your outlook) wasn't a
Table Scan.
thought this might be a MainFrame thing; but a look at DB2Info on my
UDB 7.2 server showed the same thing.
this is truly puzzling. is there an explanation of EXPLAIN which
describes how to get a Table Scan???? or are we...
|
by: deko |
last post by:
Can the DROP TABLE statement be used with a select or where statement?
DROP TABLE SELECT *
FROM tblTablesImported
WHERE Import_ID Not In
(SELECT FROM tblTablesInternal);
Or do I have to supply a parameter like:
DROP TABLE Sheet1
| |
by: vj_dba |
last post by:
Hi Group,
I have a problem in restoring my tablespace, my database is running in
ARCHIVAL logging, I created a tablespace, did some transaction, then
took the ONLINE BACKUP of the tablespace. Then I dropped the tablespace
and tried to restore from the tablespace backup image, when I do this
it's throwing error
SQL2549N The database was not restored because either all of the table
spaces
|
by: jainarayan5484 |
last post by:
hi All,
Sir
i want to know That What is the need to Create Tablespace,Alter TableSpace,Drop Tablespace.Whereas database use default tablespace.
plz help me
jai
|
by: wugon.net |
last post by:
Env:
DB2 LUW V8 + FP14
AIX 5.3
Problem Description:
Our production database create one big temporary tablespace to do off-
line reorg,
after reorg complete, we drop this tablespace online but we found the
containers /dev/tmplv lv state is open , can not be remove via aix
|
by: bujjus173 |
last post by:
Hi,
I need to drop a tablespace, I am unable to drop because it says the
containers it uses is inaccessible, because a process deleted the
container. the tablespace went into pending state. I just want to drop
the table in it and the tablespace. i dont need that. but i need the
name of the table it is using. i creted another table in another
tablespace, i will rename that once i can drop this table.&
tablespace.
Can anyone help me on...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |