The following is a detailed analysis of the actual operations of the Oracle database installation and configuration process, including how to use the Oracle Database Configuration assistant to create a database and how to create a user, how to export all objects and table data in an Oracle database.
1. Use the Database Configuration assistant to create a database
1. Create a database
2. Select the template [Transaction Management]
3. database information [Global Database Name | SID [SALEDB]
4. database connection options [dedicated server mode]
5. initialization parameters
6. database storage
7. Create option [Create Database]
2. Create a user
Log on to the PL/SQL developer tool to activate SQL plus and run the SQL statement.
1. CREATE a USER [create user saleuser [USER name] identified by saleuser [Password] default tablespace users temporary tablespace temp quota umlimited on users]
2. authorize [grant dbac to saleuser [user name]
Iii. Export all objects and table data of the Oracle database
D: \ Oracle \ ORA92 \ BIN> [exp saleuser [user name]/SALEUSER [Password] @ Oracle_SERVER_SALE [Oracle service name] FILE = D: \ SALEDB. dmp owner = (SALEUSER [user name])]
4. Import all objects and table data of the Oracle database
D: \ Oracle \ ORA92 \ BIN> [imp saleuser [user name]/SALEUSER [Password] @ Oracle_SERVER_SALE [Oracle service name] FILE = D: \ SALEDB. dmp full = Y]
5. Basic import and export functions provided by PL/SQL DEVELOPER are as follows:
1. Export all database objects to the SQL File
2. There is no function procedure option to export the selected table to the DMP file)
3. There is no function procedure option to import the DMP file to the database)
6. Configure the service name
Start | Oracle | ORA HOME92 | configuration and migration tools | net manager | Oracle net configuration | Local | service name
7. Install the Oracle database
Oracle 9I has three disks, A \ B \ C. After mounting disk A | disk B, you must manually select disk B | disk C. During the installation process, select the default value. You only need to manually enter Step 1 [Database ID | global Oracle Database Name | SID] And enter ORCL. If the Oracle instance [database] exists, you can use ORCL2 or other names. After installation, you must set the database configuration assistant. Set the SYS password to SYS and the SYSTEM password to SYSTEM.