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= Received on Wed Jun 07 2000 - 20:20:09 CDT