![sql prompt 7 sql prompt 7](https://azuredevopslabs.com/labs/tfs/sqlprompt/images/image7.png)
>Prevoiusly I was trying to create in SYSTEM and I was logged in through SYSTEM usr name. Date: Thu, 14:03:40 GMT >Hi, >I have checked with change I m getting the same error.
Sql prompt 7 how to#
“satyam_Ora via oracle-db-l” Reply-To: To: mudassar_14 Subject: RE: How to create database on sql prompt. mudassar farooq database administrator lahore PAKISTAN. If you are not the intended recipient you may not copy or deliver this me ssage to anyone.”Īll ready mounted mean, your previous installation is running first shut it down with the help of shutdown immediate then try to create it with user sys thanks The information contained in this message and its attachments may be conf idential or privileged and is for the use of the named recipient only, ex cept where the sender specifically states otherwise.
![sql prompt 7 sql prompt 7](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/26e2000093ebd5432a42.jpg)
No employee of the PGWC is entitled to conclude a binding contract on beh alf of the PGWC unless he/she is an accounting officer of the PGWC, or hi s or her authorised representative. “All views or opinions expressed in this electronic message and its attac hments are the view of the sender and do not necessarily reflect the view s and opinions of the Provincial Government of the Western Cape (“the PGW C’). Please reply me ASAP as I am in immediate need of this solution. I know how to create database using DBCA so please suggest me only for ma naually. Please suggest me how can I do no mounted database else what steps I need to follow to create new database using sql prompt.
Sql prompt 7 password#
But I am getting f ollowing errors: SQL> create database ss user ‘system’ password ‘HiDear123’ create database ss user ‘system’ password ‘password’ * ERROR at line 1: ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted I am trying to create database manually on sql prompt. Why not create your tables within tables have columns then you do your co nstraints ,sequences,triggers etc.