Message-Id: <10521.108160@fatcity.com> From: john.j.kanagaraj@shell.com.bn Date: Thu, 8 Jun 2000 09:20:09 +0800 Subject: RE: Cloning Oracle8i --openmail-part-094774b5-00000001 Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT" Content-Disposition: inline; filename="BDY.TXT" Content-Transfer-Encoding: 7bit > I got only one response to my previous question about using the new > feature in Oracle8i for copying tablespaces between databases as a > possible way to clone databases. And that person just used imp/exp. > > So, am I to take it then that no one uses tablespace copies? Tony, I don't have your previous query, but I think you cannot clone an _entire_ Oracle8i database using TT. Although not specifically mentioned, the SYSTEM Tbs can never be transported - ergo no complete cloning is possible. John Kanagaraj Brunei Shell Petroleum http://www.geocities.com/john_sharmila God so loved the world that He didn't send a committee! (See John 3:16 for details) ** Opinions expressed here are solely mine and not necessarily those of my employer ** --openmail-part-094774b5-00000001 Content-Type: application/ms-tnef; name="WINMAIL.DAT" Content-Disposition: attachment; filename="WINMAIL.DAT" Content-Transfer-Encoding: base64 eJ8+ItU/AQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABABUAAABSRTogQ2xvbmluZyBPcmFjbGU4 aQDSBgEDkAYADAAAAAEAAAALAAIAAQAAAA8AAQOQBgAQAAAAAQAAAEAAOQAACzis59C/AeAD AQOQBgAkAAAAAQAAAB4AQgABAAAAEgAAAEpvaG4gSi4gS2FuYWdhcmFqAAAAOwYBA5AGABAA AAABAAAAQABIADCzYq7n0L8B8wQBA5AGACgAAAABAAAAHgBwAAEAAAAVAAAAUkU6IENsb25p bmcgT3JhY2xlOGkAAAAAdwcBA5AGACgAAAABAAAAAgFxAAEAAAAWAAAAAb/Q56wHfRhmBzzJ EdSTVABgl5kRswAA3QkBA5AGAAwAAAABAAAAAwAGEBJFawXhAAEDkAYADAAAAAEAAAADAAcQ XQIAAHoAAQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAElHT1RPTkxZT05FUkVTUE9OU0VUT01Z UFJFVklPVVNRVUVTVElPTkFCT1VUVVNJTkdUSEVORVdGRUFUVVJFSU5PUkFDTEU4SUZPUkNP UFlJTkdUQUJMRVNQQUNFU0JFVFdFRU4AAAAAeB4BA5AGAAwAAAABAAAAAwAQEAEAAAAlAAED kAYADAAAAAEAAAADABEQAAAAACUAAQOQBgAQAAAAAQAAAEAABzDQEfwh4dC/AecEAQOQBgAQ AAAAAQAAAEAACDAQxLo459C/AbYEAQOQBgAgAAAAAQAAAAIBCzABAAAAEAAAAARmGH3JPNQR k1QAYJeZEbN0BgEDkAYADAAAAAEAAAADAN4/r28AAD8CAQOQBgAkAAAAAQAAAAMAEIYIIAYA AAAAAMAAAAAAAABGAAAAABCFAAAAAAAAYwIBA5AGACQAAAABAAAAAwARhgggBgAAAAAAwAAA AAAAAEYAAAAAAYUAAAAAAABVAgEDkAYAJAAAAAEAAAADABKGCCAGAAAAAADAAAAAAAAARgAA AAARhQAAAAAAAGYCAQOQBgAkAAAAAQAAAAMAE4YIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADj FQAAoAMBA5AGACwAAAABAAAAHgAUhgggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAA OC41AGYDAQOQBgAkAAAAAQAAAAsAFYYIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAZgIB A5AGACQAAAABAAAACwAWhgggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAABvAgEDkAYAJAAA AAEAAAADABeGCCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAHICAQOQBgAsAAAAAQAAAB4A GIYIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAACuAgEDkAYALAAAAAEAAAAe ABmGCCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAsAIBA5AGACwAAAABAAAA HgAahgggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAALICAQOQBgAkAAAAAQAA AAsAG4YLIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAAbAIBA5AGACQAAAABAAAACwAchgsg BgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAByAgEDkAYAFAAAAAEAAAAeAD0AAQAAAAEAAAAA AAAAXgABA5AGAAwAAAABAAAAAwCAEP////+QBAEJAAQAAgAAAAAAAAABA5AGAAwAAAABAAAA CwAjAAAAAAAvAAEDkAYADAAAAAEAAAALACkAAAAAADUAAQSQBgD8AwAAAgAAABIAAAADAAAw BQAAAAsADw4AAAAAAgH/DwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAb3JhY2xl LWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAHgACMAEAAAAFAAAA U01UUAAAAAAeAAMwAQAAABUAAABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAAADABUMAQAAAAIB +Q8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABEG9yYWNsZS1sQGZhdGNpdHkuY29t AFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/g8GAAAAHgABMAEAAAAXAAAAJ29yYWNs ZS1sQGZhdGNpdHkuY29tJwAAAgELMAEAAAAaAAAAU01UUDpPUkFDTEUtTEBGQVRDSVRZLkNP TQAAAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAFQAAAG9yYWNsZS1sQGZhdGNp dHkuY29tAAAAAAIB918BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNsZS1s QGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/V8BAAAAAwD/XwAA AAACAfYPAQAAAAQAAAAAAAAFEgAAAAMAADAGAAAACwAPDgAAAAACAf8PAQAAAEUAAAAAAAAA gSsfpL6jEBmdbgDdAQ9UAgAAAQBha2VsbGVyQHNjdGNvcnAuY29tAFNNVFAAYWtlbGxlckBz Y3Rjb3JwLmNvbQAAAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAFAAAAGFrZWxsZXJA c2N0Y29ycC5jb20AAwAVDAIAAAACAfkPAQAAAEUAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAA ARBha2VsbGVyQHNjdGNvcnAuY29tAFNNVFAAYWtlbGxlckBzY3Rjb3JwLmNvbQAAAAADAP4P BgAAAB4AATABAAAAFgAAACdha2VsbGVyQHNjdGNvcnAuY29tJwAAAAIBCzABAAAAGQAAAFNN VFA6QUtFTExFUkBTQ1RDT1JQLkNPTQAAAAADAAA5AAAAAAsAQDoAAAAAAwBxOgAAAAAeAPZf AQAAABQAAABha2VsbGVyQHNjdGNvcnAuY29tAAIB918BAAAARQAAAAAAAACBKx+kvqMQGZ1u AN0BD1QCAAABAGFrZWxsZXJAc2N0Y29ycC5jb20AU01UUABha2VsbGVyQHNjdGNvcnAuY29t AAAAAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAAGFd4=