Database; Oracle 10G R2
I check the weekend windows group in the resource manager it was scheduled to run on saturday i changed it to run on thursday and still the activity screen in performa...
I am working on Oracle 10Gr2 with Windows XP machine.
I have created 2 functions in oracle and I am pasting the code as shown below
i)
create or replace function sp_match_slabs(MU_ID IN VAR...
The sys admins applied some upgrades on this Sun Sparc 2000 box running Solaris 10.
Right after, when trying to restart the Oracle 10.2.0.3.0 database there, it would only give
ORA-00600: ...
Hi
I am trying to load bulk of data(millions of data) using dat files with Oracle 10g . I am doing this to get details about how much time it takes to refresh the materialized view when loadi...
Hi Experts,
I want to Remove locks NOWAIT on tables in database?
how to find the lock nowait on tables?
please help me on this?
its urgent.
Hi experts,
Some information about my Database
OS : Sun 10
Database: Oracle 10.2.0.1.0
Mode : Real application cluster
I have problem with startup of dbconsole , so I decide to recreat...
Experts,
In 10.2.0.3, or say even 10.2 , can i not set the SGA_TAGET to a value? If SGA_TARGET is not set to 0 , on a reboot the memmory managment goes to automatic? is that correct?
Thanks
Hi Experts,
I am trying to setup Oracle 10g dataguard on solaris 10 boxes. Here is the config file and tnsnames for primary and standby i have used.
primary database:
############
init...
I am loading a dat file with records as follows
I had to replace %s_pmPath% with /u01/app/oracle/product/10.2.0/db_1/demo/schema/product_media/ to get the data to load.
RECORDS
"P",3...
I executed a script to delete a tablespace and associated users from an Oracle database.
However, although the tablespace has beeen dropped, the user sessions still remain. The user is sti...
I want to update a field for many records from an Excel Spreadsheet. The number of recs is >1000 and a once off thing. I thought to generate these update statements in the spread sheet and pas...
Hi,
Does anyone know how to change the default DB \ SID that Oracle 10g for Linux uses?
We access the management console by accessing <IP>:5500/em.
regards
Ryan
i AM USING ORACLE FORMS FOR THE FIRST TIME. WHILE I TRIED TO RUN THE FORM , IM GETTING THE FOLLOWING ERROR:
ORA-12560 TNS PROTOCOL ADAPTER ERROR.
PLS ASSIST ME
sqlplus $CON_STR <<EOF >> $FeedLog
set heading off;
select to_char(date_value,'YYYYMMDD'),to_char(date_value,'YYYY'),to_char(date_value,'YY'),to_char(date_value,'Mon'),to_char(date_v...
I tried to Copy BLOB data from GBEN_BLOB1(table) to GBEN_BLOB2(table) in the same database. Passing the column lists through the procedure's parameters and i get the following error message:
...
Here is the requirement:
Source database: Oracle 8i on Solaris
Target database: Oracle 10g R2 on IBM AIX
Data Volume: 25 TB
Down time for migration: 1 business day: 8 Hours
We have rule...
I am running oracle 10g on windows 2003 server. I installed oracle 10g db and then oracle companion (html db and http server). Everything is great until i reboot. Then I get a service failu...
Guys
This may be a simple question but by applying the code
ALTER SYSTEM FLUSH SHARED_POOL would this have a negative affect on performance afterwards.
folks,
bit of a curly one, I have XE running nicely on a 2000 box, am setting up an ASP website on a 2003 web server and want to install the XEclient so I can get an ODBC connection happeni...
I need to be able to obtain the start_date and end_date of the previous month using an Oracle SQL query with sysdate.
Right now, I run select trunc(sysdate,'MM')-1, and that will give me ...
Hi Friends
I am trying to setup tnsnames and listener. But for some reason it is not getting connected to database and it throws error.
ORA-12514: TNS:listener does not currently
Can ...
Can some one please let me know the max length that String datatype supports in Oracle 10G.
What is the best way to select date from one table using a cursor and loading the data into a new table?????
Sample would be appreciated....
Hi,
is there any free front ends to oracle . Toad is not really free any more. too many strings attached.
sql developer that comes with oracle is deal slow and ot really healpful....
ma...
Hi,
1. What is the difference logical and technical between Oracle Database 10g Express Edition and Oracle 10 G .
2. Among the two, which is the commonly used in the industry?
