1
vote
0answers
25 views

PLSQL Compilation error for other users/

I created a plsql procedure that queries the database and dumps the result onto a CSV file. I am an application developer and I have dba rights to my oracle database. I'm able to compile and run the ...
0
votes
1answer
51 views

How to grant permissions for User defined type in Oracle

This is probably easy but i can't seem to figure it out. I created my user-defined type as CO_ADMIN. However, the application using the type runs using GS_USER database account. I have granted ...
0
votes
0answers
187 views

A issue on DB link between Postgres and Oracle?

I am trying to create a DB link between Oracle and PostgreSQL using OCI. CREATE DATABASE LINK oraedb CONNECT TO hr IDENTIFIED BY 'hr' USING oci '//127.0.0.1/xe'; CREATE DATABASE LINK When I ...
0
votes
0answers
28 views

Database dependency problem

Hi I have a small question. I need some suggestions on how to solve this problem. I have database A,B,C,D. D access data from A,B,C in all environments (DEV,UAT,PROD). SO whenever database A,B,C get ...
0
votes
1answer
113 views

imp paused mid import

OK, I'm new to Oracle administration but I'm trying to import a previous dump (no pun intended) which was split into two files. The import is happening from an Oracle 9i to 11gR2 on Windows I used ...