Incapable of creating temporary table in oracle sql

Question

I am beginner to SQL (also using oracle). I am having a problem which I find mind-boggling since what I want to do is so simple.

In short, I want to make a join on two tables from different databases. I do not have admin privileges so I cannot create a view.

I dumped as .csv the table I wanted to join to, and am trying to load it in the other database connection. All my attempts at creating a new table have been met with "insufficient privileges" error.

I have tried

"Import data"
CREATE GLOBAL TEMPORARY TABLE
CREATE TEMPORARY TABLESPACE

How can I create a table or import data when I do not have admin privileges?

edit: I cannot create a view.

solved: I had basically no privileges on my account (not even on my own schema). Talked to the admin and got the right privileges

If you don't have the privileges to create a table, then you cant. Either ask for more privileges, or do a join without creating an intermediate table. — Mat
– Mat, Commented Nov 25, 2013 at 19:27
The tables I want to join are from different database connections though. — eloaf
– eloaf, Commented Nov 25, 2013 at 19:29
You don't need "admin" privileges (maybe you mean sys), but you do need create table rights. Ask your DBA to create your own schema that you can control. And also have them setup a database link so you can query both tables from one DB. — OldProgrammer
– OldProgrammer, Commented Nov 25, 2013 at 19:29
If you can create a database link, that would be another option. — Jeffrey Kemp
– Jeffrey Kemp, Commented Nov 26, 2013 at 3:48

Balazs Papp · Accepted Answer · 2013-11-25 19:31:19Z

3

In order to create a table, you need:

the CREATE TABLE privilege granted to your user
quota defined on the tablespace where you want to create the table (or the UNLIMITED TABLESPACE privilege, which gives you unlimited quota on all tablespaces, but using this is bad practice)

If any of the above missing, you get the insufficient privileges error.

PS: to create a view, you dont have to be an admin, you just need the CREATE VIEW privilege granted to your user

answered Nov 25, 2013 at 19:31

Balazs Papp

5262 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

eloaf Over a year ago

If I cannot create a view, is there any way I can join from the two databases?

Collectives™ on Stack Overflow

Incapable of creating temporary table in oracle sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related