Q

How to run .sql files in Oracle8i?

I have Oracle8i installed on Windows XP. I want to run .sql files on my server and learn to create an instance. How do I get started?

Hello! I have Oracle8i installed on Windows XP. I am new to the database world. Am I supposed to have Oracle Enterprise Manager along with the server SQL*Plus? I can't find it out. I just want to run .sql files on my server and learn to create an instance. Can you please help me out? Thanks in advance!
First, Oracle8i is not supported, nor certified, for the Windows XP operating system. You must install Oracle 9.2 or higher. Refer to the Oracle Certification Matrix for more information.

Second, before you can run SQL commands you must have a database, so you will either have to create one or connect

to an existing database. If you want to learn to create a database instance, the easiest way is to use the Database Configuration Assistant (DBCA). This is installed by default when you install the Oracle software. The DBCA will ask you questions about the database you would like created, and then it will create the database for you. You can then use SQL*Plus or Oracle Enterprise Manager to connect to the database and run SQL commands against it.

A good place to start is to read the Oracle9i Release 2 (9.2) Database Concepts guide. Note that you will need to create an account on Oracle's Technology Web site before you can review the documentation (registration on OTN is free). If you are installing Oracle 10g, the 10g documentation is located here

I would then suggest reviewing the "Creating an Oracle Database" section in the Oracle9i Release 2 (9.2) Database Administrator's Guide.

Once your database is created, you can then connect to the database and learn all about SQL commands.

This was first published in February 2007

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close