Re: migrating from sql server 2000 to oracle 9i-r2

gaddoz wrote:

> Hi all,
> i'm new to oracle,
> and i'm looking for migrating a sql server db to oracle.
> Any suggestion?
> Thank you
>
> Gaddoz

Tom Kyte's book "Expert one-on-one Oracle" ... don't let anything in the first three chapters escape your attention.

Then forget just about everything you think you know about SQL and relational databases because Oracle concepts and architecture are totally unlike SQL Server and spend time at http://tahiti.oracle.com reading the concepts docs.

In Oracle:

1. Reads don't block writes
2. Writes don't block reads
3. Never create or drop tables in stored procs
4. Unlimited locks and no lock escallation
5. Unlimited log file transaction size
6. No need for incremental commits
7. NULL means NULL not an empty string
8. Boolean means Boolean not 0 and -1
9. No autonumbering for many very good reasons

And much much more. Welcome to the party.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)