Home » RDBMS Server » Server Administration » building databases fast
building databases fast [message #53328] Thu, 12 September 2002 10:35 Go to next message
Kim Carlsen
Messages: 13
Registered: September 2002
Junior Member
Hi

How do I create a database fast on a windows platform?
I need to make a fast scripted installation of a database for using at customers and testenvironments.
Because IŽve need to change the SID and the database is not empty, I think of using raw datafiles with Oradim and then extend the tables. What do you think about that? is it posible or is there a smarter way to do it?

TNX

Kim

Report message to a moderator

Re: building databases fast [message #53331 is a reply to message #53328] Thu, 12 September 2002 12:05 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
although these are Unix implementations - take a look at them:
http://www.oracle.com/oramag/oracle/00-Mar/o20dba.html
http://www.akadia.com/services/fulldb_exp_imp.html

For an easy GUI approach - run dbassist

Report message to a moderator

Re: building databases fast [message #53336 is a reply to message #53328] Thu, 12 September 2002 22:54 Go to previous message
Kim Carlsen
Messages: 13
Registered: September 2002
Junior Member
Hi
TNX but its to slow to do an import, because IŽll need an instance first and with Intermedia it takes a lot of time on Win platforms.
How do Oracle create the database from CD-rom in their Database Conf. assistant? its damn fast!

TNX.
Kim

Report message to a moderator

Previous Topic: SQL*PLUS Not Working
Next Topic: Oracle 8i installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 12:05:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.