Re: migration SQL Server 7.0 To Oracle 9i

peter wrote:
> Hello DBAs,
>
> Please Inform how to migration SQL Server 7.0 to Oracle 9i.
>
> Thank You

1. Read Tom Kyte's books. Both the one mentioned by hpuxrac and also his "Expert one-on-one Oracle."
2. Bookmark http://tahiti.oracle.com and read the concepts and architecture docs. Oracle is NOT SQL Server and the differences are considerable. Even such basic terms as database, instance, and cluster have totally different meanings.
3. How much data? How long do you have to migrate it? How many schemas? How will it be logically and physically backed up and recovered? Just data or also views? functions? procedures? triggers?

Do the tables have identity columns with autonumbering? They do not exist in Oracle. Look up sequences and BEFORE-INSERT triggers in Morgan's Library at www.psoug.org.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org