i have a .db file that shows that is a Berkley db is there a program somewhere where i can view the Db file in windows ....
ive been searching a bit for these but im not sure im putthing th...
Need help... Objective is data migration, assign new key value.
Entire msg is:
ORA-06550: line 145, column 17:
PLS-00225: subprogram or cursor 'VCUR' reference is out of scope
ORA-0655...
We have a need to discover all versions of oracle that are installed on 100's of servers - some oracle homes are not in use (have no database currently running using that home), but we still h...
Im unable to start the database. It gives the error:-
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure ...
Is there an easy way to replace a unique indexed primary key with a non-unique index without invalidating objects?
I ma new to using SQl Loader. I am trying to load a datafile into a table and am running sqlldr from my pc. I have oracle 10.2 client installed in my machine. The ORACLE_HOME and PATH is prope...
I configured an Oracle 10.2.0.4 DataGuard Configuration that simply has a Primary and 1 Physical Standby Database.
I perform nightly whole backups on the Primary using third-party software,...
Hi experts
in waht query can i use to find out on which tablespace i am working at iven moment from code.
for example: i am connecting now with schema DEMO, i would like to know on which t...
What are the steps to upgrade an Oracle 10.2.0.3 to 10.2.0.4 database manually using scripts on AIX platform.
What is the location of these scripts?
Thanks!
When I tried to do impdp from dumpfile I got following errors.
I check lot of tables starting with MLOG$ and RUPD$ are missing when I did the import.
I want to copy schema from one database ...
Hi
i am trying to create global temporary table in the temp tablespace of that schema but get an error:
create global temporary table in_dbamn.T_INLISTIDS TABLESPACE TEMP1_TS (SP_ID varc...
I installed 11.1.0.6 on my windows xp machine can any one tell me which patch set I need to apply on client 11.1.0.6 to upgrade it to 11.1.0.7?
I need a oracle 10g cold backup script for windows server so that i can schedule that job
I have a table like this:
ColumnA ColumnB ColumnC
----------- ---------- -----------
A 16-2 100
A 16(C) 75
B ...
how to use this proc for utl_mail instead of utl_smtp?
CREATE OR REPLACE PROCEDURE PRO_EXPORTLOG
AS
SendorAddress Varchar2(30) := 'xxx.xxxx.local';
ReceiverAddress varchar2(30) := 'm.taj...
Can someone explain to me what Staleness = unusable implys? The view contains data when I query but when it is being refreshed it takes hours to run. Can a view be refreshed if it has a stalen...
I have table called dates and I have a column called ADates in Oracle.
I want write a query to get records with currentdate and previousdate
Previousdate being the greatest date less than cu...
I have just upgraded my Toshiba R500 Portege to Windows 7. It was running XP so I did a complete reinstall.
Everything is working fine apart from the touchpad. When I install the vista driver...
I have a table which I can view by desc and select shows me the data. But I dont see this table in all_tables, user_tables
or dba_tables. Can someone help me with this?
I get the above message when I shutdown oracle. Should be concerned?
Also during the shutdown, the alert log reports that there are Process OS that are alive after kill.
SET_ITEM_INSTANCE_PROPERTY or SET_ITEM_PROPERTY
Can someone please give an example?
I want to check a checkbox.
We are running out of tablespace frequently. I need a script in plsql and shell script that will monitor the tablespaces and archive log destination if the free space is less then 20% it shoul...
Hello,
Sorry about my english but i french body, and i hope so my questions are intellegible.
The problem is using AWE on PowerEdge 900 with 4 processor Intel(R) Xeon(R) CPU X7460 @ 2.6...
Hi experts,
I have a problem with oracle 10g on hp-ux titanium ia64. It generates lots of trace file in the udump directory with the error: Ioctl ASYNC_CONFIG error, errno = 1. it generate...
I have an application here that makes a call to an obosolete parameter in 11g (ALTER SESSION SET hash_join_enabled ). I have no way of turning this off on the application side. My problem is...
