Oracle数据库原理与结构培训胶片详解.ppt

* Command Line Export You can copy database data to an operating system file by using the command line mode of the Export utility. This file is only readable by the Import utility. Example Create an export file named exp1.dmp that includes the tables EMPLOYEES and DEPARTMENTS from HR schema including rows: $ exp hr/hr tables=(employees,departments) rows=y file=exp1.dmp Create a fast export file named expdat.dmp that includes all objects for HR schema: $ exp system/manager owner=hr direct=y If file is not specified, the default export file name is expdat.dmp. Create an export file named expdat.dmp that includes all definitions of objects belonging to the tablespace ts_employees and generate a log file named ts_employees.log: $ exp system/manager TRANSPORT_TABLESPACE=y TABLESPACES=(ts_employees) LOG=ts_employees.log Create an export file named expcum1.dmp that includes all definitions and data modified in the database since the last cumulative or complete export. $ exp system/manager FULL=y INCTYPE=cumulative FILE=expcum1.dmp * Examples Import into HR schema, the tables EMPLOYEES and DEPARTMENTS, including rows, by using the Export file named exp1.dmp. $ imp hr/hr tables=(employees,departments) rows=y \ file=exp1.dmp Import all objects belonging to the HR schema, including rows, by using the export file named exp2.dmp. $ imp system/manager FROMUSER=hr file=exp2.dmp Import all definitions of objects belonging to the tablespace ts_employees, by using the export file named expdat.dmp. $ imp system/manager TRANSPORT_TABLESPACE=y TABLESPACES=ts_employees If the file parameter is not specified, Import looks for the default file; expdat.dmp. Note: Command-line mode options are similar to interactive mode options but offer more functionality. * * Practice 7: Maintaining Redo Log Files 1 List the number and location of existing log files and display the number of redo log file groups and members your database has. Hints: - Query the dynamic view V$LOGFILE. - Use