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
If you want to drop ALL the partitions, then just drop
the table (with the normal 'drop table xxx').
hth
connor
--- Simon Waibale [EMAIL PROTECTED] wrote: 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
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
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL