• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2391
  • Last Modified:

ORA-01010: Invalid OCI operation

Hello:

I am trying to copy a dump (binary) file to oracle 9.2.0.1.0 from 10.2.0.1.0 Oracle database, under Windows XP operating system.

I have created a directory "Source_Id" on local (10.2.0.1.0) machine and "Dest_Id" on target machine (9.2.0.1.0).
I have created a db link "Oracle90" on local machine.
I have tested the connection from source (10.2.0.1.0) as follows:

SQL> select * from blf2vkr.jobs@oracle90 where rownum < 2;

JOB_ID     JOB_TITLE                           MIN_SALARY MAX_SALARY
---------- ----------------------------------- ---------- ----------
AD_PRES    President                                20000      40000

I then used the following codes to transfer the binary file from local to target as follows and got the errors:

SQL> Begin
  2     DBMS_FILE_TRANSFER.PUT_FILE(
  3     SOURCE_DIRECTORY_OBJECT         => 'SOURCE_DIR',
  4     SOURCE_FILE_NAME                => 'DUMPX.DMP',
  5     DESTINATION_DIRECTORY_OBJECT    => 'DEST_DIR',
  6     DESTINATION_FILE_NAME           => 'DEMPZ.DMP',
  7     DESTINATION_DATABASE            => 'ORACLE90');
  8  END;
  9  /
Begin
*
ERROR at line 1:
ORA-01010: invalid OCI operation
ORA-02063: preceding line from ORACLE90
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 60
ORA-06512: at "SYS.DBMS_FILE_TRANSFER", line 168
ORA-06512: at line 2


Please find a resolution? What am I doing wrong?

Thanks,

blf2vkr

0
blf2vkr
Asked:
blf2vkr
  • 2
1 Solution
 
ravindran_eeeCommented:
Please check the value set for the environmental variable "DBLINK_ENCRYPT_LOGIN".. If it set to True, then change it to False and try the operation again..
0
 
johnsoneSenior Oracle DBACommented:
DBMS_FILE_TRANSFER does not exist in 9 that I can find.  My guess is that you cannot do it from 10 to 9.
0
 
ravindran_eeeCommented:
Can u check in ur Oracle 10g DataBase? To my knowledge this should be solving problem
Also it is possible to do it from 10 to 9
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now