Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can't create database logged on as sysdba

In Oracle8i's PL/SQL, I run the following script:

-----------------
Connect system/manager as sysdba;
 
 Create Database DB2
 Controlfile Reuse
 Logfile 'C:WINDOWSDESKTOPDB2.log' Size 1M Reuse
 Datafile 'C:WINDOWSDESKTOPDB2.ora' Size 10M Reuse
 Autoextend on
 Next 10M Maxsize 200M;
 --------------
Why does the program say that I do not have the privilege? I can't create a new database? How can I create a new database?

SYSTEM does not have these privileges in order to be able to create your database. Instead, you'll have to "CONNECT INTERNAL" through Server Manager, or "CONNECT SYS/change_on_install AS SYSDBA". Then you will be able to issue the CREATE DATABASE command.

Only after the database has been created will you be able to grant SYSTEM the SYSDBA privileges. But by then, the database has been created, so why bother?

For More Information


Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close