OraFAQ Forum: Client Tools » insufficient privileges error while using copy command

Home » Other » Client Tools » insufficient privileges error while using copy command (Oracle 10.2.0.4.0,SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insufficient privileges error while using copy command [message #554175]

Fri, 11 May 2012 02:37

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

Report message to a moderator

Re: insufficient privileges error while using copy command [message #554176 is a reply to message #554175]

Fri, 11 May 2012 02:46

Michel Cadot
Messages: 68509
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

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you michel for the answers.

Report message to a moderator

Previous Topic:	limit of max pool size.
Next Topic:	SQL for saving the query result in a txt file (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 30 00:51:59 CDT 2023