Oracle Database Discussions

Hi all,

I have downloaded oracle9i database release 2 Enterprise/standard/personal edition for windows. so I got the them into 3 different folders as said in the oracle site. I have few questions.

1.i have installed oracle using the universal installer, but my operating system is winxp german version.I want the installer to be in english so that i can easily navigate, how can i set the language. Does the installer automatically detects the OS and chosses the language.

2. I have 2 sql scripts. One with Schema(tables for database with create statements) and other file with data(insert statements).That is Schema.sql, data.sql. How can i use these scripts for querying using the installed database.

3. I am totally confused with SID, how to set it and what does it indicate(functionality).

4. The login for SQL PlUS, i used scott and tiger. Because i think the installer did not installled completely, i could not create my own username/password. What will be the host-string while logging to sqlplus.

Thanks and Regards
Babu.