IMP-00032, IMP-00008 error

itpremier發表於2011-03-27

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.'
....

resolve: add parameter buffer=10485760 .

imp system/system file=hldata_0327.dmp fromuser=hldata statistics=none buffer=10485760 ignore=y

[@more@]

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning and OLAP options

Export file created by EXPORT:V11.02.00 via direct path
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
. importing HLDATA's objects into HLDATA
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-00008: unrecognized statement in the export file:
'The table stores the target-metric to collection task association.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table contains details of the default collections set up for
a target type.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Table to hold the metrics associated with a collection item'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
' The target guid of the last violation.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
' The policy rule guid of the last violation.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The MGMT_METRICS table provides metric descriptions for a given target
name and target type. This table is primarily used to make the standard
reports more understandable.
The content of the MGMT_METRICS table is close to what you will find i...
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the list of versions for which the repository metric
is supported.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table provides the policy rule description.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the policy to target/template associations.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the configuration for a key value of
target/template policy associations.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the parameter threshold values for a key
configuration of target/template policy associations.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the detailed policy evaluation state.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The target for which the evaluation status is stored.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The policy guid for which the evaluation status is stored.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The collection name for which the evaluation status is stored.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The key value for which the evaluation status is stored.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The number of successive times the policy evaluation has trigger to
an info or higher violation level for the target-policy-key_value
combination'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the policy evaluation summary details for a target.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the list of bind variables to be used to evaluate
the condition.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table defines policy violation context definition for all policies.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table holds the details of till what time the rollup can
happen and up to what time the rollup has already been done.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This table stores the snapshot to metric map.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The MGMT_TARGET_TYPE_VERSIONS table holds the list of target type versions'
IMP-00015: following statement failed because the object already exists:
"CREATE TABLE "TM_MENU" ("MENU_ID" NUMBER(10, 0) NOT NULL ENABLE, "MENU_NAME"
"" VARCHAR2(200) NOT NULL ENABLE, "MENU_TITLE" VARCHAR2(200) NOT NULL ENABLE"
", "LOCATION" VARCHAR2(400), "DESCRIPTION" VARCHAR2(400), "DISPLAY_ORDER" NU"
"MBER(10, 0), "TARGET" VARCHAR2(200), "PARENT_MENU_ID" NUMBER(10, 0), "MENU_"
"LEVEL" NUMBER(10, 0), "APP_ID" NUMBER(10, 0), "FOR_WORKBENCH" VARCHAR2(20),"
" "IMGPATH" VARCHAR2(200)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 ST"
"ORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1"
" BUFFER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The MGMT_SEVERITY view contains the severity information.
Severities are alerts that inform the user when a metric threshold
Test or a policy violation has failed.'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'the advisory which is applicable to the home'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'The column mgmt$software_dependencies.dependency_type has been deprecated'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view gives DBA access to shared workload'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view gives DBA access to summary recommendations'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view gives DBA access to summary evaluation output'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'This view gives DBA access to dimension validation results'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'Identifies two applications using APEX_APPLICATION_1 and APEX_APPLICATION_2 session date, APEX_COMPONENT must be 0 (all), or the name of an APEX component'
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
'snapshot table for snapshot SYSMAN.MGMT_ECM_MD_ALL_TBL_COLUMNS'
Import terminated successfully with warnings.

imp system/system file=hldata_0327.dmp fromuser=hldata statistics=none buffer=10485760 ignore=y

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/350519/viewspace-1047787/,如需轉載,請註明出處,否則將追究法律責任。

相關文章