Toad World® Forums

Question 02: Having troubles with importing CSV (or Excel) into Toad

I have been getting this error message after I tried to import CSV into Toad:

Failed inserting row 0 : ORA-01950: no privileges on tablespace 'DEVELOPMENT'

Any help is much appreciated.


You have to contact your DBA and get the correct privileges .
CREATE - the ability to create new tables or databases
DROP - the ability to them to delete tables or databases
DELETE - the ability to delete rows from tables
INSERT - the ability to insert rows into tables
SELECT - the ability to use the SELECT command to read through databases
UPDATE - the ability to update table rows