RE: Is is safe to drop an empty tablespace?

From: <genegurevich_at_discover.com>
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-l
Received on Thu Mar 27 2008 - 09:28:30 CDT

Original text of this message