When ever i drop one particular table my database connection is gone
and when i try to start database i am getting ORA-12547: TNS: lost contact.
I restarted the server then it works, but that is ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24233024.html
Zones:
Oracle 10.xDate Answered: 04/29/2009 Rating: 6.5 Views: 101
I was trying add table to replication process. and run below proc.
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES( ...
http://www.experts-exchange.com/Database/Oracle/Q_23296176.html
Hi
There is a problem with oracle streams sequence number conflict when we go for bidirection replication.
How can I resolve it.
For example already The current sequence number is 1991 on ...
http://www.experts-exchange.com/Database/Oracle/Q_23311860.html
Hi
We are using Oracle streams for replicating data. I have question with user creation.
When a new user created at SITEA is it possible we can replicate in SITEB.
Are there any scripts for ...
http://www.experts-exchange.com/Database/Oracle/Q_23312068.html
Hi
I am trying to do export and import from one database to another database. And See warning messages in the log file
EXP-00056: ORACLE error 4031 encountered
ORA-04031: unable to allocate ...
http://www.experts-exchange.com/Database/Oracle/Q_23315335.html
Hi
How to create SYNONYM for dblink "prod.usa.targlet.com"?
I tried something like below but it is not working
CREATE PUBLIC SYNONYM "DB_LINK.USA.TARGLET.COM" FOR st$adm."prod.usa.targlet...
http://www.experts-exchange.com/Database/Oracle/Q_23350166.html
when I try to run below procedure it is giving error. Do I mis anything in the code.
Thanks
http://www.experts-exchange.com/Database/Oracle/Q_23354724.html
Hi friends
We have recently migrated from 9i to 10g database. And we are testing applications.
While inserting into one of the table we are getting error. End of communication channel
ORA-0311...
http://www.experts-exchange.com/Database/Oracle/Q_23389246.html
This question is really about a much more complicated query, but the core of the issue can be reduced to the simple queries below.
The following query, results, and plan are good. Performance is...
http://www.experts-exchange.com/Database/Oracle/Q_23739366.html
Hi Friends
What is difference between MAINTAIN_TABLES and ADD_TABLE_RULES procedures in DBMS_STREAMS_ADM package.
Because both of them are used to create rule on Table to add table to replicati...
http://www.experts-exchange.com/Database/Oracle/Q_23308479.html
