experts,
i am facing one problem while creation of function based index. could you please help me.
please verify the code.
CREATE INDEX license_key_hwid_test ON license_key
(
PSEUDO_I...
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 stuck and I don't know where I am going wrong. any help would be greatly appreciated.
{"ORA-01036: illegal variable name/number\n"}
{"Method may only be called on a Type for which T...
I have heard some information that virtual memory usage for 10.2.0.4 is vastly improved . is this the case in the real world? do you have any general recomandations to limit virtual memory usa...
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 am working on a class assignment for Oracle SQL Plus. Part of the assignment is to create two tables using a script file. One of the tables "departments" only has 27 records s...
I've done some testing, so hopefully the next few lines will asssit in the solution.
I'm trying to install Oracle Express Edition 1og onto a vista laptop. I have attemted to install this o...
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: ...
I am having trouble getting the universal installer to pop up. New install on fresh RHEL 4.5 install on Zvm.
This is the 64bit version and I have the 64 bit Z linuxoracle downloaded that I am...
I am trying to develop plsql code to generate automatic email to send as a reminder.I followed the procedure which was stated in the UTL_MAIL in the metalink about the UTL_MAIL.. But iam getti...
Experts,
i am getting deadlock issues. i want to find dead lock complete information.
how do i find deadlocks?
how do i find the quries are involved in deadlock.
how do i resolve it?
co...
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
Hi,
Does anyone have experience in setting up Oracle 10g using Automatic Storage management (ASM) on Solaris 10, using ZFS?
I would appreciate some pointers / instructions..
thanks
I want to have the headers & all output of this query to have a comma after each. I want this so if opened in excel it will not default to just one column.
Here's my query. the TIMEFORSTARTO...
Hi,
I am getting date data from a web form (in the format mm/dd/yyyy) and I want to insert that date into the oracle table. But I want to convert it first into the following format (mm/dd/...
So far, open and read a text file is ok...but...
1. how to insert into TEST table?
2. it should more than 2 rows
How to be inserted into TEST table??
--------------------------------...
hi
i have this line in my function.
tmp_strvalue := dbms_lob.substr(clob_data, 100,
dbms_lob.instr(clob_data,'<Name>Speed[100]</Name>',1,1));
i want to know what are the ar...
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 need to load the data into a date field where the file has the date in julian format of YDDD
I do not know how I need to code this in the sql loader file.
Example that does not work:
...
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....
Oracle Forms 10g(10gDeveloper)the client requirement "PRINT THE REPORT WITHOUT PREVIEW..from FORMS" they don't want to see the out put on browser they just want prints outs. i.e. i am running ...
Hi,
Not sure if this is possible.
I am joining two tables (one view and one table). At runtime, the view name might change due to versioning, so I need tosomehow dynamically build up the...
I receiving a two digit number and I need to convert it to a 3 character Month.
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:
...
The DB runs on SuSE Linux Ent.Srv 10.0. I am new to Oracle upgrading issues and would appreciate if you help to figure out how to correctly upgrade, according to the subject?
