Need help on this...please provide code and/or steps
SQL Developer is not working due to a bug and I do not have time for another downgraded install, etc.
Thanks
I have a query that has been working fine. But now, all of a suddent it takes too long and timeout.
I have 3 tables and I'm joining them with TRACKING_ID column that is available in all 3. Le...
Hello Experts -
I've this following SQL to tune. The table T_DATA has 15 million rows..
Its running about an hour in QA and would like to rewrite.
Any great ideas.
Thanks,
Sve.
We want to install java instead of users having j initator for oracle applications. Any one has notes or steps to do this process
How can I get a a list of all
Oracle HR schema tables and their MB size ?
Example
CUSTOMERS 45.3 MB
ORDERS .1 MB
etc
How do I modify this to only show the highest seqn number for each trid?
Can someone help me with a rem query in a batch file. I would like to query the registry to check the version on IE on the computer. If it is IE6 then run the install for IE7. If IE7 already e...
Hi
i received from the customer DB of version 10g.
i create a new databse , create tablespace and try to restore it with import command.
it faile, and it looks like i am not sure which ve...
" Your shared pool maybe filled with non-reusable SQL with 93.06% memory usage. The Oracle shared pool contains Oracle´s library cache, which is responsible for collecting, parsing, interpreti...
Our vendor replied that Windows Clustering is not able to provide high availablity for our Oracle database.
If we engage Oracle consultants, what is the estimate mandays effort to setup th...
Assume a file containing an SQL script is named Run_sql.sql. I am able to execute it from SQLPlus with the following command:
@Run_sql
However, during a transmittal process, the file is conv...
When i try to execute following bash script, the scripts gets hang and i receive dead.letter file.
What does this mean. How can i test, if there is issue with synatx or email id?
The script ...
We have new policy in our company, we need to know whenever any one delete the ORACLE database logs and record the operation. So we know by who & when the logs were deleted.
How can I get the below to display 2359
rows and still include one of the
fmf.FMCODE's "fmed.FMTEXT" columns ?
--run below displays 2372 rows
SELECT distinct fmf.FMCODE, fmed.FMTEXT...
How to import follwing data from oracle database to CSV format as per attached:
From Database:
MONTH DEVICE VALUE
1/1/2010 A32A 200
1/1/2010 AH03 200
1/1/2010 AH12 200
1/1/2010 AH22 10...
I have a problem with getting the list items, below is my hibernate code, after that code there is my method ..and below that is my junit test. How can I make sure that query is executing prop...
I ran trace on a job and then tkprofs.
But the explain plan component fails, it says
"Error in CREATE TABLE of EXPLAIN PLAN table: OPS$IMEDW.prof$plan_table
ORA-01031: insufficient privi...
Expert,
I am working on Oracle 11g and when I try and start up SQL Manager I get the following error:
ORA12528 tns listener all appropriate instances are blocking new connections. T...
Hi Experts,
Has anyone know that how to display the column heading for this .CSV file? I created the below script, but column heading for some reason it is not displaying. Is this because o...
Hi,
The following query is taking too long to execute. Kindly help me fix this.
SELECT /*+ PARALLEL(A,8) */ A.* FROM Firsttable A WHERE A.PPA_POLICY_ID IN
(
(
SELECT /*+ PARALLEL...
Dear experts,
Is there a way 'not to' produce log and bad files in Oracle External Tables? Also I would like to learn how to direct log and bad files in different directories?
BR
This works:
instr(to_char(1223),1223) > 0
This does not:
instr(to_char(1223),5675*1223) )> 0
Why:
What do I need to make the longer string in order for instr to find it?
I get no error j...
I am trying to find records in which addr1, addr2, city, state, zipcode having count > 2
If there are any null values(for addr2,city,state..etc) returned for some columns by B the query be...
Hi Experts
i am trying to import dump file , after i created the tablespaces and get this error:
"CREATE USER "NMART_C_26739" IDENTIFIED BY VALUES '23CB943B2AF5DBD4' DEFAULT"
" TABLESP...
during the upgrade by using dbua iget this error
D:\app\.....\bin\oravssmsg.dll(the requested operation cannot be performed on a file with a user-mapped section open.
How to resolve this error?
