How to change value of distributed_lock_timeout in OEM regarding ORA-02049: timeout: distributed transaction waiting for lock?
We recently changed our Oracle (10.2.0.4.0) password security parameters but the old grace period (120 days) is still displaying when users log in. Here are the old profile settings:
PASSWOR...
My objective is to reset the sequence object every day (every day it should start with 1), since there is no inbuilt method to do so, I have written a small stored procedure to accomplish this...
Hi guys, i have windows xp and oracle9i, oracle 10g and oracle 11g install on my laptop but when i'm trying to connect oracle 11g getting this error
C:\>set ORACLE_SID=oracle11g
C:\>sqlp...
hi
i installed 9.2.0.8
create databse
try to restore with user system which connect the sql+ and net manager
and get this error:
IMP-00017: following statement failed with ORACLE er...
Hi I currently working Oracle Apps DBA for more than five years . and also you need to be core DBA to become apps dba . Also managing SQL Server .
My question what is the future for...
I'm trying to connect to a local instance of Oracle 10gExpress from C#. I downloaded oracle_net.msi and ran it. I'm using the following code, trying both provider strings. I get an error "O...
Hi,
do you have any recomandation to tune this query... PRICE table has 10.000.000 records ?
Thanks!
How to store and retrive images,videos and pdf files in Oracle using JSP,ASP and VB/VC++?
I want to store files in Oracle and I want to retrieve files from Oracle using JSP and VB/VC++.
An...
Hi
In HP-UX, recently we have
"Ora-00020 maximum number of processes exceeded
& I have to triple the HP-UX kernel parameters below before
I can increase the Max limit of oracle processe...
Dear expert ,
I have a form of oracle 6i.
In that form i haveonly one button called upload button.
that button is calling more than 10 procedures.it takes 20 minutes to finish the w...
I tried doing an "impdp" on the entire db, but got a " type not found of conversion to latest version is not possible" error
I then created the "type", ran "impdp" again, and got the same e...
I have access to an Oracle schema with an user called GOOFY.
This user hasn't the grant to create tables, and can only read the tables owned by MINNIE, through synonyms.
I am searching a tab...
could not find oracle home for toad when i open it..., how to set oracle home?
with Oracle 11g SQL Developer is default install when i start SQL Developer its saying
Enter the full pathname for java.exe
I dont know where the java.exe will be stored to start the SQ...
How do I reset an auto increment field in oracle.
Hi,
I'd like to use Fine Grained Auditing (FGA) on my Oracle database.
My Oracle version is:
select *
from V$VERSION;
BANNER
-------------------------------------------------------...
Hi
tnsnames.ora is ok and listener.ora is ok.
i also made a tnsping from command and it is ok.
i connect from sql+ of DB and client and it is ok.
but i get this error from applicatio...
How to use Impdb
what is different between import and impdb and what is used for and how to use it.
i dont know the dump user name..
Thanks
I have my database started with spfile and need to change the parameter how to do that?
I did change the parameter in the init.ora file and shutdown and startup the database but when I qurey...
I am looking for a query that will pull a char column and a number column
and will order by the char column name
but first place a number of items that match the number column
ie: a liter...
can I rerun impdp as it has already imported sveral objects in the schema cust.
does it cause any coruptio to data if I rerun the impdp.
will it overwrite the files already written to schema...
Trying to add column to existing table.(Oracle 10 g)
1) This table has existing records
2) Also need to rename this table.
3) While making this addition can I specify default values for th...
I have installed a client version of oralce 11g and installed
the OLAP Analytic Workspace manager and worksheet.
why it does not show OEM? what is best to install for client to connect to d...
Login -> SYSDBA
Trying to export 2 tables from HR schema using the following command:
C:\>expdp directory=dpump_dir1 Tables=REGIONS, LOCATIONS dumpfile=HR.dmp logfile=HR_2tbls.log
Receivin...
