| Error using IMP (importing a schema) [message #300655] |
Sun, 17 February 2008 09:04  |
oraclewannabe
Messages: 26
Registered: January 2008
|
Junior Member |
|
|
hello guys
i have a xxx.exp export file which contain 'abc' schema from a friend using another system running oracle9i.
now i have install oracle9i with a default database(one with scott/tiger) already.
1) i have login as system/manager and create a user with the name 'abc'. Granted connect role to it.
2) Then i go to command prompt and i type the following command
imp system/xxxxxx file=c:\xxx\xxx.exp fromuser=abc touser=abc
3) then as the table started to import, i have got this error coming out
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "PROVIDER_AREA" ("blarblarblar....")) PCTFREE 10 PCTUSED 40 INITRANS 1"
" MAXTRANS 255 STORAGE(INITIAL 598016 FREELISTS 1 FREELIST GROUPS 1)"
"LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SYSTEM'
any advice gurus ??
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
