Geek asks and answers

How to import data into a specified tablespace

My version of the oracle is 11g. I imported my oracle database into an SQL file called " export.sql ". Two days later, I installed my windows machine again and installed Oracle again. Now I created a user named "book" with the password "book" and gave privileges with this command:

grant create session, create table to book;

Then I tried to import the SQL file using the SQL Developer utility by opening the export.sql file in the SQL editor. Then he showed me that

SQL Error: ORA-01950: no privileges on tablespace 'USERS'

Then I thought that it would be better to create another tablespace rather than using the USERS tablespace. Then I created the "kwa" tablespace using this:

create tablespace kwa
logging
datafile 'G:\kwa\kwa.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m
extent management local;

, :

alter user book quota 32m on kwa;

, "" SQL Developer, " export.sql"?, , , < ORA-01950. "" SQLDeveloper?

+2
1

alter user book default tablespace kwa;

, , export.sql USERS - , export.sql!

+4

More articles:


All Articles