error with tablespace using imp
533056Oct 2 2006 — edited Oct 2 2006I am getting an error when my "imp" command is trying to create the tablespaces. Looks like it creates everything else (procs, pkgs, etc...) This is the syntax of my import command:
imp safetyuser/underdog@orcl fromuser=safetyuser touser=safetyuser file=d:\oracle_backup\safety_exp.dmp log=d:\oracle_backup\saf_exp.log ignore=Y
This is the error message:
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SYSAUX'
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "TBL_875A_OLD" ("ID875A_OLD" NUMBER, "SAFETYSUBJECTNAME" VARCH"
"AR2(500), "EDATE" DATE, "ODATE" DATE, "CUID" VARCHAR2(7), "MCUID" VARCHAR2("
"7), "MNAME" VARCHAR2(50), "ESTA" VARCHAR2(3)) PCTFREE 10 PCTUSED 0 INITRAN"
"S 1 MAXTRANS 255 STORAGE(INITIAL 5242880 FREELISTS 1 FREELIST GROUPS 1 BUFF"
"ER_POOL DEFAULT) LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SYSAUX'
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "TBL_875B_OLD" ("OBSID_875B" NUMBER(*,0), "OBSERVATION" VARCHA"
"R2(600), "ACTION" VARCHAR2(600), "CUID" VARCHAR2(7), "MCUID" VARCHAR2(7), ""
"EDATE" DATE, "OBSDATE" DATE, "OKDEV" NUMBER(*,0), "DEV" NUMBER(*,0), "STA" "
"VARCHAR2(3)) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL "
"104857600 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING NOCOMPRESS"
Please help.