Oracle-L: Re: Partitioned oracle tables

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Wed, 24 Apr 2002 05:53:23 -0800
Message-ID: <F001.0044DAD0.20020424055323@fatcity.com>

Obviously, partitioned table needs to have at least one partition. Why don't you just try to drop the table, and then recreate it as non-partitioned (if that's, what you want).

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 24, 2002 4:43 AM

Hi all,
We have two partitioned tables, T1 and T2. T1 belongs to one user and has 8 partitions, 3 users have a table called T2 with 8 partitions. We are trying to :

1) Alter tables (T1,T2) drop all partitions
2) Take tablespaces holding the partitions offline
3) Drop tablespaces
4) drop users

Trouble is in step step 1 for table T2 where we get a)ora 144083: cannot drop the only partition of a partitioned table b)ora 14404: partitioned table contains partitions in a different tablespace

Can anyone try and explain to me the breakdown in my steps to get rid of the partitioning ?
Platform: Oracle 81700 on Tru64 Unix

Thanking you,

---
CSW
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
  INET: waibals_at_mtn.co.ug

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed Apr 24 2002 - 08:53:23 CDT