Re: Takes hours to create a New Database

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:GkCDc.162082$3x.134974_at_attbi_s54...
>
> "Oracle Newbie" <f93c0532_at_yahoo.com> wrote in message
> news:2k89cuF17jgvgU1_at_uni-berlin.de...
> > I've installed Oracle9i Database on my Windows XP running on AMD K6 500
> (192
> > MB RAM )
> > With the Database configuration assistant I created a General Purpose
> > database which was done in about 15 minutes. But when I tried to create
a
> > 'New Database' it took at least 2 hrs to get to 4th of the following
steps
> > and only 26% showing in the progress bar. Does it really take this long?
> > There must be someting wrong with it.
> > I stopped it, then killed it using task manager.
> >
> > Creating and Starting Oracle Instance
> > Creating Database Files
> > Creating data dictionary views
> > Adding Oracle JVM
> > Adding Oracle Intermedia
> > Adding Oracle Text
> > .....
> >
> >
> >
> >
> It can. Depends how fast your disk drives are. It is creating one from
> scratch instead of recovering the one it ships with. You probably do not
> have to create multiple databases.

 > You probably really want a different
> schema. (In SQL Server one thinks of creating databases, in Oracle one
> thinks of creating schemas.) A schema is a group of tables etc. owned by
a
> particular owner. So it takes as long to create that as it does to create
a
> user and whatever tables and database objects you want for that user.
(Which
> is probably not that long)
> Jim
>

Thx. So what's the efficient way to create a new schema? Suppose I want to create a schema with 3 tables ( customers, orders, payments ) Received on Sun Jun 27 2004 - 11:25:10 CDT