RE: Is is safe to drop an empty tablespace?
Date: Thu, 27 Mar 2008 09:28:30 -0500
Message-ID: <OF9FF2DC70.C43B982E-ON86257419.004F4563-86257419.004F844B@discover.com>
VGhhbmsgeW91LCBCcmFkZCBhbmQgTWFyay4NCg0KSSBhbSBwbGFubmluZyB0byBkbyBkcm9wIHRh
Ymxlc3BhY2UgbGlrZSB5b3Ugc3VnZ2VzdGVkLiBNeSBjb25jZXJuIHdhcyB0aGF0DQppZiB0aGVy
ZSBpcyBhIHVzZXIgdGhhdCBoYXMNCnRoaXMgdGFibGVzcGFjZSBhcyBkZWZhdWx0LCB0aGVuIGZv
ciB0aGlzIHVzZXIgdGhlIG5leHQgY29tbWFuZCAiY3JlYXRlDQp0YWJsZSIgd291bGQgZmFpbCBp
ZiB0aGUgdGFibGVzcGFjZQ0KaXMgbm90IHNwZWNpZmllZC4gSSB3aWxsIHRha2UgY2FyZSBvZiB0
aGlzIHNjZW5hcmlvIGJ5IGNoZWNraW5nIHRoZQ0KZGJhX3VzZXJzIHRhYmxlLiBCdXQgSSBkaWQg
bm90IGtub3cgd2hhdA0Kb3RoZXIgcG9zc2libGUgc2NlbmFyaW9zIGNvdWxkIGJlIGZvciBzb21l
b25lIHRyeWluZyB0byB1c2UgdGhpcyB0YWJsZXNwYWNlDQphZnRlciBpdCBpcyBnb25lLiBTb3Vu
ZHMgbGlrZQ0KdGhlcmUgaXMgbm9uZS4NCg0KdGhhbmsgeW91DQoNCkdlbmUgR3VyZXZpY2gNCg0K
DQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICJCb2JhaywgTWFyayIgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAg
PE1hcmsuQm9iYWtAcHJvcXUgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICANCiAgICAgICAgICAgICBlc3QuY29tPiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIFRvIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgInBpb250ZWtkZEBnbWFpbC5jb20iICAgICAgICAgICAgICAgDQogICAgICAgICAg
ICAgMDMvMjcvMjAwOCAwOTowOCAgICAgICAgICA8cGlvbnRla2RkQGdtYWlsLmNvbT4sICAgICAg
ICAgICAgICANCiAgICAgICAgICAgICBBTSAgICAgICAgICAgICAgICAgICAgICAgICJnZW5lZ3Vy
ZXZpY2hAZGlzY292ZXIuY29tIiAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgPGdlbmVndXJldmljaEBkaXNjb3Zlci5jb20+ICAgICAgICAgDQogICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICBjYyANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJvcmFj
bGUtbEBmcmVlbGlzdHMub3JnIiAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgPG9yYWNsZS1sQGZyZWVsaXN0cy5vcmc+ICAgICAgICAgICAgDQogICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgU3ViamVjdCANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFJF
OiBJcyBpcyBzYWZlIHRvIGRyb3AgYW4gZW1wdHkgICAgIA0KICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgdGFibGVzcGFjZT8gICAgICAgICAgICAgICAgICAgICAgICAgDQog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQoNCg0KDQoNCkhhdmluZyBxdW90YXMgb24gYSB0YWJsZXNwYWNlIHdvbuKAmXQgcHJldmVu
dCBoaW0gZnJvbSBkcm9wcGluZyBpdC4gIFRob3NlDQpxdW90YXMgd2lsbCBqdXN0IGdvIGF3YXku
DQoNCklmIHlvdSBkbzoNClNlbGVjdCBzZWdtZW50X3R5cGUsc2VnbWVudF9uYW1lIGZyb20gZGJh
X3NlZ21lbnRzIHdoZXJlIHRhYmxlc3BhY2VfbmFtZSA9DQrigJhUU19ZT1VfV0FOVF9UT19EUk9Q
4oCZIGFuZCBzZWdtZW50X3R5cGUgIT3igJlURU1QT1JBUlnigJk7DQpBbmQgeW91IGdldCB6ZXJv
IHJvd3MsIGl0IHNob3VsZCBiZSBzYWZlIHRvIGRyb3AuDQoNClRvIGJlIGNlcnRhaW4sZG86DQpE
cm9wIHRhYmxlc3BhY2UgdGFibGVzcGFjZV95b3Vfd2FudF90b19kcm9wOw0KV2l0aG91dCB0aGUg
4oCYaW5jbHVkaW5nIGNvbnRlbnRz4oCZIGNsYXVzZSwgYW5kIGlmIHRoZXJl4oCZcyBhbnl0aGlu
ZyBsZWZ0IGluDQppdCwgT3JhY2xlIHdvbuKAmXQgZHJvcCBpdC4NCg0KLU1hcmsNCg0KLS0NCk1h
cmsgSi4gQm9iYWsNClNlbmlvciBEYXRhYmFzZSBBZG1pbmlzdHJhdG9yLCBTeXN0ZW0gJiBQcm9k
dWN0IFRlY2hub2xvZ2llcw0KUHJvUXVlc3QNCjc4OSBFLiBFaXNlbmhvd2VyLCBQYXJrd2F5LCBQ
Lk8uIEJveCAxMzQ2DQpBbm4gQXJib3IgTUkgNDgxMDYtMTM0Ng0KKzEuNzM0Ljk5Ny40MDU5ICBv
ciArMS44MDAuNTIxLjA2MDAgeCA0MDU5DQptYXJrLmJvYmFrQHByb3F1ZXN0LmNvbQ0Kd3d3LnBy
b3F1ZXN0LmNvbQ0Kd3d3LmNzYS5jb20NCg0KUHJvUXVlc3QuLi5TdGFydCBoZXJlLg0KDQpGcm9t
OiBvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZyBbbWFpbHRvOm9yYWNsZS1sLWJvdW5jZUBm
cmVlbGlzdHMub3JnXQ0KT24gQmVoYWxmIE9mIEJyYWRkIFBpb250ZWsNClNlbnQ6IFRodXJzZGF5
LCBNYXJjaCAyNywgMjAwOCA5OjU4IEFNDQpUbzogZ2VuZWd1cmV2aWNoQGRpc2NvdmVyLmNvbQ0K
Q2M6IG9yYWNsZS1sQGZyZWVsaXN0cy5vcmcNClN1YmplY3Q6IFJlOiBJcyBpcyBzYWZlIHRvIGRy
b3AgYW4gZW1wdHkgdGFibGVzcGFjZT8NCg0KWW91IG1heSB3YW50IHRvIHZlcmlmeSB0aGF0IG5v
IG9uZSBoYXMgcXVvdGFzIG9uIHRoaXMgdGFibGVzcGFjZS4NCnNlbGVjdCAqIGZyb20gZGJhX3Rz
X3F1b3RhcyB3aGVyZSB0YWJsZXNwYWNlX25hbWUgPSAnQkxBSCc7DQoNCktlZXAgaW4gbWluZCB0
aGF0IHNjaGVtYSB3aXRoIFVOTElNSVRFRCBUQUJMRVNQQUNFIChEQkEgUm9sZSwgdXNlZCB0byBi
ZQ0KcmVzb3VyY2UgaW4gPDEwZykgY291bGQgYWxzbyBiZSB1c2luZyB0aGUgdGFibGVzcGFjZS4N
Ck9uIDMvMjcvMDgsIGdlbmVndXJldmljaEBkaXNjb3Zlci5jb20gPGdlbmVndXJldmljaEBkaXNj
b3Zlci5jb20+IHdyb3RlOg0KSGkgRXZlcnlib2R5Og0KDQpJIGFtIHBsYW5uaW5nIHRvIGRyb3Ag
YW4gZW1wdHkgdGFibGVzcGFjZS4gSSBoYXZlIGNvbmZpcm1lZCB0aGF0IG5vIHVzZXINCmhhcyBp
dCBkZWZpbmVkIGFzIGEgZGVmYXVsdA0KKHNlbGVjdCBkaXN0aW5jdCBkZWZhdWx0X3RhYmxlc3Bh
Y2UgZnJvbSBkYmFfdXNlcnMpLCBhbmQgbm8gdGFibGUvaW5kZXggaGFzDQppdCBkZWZpbmVkIGFz
IGRlZmF1bHQNCihzZWxlY3QgZGlzdGluY3QgZGVmX3RhYmxlc3BhY2VfbmFtZSBmcm9tIGRiYV9w
YXJ0X3RhYmxlcy9pbmRleGVzKS4gSVMNCnRoZXJlIGFueSBvdGhlciBwbGFjZQ0KSSBzaG91bGQg
Y2hlY2sgdG8gY29uZmlybSB0aGF0IG5vb25lIGhhcyB0aGlzIHRhYmxlc3BhY2UgZGVmaW5lZCBh
cyBkZWZhdWx0DQpmb3IgYW55IHB1cnBvc2VzPw0KDQp0aGFuayB5b3UNCg0KR2VuZSBHdXJldmlj
aA0KDQoNCg0KLS0NCmh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdlL29yYWNsZS1sDQoN
Cg==
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2008 - 09:28:30 CDT