Questions about cloning an instance

Hello,

I am setting up a test server which need to mimic a production oracle 8i database.

From a highlevel perspective I believe I have to

1. Create the instance with an init.ora similar to the production (differences for SGA settings only?)
2. Create a script to recreate the users and tablespaces? Tablespace can be the same, but the test box only has one disk, so Datafile locations will be different.
3. Full Export from Production and import to Test.

Am I missing anything? Any suggestions would be appreciated.

-greg

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Mar 27 2001 - 15:27:19 CST