Home » SQL & PL/SQL » Client Tools » insufficient privileges error while using copy command (Oracle 10.2.0.4.0,SunOS)
insufficient privileges error while using copy command [message #554175] Fri, 11 May 2012 02:37 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

When i try to copy a table within the database i get insufficient priv error.

SQL> COPY FROM JACK@JACK -
> CREATE T -
> USING SELECT * FROM JACK.T;
Enter FROM password:

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA-01031: insufficient privileges


Can somebody tell me what privilege is required to perform this copy command ?

Regards,
Jack
Re: insufficient privileges error while using copy command [message #554176 is a reply to message #554175] Fri, 11 May 2012 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65955
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE DATABASE LINK or SELECT on the remote table or CREATE TABLE on the local one, I think but I do not use this command as it is depreciated since the last century and you should do the same.

Regards
Michel

[Updated on: Fri, 11 May 2012 02:47]

Report message to a moderator

Re: insufficient privileges error while using copy command [message #554199 is a reply to message #554176] Fri, 11 May 2012 05:24 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you michel for the answers.
Previous Topic: limit of max pool size.
Next Topic: SQL for saving the query result in a txt file (2 Merged)
Goto Forum:
  


Current Time: Wed Nov 14 08:12:51 CST 2018