| Importing and creating new users [message #110831] |
Thu, 10 March 2005 11:33  |
snagra
Messages: 23
Registered: March 2005
|
Junior Member |
|
|
I have to copy a development area to a test area
I've exported to file sales.dmp but need to import
I've done the following
I logged into SQLPLUS as system/manager
sqlplus>create user testsal identified by testsal
default tablespace saldata;
sqlplus> grant create session to testsal;
unix: imp testsal/testsal file=sales.dmp fromuser=testsls touser=testsal
it came up with
" "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SALDATA'
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "X_FATAG" ("CCN" VARCHAR2(6), "FA_ASSET_TAG_ID" VARCHAR2(20), "
""FA_ASSET_ID" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 "
"LOGGING STORAGE(INITIAL 32768 NEXT 16384 MINEXTENTS 1 MAXEXTENTS 121 PCTINC"
"REASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" "
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SALDATA'
Import terminated successfully with warnings.
$
I assume I haven't created the user correctly. Could someone enlighten me to what I should have done please.
Sati
|
|
|
|
| Re: Importing and creating new users [message #110858 is a reply to message #110831] |
Thu, 10 March 2005 13:35  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>imp testsal/testsal file=sales.dmp fromuser=testsls touser=testsal
The above statement assumes that,
user TESTSAL has already have an default tablespace assigned with unlimited / limited quota on the that tablespace.
All you have to do is
sql> alter user testsal default tablespace < some_tablespace >;
sql> alter user testsal quota unlimited on < some_tablepsace >;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
