Oracle Database Discussions

Hi All,

I am doing export and import through OS Authentincation ID OPS$ORACLE.

I have granted DBA,EXP_FULL_DATABASE,IMP_FULL_DATABASE roles to OPS$ORACLE.

I am doing export as follows:-

exp / file=TablesDataBkp.dmp log=TablesDataBkp_Exp.log
tables=(ODM.ODM_PMML_DTD,PM.ONLINE_MEDIA,PM.PRINT_MEDIA,SYS.EXTERNAL_TAB$,SYS.METASTYLESHEET) compress=n ROWS=Y

Exported termiated successfully as follows:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
Current user changed to ODM
. . exporting table ODM_PMML_DTD 2 rows exported
Current user changed to PM
. . exporting table ONLINE_MEDIA 9 rows exported
. . exporting table PRINT_MEDIA
EXP-00062: invalid source statements for an object type
Current user changed to SYS
. . exporting table EXTERNAL_TAB$ 0 rows exported
. . exporting table METASTYLESHEET 0 rows exported
Export terminated successfully with warnings.

When trying to execute the import

imp / file=TablesDataBkp.dmp log=TablesDataBkp_Imp.log full=Y ROWS=Y IGNORE=Y

Its throwing the below errors


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing OPS$ORACLE's objects into OPS$ORACLE
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "EXTERNAL_TAB$" ("OBJ#" NUMBER NOT NULL ENABLE, "DEFAULT_DIR" "
"VARCHAR2(30) NOT NULL ENABLE, "TYPE$" VARCHAR2(30) NOT NULL ENABLE, "NR_LOC"
"ATIONS" NUMBER NOT NULL ENABLE, "REJECT_LIMIT" NUMBER NOT NULL ENABLE, "PAR"
"_TYPE" NUMBER NOT NULL ENABLE, "PARAM_CLOB" CLOB, "PARAM_BLOB" BLOB) PCTFR"
"EE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 "
"FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("PARAM_CLOB""
") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSIO"
"N 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)) LOB ("P"
"ARAM_BLOB") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192"
" PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1"
"))"
IMP-00003: ORACLE error 1031 encountered ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "METASTYLESHEET" ("NAME" VARCHAR2(30) NOT NULL ENABLE, "MODEL""
" VARCHAR2(30) NOT NULL ENABLE, "STYLESHEET" CLOB) PCTFREE 10 PCTUSED 40 IN"
"ITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
"TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("STYLESHEET") STORE AS (TABLES"
"PACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORA"
"GE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1))"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
. importing ODM's objects into ODM
. . importing table "ODM_PMML_DTD" 2 rows imported
. importing PM's objects into PM
. . importing table "ONLINE_MEDIA" 9 rows imported
IMP-00009: abnormal end of export file
Import terminated successfully with warnings.

Can any body have idea on this?

Note:- I am doing all this as part of Character Set Migration

Thanks,
Sankar