sqlplus '/as sysdba' tool to show current database name with login as sysdba
To display database name.
select ora_database_name from dual;
select * from v$database;
To check the name for each database.
if you're on unix, go to $ORACLE_HOME directory, then into dbs directory there'll be a file there for each SID (database) with a file name initTHE_SPECIFIC_SID_NAME.ora there'll be one entry for each SID/database (if it's not specified as * = ALL) in /etc/oratab.
On windows, go to oracle insallation directory,
then database directory...there'll be a initSID_NAME.ora for each SID/database.
There'll be a windows service for each SID, with a name like oracleserviceSID_NAME.
To create user oracle
create user superuser identified by supseruser;
To allow super user to create table.
grant dba to superuser;
we can do edit in sqlplus to edit SQL by type "edit".
To see the structure of the table.
desc <table_name>
To display database name.
select ora_database_name from dual;
select * from v$database;
To check the name for each database.
if you're on unix, go to $ORACLE_HOME directory, then into dbs directory there'll be a file there for each SID (database) with a file name initTHE_SPECIFIC_SID_NAME.ora there'll be one entry for each SID/database (if it's not specified as * = ALL) in /etc/oratab.
On windows, go to oracle insallation directory,
then database directory...there'll be a initSID_NAME.ora for each SID/database.
There'll be a windows service for each SID, with a name like oracleserviceSID_NAME.
To create user oracle
create user superuser identified by supseruser;
To allow super user to create table.
grant dba to superuser;
we can do edit in sqlplus to edit SQL by type "edit".
To see the structure of the table.
desc <table_name>
ไม่มีความคิดเห็น:
แสดงความคิดเห็น