Database Software

Hi,

I was trying to export hr schema from 9i using exp utility, by the following command...

exp hr/old file=c:\expimp\exp.dmp log=exp.log rows=yes

It went fine,,, and a dump file was created..
Now I wanted to import in 10g , I have set the path as well as home for 10g....
I created a new user by name hr with password demo, with tablespace and quota
and run the below command...

imp hr/demo file=c:\expimp\exp.dmp fromuser=hr touser=hr log=c:\expimp\imphr.log

What is missing, I have to give some privildges or anything else...
IT is giving below error messages....

C:\Documents and Settings>imp hr/demo file=c:\expimp\hr.dmp fromuser=hr
touser=hr log=c:\expimp\imphr.log

Import: Release 10.2.0.1.0 - Production on Wed Mar 14 12:18:25 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE SEQUENCE "DEPARTMENTS_SEQ" MINVALUE 1 MAXVALUE 9990 INCREMENT BY 10 "
"START WITH 280 NOCACHE NOORDER NOCYCLE"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE SEQUENCE "EMPLOYEES_SEQ" MINVALUE 1 MAXVALUE 99999999999999999999999"
"9999 INCREMENT BY 1 START WITH 207 NOCACHE NOORDER NOCYCLE"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE SEQUENCE "LOCATIONS_SEQ" MINVALUE 1 MAXVALUE 9900 INCREMENT BY 100 S"
"TART WITH 3300 NOCACHE NOORDER NOCYCLE"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "COUNTRIES" ("COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" N"
"OT NULL ENABLE, "COUNTRY_NAME" VARCHAR2(40), "REGION_ID" NUMBER, CONSTRAIN"
"T "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE ) ORGANIZATION INDEX "
" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREEL"
"IST GROUPS 1) LOGGING NOCOMPRESS PCTTHRESHOLD 50"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "DEPARTMENTS" ("DEPARTMENT_ID" NUMBER(4, 0), "DEPARTMENT_NAME""
" VARCHAR2(30) CONSTRAINT "DEPT_NAME_NN" NOT NULL ENABLE, "MANAGER_ID" NUMBE"
"R(6, 0), "LOCATION_ID" NUMBER(4, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXT"
"RANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "EMPLOYEES" ("EMPLOYEE_ID" NUMBER(6, 0), "FIRST_NAME" VARCHAR2"
"(20), "LAST_NAME" VARCHAR2(25) CONSTRAINT "EMP_LAST_NAME_NN" NOT NULL ENABL"
"E, "EMAIL" VARCHAR2(25) CONSTRAINT "EMP_EMAIL_NN" NOT NULL ENABLE, "PHONE_N"
"UMBER" VARCHAR2(20), "HIRE_DATE" DATE CONSTRAINT "EMP_HIRE_DATE_NN" NOT NUL"
"L ENABLE, "JOB_ID" VARCHAR2(10) CONSTRAINT "EMP_JOB_NN" NOT NULL ENABLE, "S"
"ALARY" NUMBER(8, 2), "COMMISSION_PCT" NUMBER(2, 2), "MANAGER_ID" NUMBER(6, "
"0), "DEPARTMENT_ID" NUMBER(4, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRAN"
"S 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "JOBS" ("JOB_ID" VARCHAR2(10), "JOB_TITLE" VARCHAR2(35) CONSTR"
"AINT "JOB_TITLE_NN" NOT NULL ENABLE, "MIN_SALARY" NUMBER(6, 0), "MAX_SALARY"
"" NUMBER(6, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INIT"
"IAL 65536 FREELISTS 1 FREELIST GROUPS 1) LOGGING NOCOM"
"PRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "JOB_HISTORY" ("EMPLOYEE_ID" NUMBER(6, 0) CONSTRAINT "JHIST_EM"
"PLOYEE_NN" NOT NULL ENABLE, "START_DATE" DATE CONSTRAINT "JHIST_START_DATE_"
"NN" NOT NULL ENABLE, "END_DATE" DATE CONSTRAINT "JHIST_END_DATE_NN" NOT NUL"
"L ENABLE, "JOB_ID" VARCHAR2(10) CONSTRAINT "JHIST_JOB_NN" NOT NULL ENABLE, "
""DEPARTMENT_ID" NUMBER(4, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25"
"5 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "LOCATIONS" ("LOCATION_ID" NUMBER(4, 0), "STREET_ADDRESS" VARC"
"HAR2(40), "POSTAL_CODE" VARCHAR2(12), "CITY" VARCHAR2(30) CONSTRAINT "LOC_C"
"ITY_NN" NOT NULL ENABLE, "STATE_PROVINCE" VARCHAR2(25), "COUNTRY_ID" CHAR(2"
")) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"
"ELISTS 1 FREELIST GROUPS 1) LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE TABLE "REGIONS" ("REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NU"
"LL ENABLE, "REGION_NAME" VARCHAR2(25)) PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
"XTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) "
" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE FORCE VIEW "HR"."EMP_DETAILS_VIEW" ("EM"
"PLOYEE_ID","JOB_ID","MANAGER_ID","DEPARTMENT_ID","LOCATION_ID","COUNTRY_ID""
","FIRST_NAME","LAST_NAME","SALARY","COMMISSION_PCT","DEPARTMENT_NAME","JOB_"
"TITLE","CITY","STATE_PROVINCE","COUNTRY_NAME","REGION_NAME") AS "
"SELECT"
" e.employee_id,"
" e.job_id,"
" e.manager_id,"
" e.department_id,"
" d.location_id,"
" l.country_id,"
" e.first_name,"
" e.last_name,"
" e.salary,"
" e.commission_pct,"
" d.department_name,"
" j.job_title,"
" l.city,"
" l.state_province,"
" c.country_name,"
" r.region_name"
"FROM"
" employees e,"
" departments d,"
" jobs j,"
" locations l,"
" countries c,"
" regions r"
"WHERE e.department_id = d.department_id"
" AND d.location_id = l.location_id"
" AND l.country_id = c.country_id"
" AND c.region_id = r.region_id"
" AND j.job_id = e.job_id"
"WITH READ ONLY"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE PROCEDURE add_job_history"
" ( p_emp_id job_history.employee_id%type"
" , p_start_date job_history.start_date%type"
" , p_end_date job_history.end_date%type"
" , p_job_id job_history.job_id%type"
" , p_department_id job_history.department_id%type"
" )"
"IS"
"BEGIN"
" INSERT INTO job_history (employee_id, start_date, end_date,"
" job_id, department_id)"
" VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);"
"END add_job_history;"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE PROCEDURE secure_dml"
"IS"
"BEGIN"
" IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'"
" OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN"
" RAISE_APPLICATION_ERROR (-20205,"
" 'You may only make changes during normal office hours');"
" END IF;"
"END secure_dml;"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "ADD_JOB_HISTORY" COMPILE REUSE SETTINGS TIMESTAMP '2002-05"
"-12:18:02:30'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object ADD_JOB_HISTORY does not exist
IMP-00017: following statement failed with ORACLE error 4043:
"ALTER PROCEDURE "SECURE_DML" COMPILE REUSE SETTINGS TIMESTAMP '2002-05-12:1"
"8:02:30'"
IMP-00003: ORACLE error 4043 encountered
ORA-04043: object SECURE_DML does not exist
Import terminated successfully with warnings.