You are required to export an existing database only if you intend to copy its contents to a new database. You will then delete starter database orcl. You will copy orcl to a new database with a database name and SID of prod located in directory C:\app\ username \product\11.2.0\oradata\prod. In this example, the existing database is the starter database with a SID of orcl located in directory C:\app\ username \product\11.2.0\oradata\orcl. We use an example in the following sections to demonstrate how to create a database. Yes if you import tables and other objects exported from the existing database not otherwise. Yes if you copy data from the existing database to the new database no otherwise. Putting the CREATE DATABASE Statement in a Script Modifying the Initialization Parameter FileĬreating and Starting an Oracle Database Service Table 3-1 Manual Database Creation Tasks TaskĬopy existing database and delete old databaseĬopy existing database and keep old databaseĬreate new database when no database exists on system The Server Parameter File file name is spfile SID. The location of the newly-created Server Parameter File is ORACLE_HOME \database.
You cannot change the Server Parameter File itself, because it is a binary file that cannot be browsed or edited using a text editor. If you want to modify an instance created with Database Configuration Assistant after it starts, you must use ALTER SYSTEM statements. Oracle does not recognize the renamed file as an initialization parameter file, and it is not used after the instance is started. When you create a database using Database Configuration Assistant, a server parameter file (SPFILE) is created from the initialization parameter file, and the initialization parameter file is renamed. Use this file to create and modify a database using command-line tools. See Also: Oracle Database 2 Day DBA for instructions on using Database Configuration Assistantĭatabase Configuration Assistant enables you to:Īn initialization parameter file is an ASCII text file containing parameters.
0 kommentar(er)
