Oracle数备份还原.docVIP

Oracle数据导入 1、创建用户和表空间 打开EM 使用sys用户登录 创建表空间govdba 创建临时表空间govdba_temp 添加govdba用户 授权govdba用户为dba 验证govdba用户 2、数据导入 以oracle用户登陆系统，使用命令imp导入数据 [oracle@station1 ~]$ imp Import: Release 11.2.0.1.0 - Production on Tue Sep 27 23:48:11 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: govdba Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Import data only (yes/no): no Import file: expdat.dmp /home/oracle/2011.09.27.dmp Enter insert buffer size (minimum is 8192) 30720 Export file created by EXPORT:V11.02.00 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) List contents of import file only (yes/no): no Ignore create error due to object existence (yes/no): no Import grants (yes/no): yes Import table data (yes/no): yes Import entire export file (yes/no): no Username: govdba Enter table(T) or partition(T:P) names. Null list means all tables for user Enter table(T) or partition(T:P) name or . if done: . importing GOVDBAs objects into GOVDBA IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: This table defines the category names available for a metric class. IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: This table provides information about what category is applicable for a given metric/policy guid and metric class. The same table is used to define mappings for both metrics and policies. IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized statement in the export file: This table contains details of the collections set up for a metric. IMP-00032: SQL statement exceeded buffer length IMP