Re: Oracle Basics

Hi there,

1. yes its ok to user sql Loader to migrate data from another medium.
2. If you custom install then you can setup your own settings for things like the oracle home, tablespaces, and other important configurations. but you dont have to.

Howard J. Rogers <howardjr_at_www.com> wrote in message news:394091ee_at_news.iprimus.com.au...
>
> "Christy" <kisstene_at_hotmail.com> wrote in message
> news:8hmjfm$2286$6_at_newssvr04-int.news.prodigy.com...
> >
> > Hi i'm a rookie so bare with me while I request help. Please help!
> >
> > 1. When migrating data from 1 medium (SQL Server) to Oracle, is it ok
 to
> > use SQL LOader, or are there other 3 party softwares that are better for
 the
> > project?
> >
> > 2. On a fresh install of Oracle for a production environment, is it ok
 to
> > accept the default install, or are there any special configurations i
 should
> > be aware of?
> >
>
> Incidentally, the default install for Oracle 8.0.5 and before will give
 you
> 2K blocks. This is a ridiculous default. 8i's not much better with its
 8K
> default. Depending on your operating system, you really ought to be
 looking
> at 16K block sizes.
>
> You also appreciate, I hope, that the default install will result in a
> database which is NOT operating in archivelog mode. Fine if you don't
 care
> about recovering it, but not otherwise!
>
> As with all defaults, be wary: the shared pool size is prerhaps the
 biggest
> single determinant of system performance, and when you do the install you
> get a highly detailed choice betwen 'small', 'medium' and 'large'! By all
> means take the default install as a basis from which to tune onwards and
> upwards, but don't fall into the trap of thinking that it is necessarily
> appropriate to your particular needs.
>
> HJR
>
>
> > 3. When upgrading oracle, is there any special configurations i should
 also
> > know - would it be to load data via export/import- or is there a better
 way?
> >
> > 4. Please help me with some basic concepts:
> > imaging
> > meta data repositories
> > SQL back track control
> >
> > Thanks a billion for your inplut.
> > Christy
> >
> >
>
>
Received on Mon Jun 12 2000 - 00:00:00 CDT