- #ORACLE 10G DEFAULT DATABASE NAME HOW TO#
- #ORACLE 10G DEFAULT DATABASE NAME MANUAL#
- #ORACLE 10G DEFAULT DATABASE NAME FULL#
All messages from Export are logged in file myexp.log.īeginning with Oracle9 i Release 2 (9.2), nesting of quotation marks using the backslash (\) escape character is no longer supported.
#ORACLE 10G DEFAULT DATABASE NAME FULL#
You now have a full database export of starter database orcl in file myexp.dmp.
If the existing database is before Oracle Database 10 g Release 1 (10.1), then start Export from the command prompt:Ĭ:\> exp SYSTEM FILE=myexp.dmp FULL=y LOG=myexp.log All messages from Data Pump Export are logged in file myexp.log. If the existing database is Oracle Database 10 g Release 1 (10.1) or later, then start Data Pump Export from the command prompt:Ĭ:\> expdp SYSTEM DUMPFILE=myexp.dmp FULL=y LOG=myexp.log
Note that there are no spaces around the equal sign ( =) character. For example, if the database you intend to export is starter database orcl, then enter the following at the command prompt. Set ORACLE_SID to the database service of the database whose contents you intend to export. To export all data from an existing database to a new database: See Also: Oracle Database Utilities for more information on using Data Pump Export or Export The syntax for Data Pump Export interactive mode is: C:\> expdp SYSTEMĮnter only the command expdp SYSTEM to begin an interactive session and let Data Pump Export prompt you for information it needs. The syntax for Data Pump Export parameter mode is: C:\> expdp SYSTEM DUMPFILE=myexp.dmp FULL=y LOGFILE=myexp.log Interactive mode provides less functionality than parameter mode and exists for backward compatibility only. If you are using Oracle Database 10 g Release 1 (10.1) or later data, then Oracle recommends that you use Data Pump Export because it supports new Oracle Database 10 g Release 1 (10.1) or later features, such as floating points.Īlthough you can start Data Pump Export or Export in either parameter mode or interactive mode, Oracle recommends parameter mode. If you are working with data from an earlier Oracle release, then you can use Export for this task. 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.
#ORACLE 10G DEFAULT DATABASE NAME HOW TO#
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
#ORACLE 10G DEFAULT DATABASE NAME MANUAL#
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.