Q by Skarthik3
Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object
Re by FreCho[......]
Q by Chandan 002
where does create table get stored in oracle 10g
Re by Oracwv
The default location is the system tablespace. This is bad because if the system tablespace gets full, the database fails. Create a new tablespace, and have a different user own any tables you create. You can alter the us[......]
Q by OracleATE
When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec. When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec – nearly 100% drop in performance. The explain plans are the same for bo[......]
Q by User71408
Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 [......]
Q by Said
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to th[......]
Q by Shwetavyas
Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error "ORA 01[......]
Q by Jh1993
using Oracle 10gR2 on Windows 2003 server. I can’t setup the preferred credentials on the Job scheduler screen on the console. I also have the email issue. I tried to use DBCA and clicked on database options and everything is greyed out and I cant seem to proceed. How can I configu[......]
Q by mjevans
What is the quickest way to move a database from one server to another…same platform and O/S version, same Oracle version (8i)?
Re by NamitaD
I found the quickest way to refresh a database is to copy all files (datafiles, control files, redo log files) via the operating system (UN[......]
Q by Markv
We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks
Re by Jessew142
Running[......]
Q by daveSTC
Is there a SQLServer equivalent to being able to retrieve internal application specific metadata that to the users/roles v.s. object privs (select, insert, update, delete, execute, etc.) ? In oracle it’s achieved by forming SQL selecting data from the appropriate "dba_" [......]
