Oracle database - Explain how to rename a database posted by
Babu Kunwar
Explain how to rename a database
To completely re-name a database you need to change all of the components where
the instance name is located:
External files: sqlnet.ora, tnsnames.ora, init.ora (spfile)
Internal locations: Data dictionary.
Follow the steps to rename the database as described:
-
On the old system sign on as SYSDBA into SQLPLUS and issue: “alter database
backup controlfile to trace”;
-
Shutdown the old database.
-
Change all references to the old instance name in all locations for sqlnet.ora,
protocol.ora, tnsnames.ora and the init.ora
-
Change the database name in the file to reference the new ORACLE_SID instance
name.
More links
Oracle constraints - overview. What are the types of constraints avaialable in
oracle
Explain Oracle "Check" constraint.
Explain Not Null constraint.
Explain primary key constraint.
Explain oracle foreign key constraint.
Explain unique Constraint.
Explain with an example how to alter oracle table constraint...........
|
