понедельник, 30 ноября 2009 г.
|
| What the answer. I have the same problem ? I was expecting... Guest 19:22:28 |
| | What the answer. I have the same problem ? I was expecting an answer. ![]:-)](http://qaix.com/i/smiles/devil.png "]:-)") |
| |  2 answer | Add comment |
понедельник, 23 ноября 2009 г.
|
| Oracle client directory... Guest 16:45:00 |
| | Oracle client directory = c:\oracle\product\10.2\client1\BIN |
| | 4 answer | Add comment |
вторник, 10 ноября 2009 г.
|
| Hi, I use C# com object OracleInProcServer but I can not... Guest 09:38:02 |
| | Hi,
I use C# com object OracleInProcServer but I can not get sdo element info too:
OracleInProcServer.OraSession oraDBSession = (OracleInProcServer.OraSession)new OracleInProcServer.OraSessionClassClass();
OracleInProcServer.OraDatabase oraDB = (OracleInProcServer.OraDatabase)oraDBSession.get_OpenDatabase(this.dbName, this.userInfo, 0);
OracleInProcServer.OraDynaset dynSet = (OracleInProcServer.OraDynaset)oraDB.get_CreateDynaset(sql, 0, ref obj);
OracleInProcServer.OraObject oraObj;
OracleInProcServer.OraCollection oraColl;
OracleInProcServer.OraFields oraFs;
OracleInProcServer.OraField oraF;
while (!dynSet.EOF)
{
oraFs = (OracleInProcServer.OraFields)dynSet.Fields;
oraF = (OracleInProcServer.OraField)oraFs["GEOM_COLUMN"];
oraObj = (OracleInProcServer.OraObject)oraF.Value;
...
dynSet.MoveNext();
}
There is no property to get like oraObj.sdo_elem_info.
How can I get sdo element info from oraObj?
Lots of Greetings!
Ahmad |
| | 1 answer | Add comment |
пятница, 6 ноября 2009 г.
среда, 28 октября 2009 г.
|
| Hi Alex,I was wondering if you found a way to load 300mill... Guest 08:28:12 |
| | Hi Alex,
I was wondering if you found a way to load 300mill records in leass time efficiently. I am trying something similar.
Thanks |
| | 3 answer | Add comment |
четверг, 1 октября 2009 г.
|
how to connect jdk1.5 to oracle 11g  india 08:23:03 |
| | sir , i don't know for connecting jdk1.5 to oracle 11g . so i want solution for this |
| | Add comment |
суббота, 22 августа 2009 г.
|
| Oracle Developer Suite 10g cannot be installed into existing Oracle Home ericzutter 07:16:11 |
| | I downloaded the latest Oracle versions for studying. (I don't have a metalink account because I am actually not working)
I want to install Oracle Database 11g + Oracle Developer Suite 10g on the same Windows XP Desktop. I did the following steps :
- Install Oracle Database 11g in ORACLE_HOME "C:\oracle\product\11.1.0\db_1".
- Create a database DEV
- Startup database DEV, listener and configure sqlnet.ora+tnsnames.ora
- Connect to the database with sqlplus system@dev => connection succeeded
- Install Oracle Developer Suite 10g in ORACLE_HOME "c:\oracle\product\DevSuiteHome_1" and choose Installation Type "Complete (1.13 GB)"
When I install Oracle Developer Suite 10g I receive the following error:
Oracle Developer Suite 10g (10.1.2.0.2) cannot be installed into existing Oracle9i 9.2.0.1.0 or higher Oracle Home.
I don't understand why I receive this error. Oracle Developer Suite creates a seperate Oracle Home, so I don't understand why the error says that it tries to install into an existing Oracle Home.
What must I do to solve this problem?
|
| | 2 answer | Add comment |
четверг, 13 августа 2009 г.
|
| how to connect to oracle 10g using oci driver with jdk1.6.0 avinash 08:06:03 |
 | i am new oracledatabase combine with java programing .
i tired this program .
----code-----
import java.sql.*;
public class OracleOciConnection
{
public static void main(String args[])
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@","hr","hr");
System.out.println("connected to oracle using oci driver");
con.close();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
it successfully complies but on execution it gives an error
C:\java>java OracleOciConnection
java.lang.ClassNotFoundException: oracle.jdbc.driver.Oracle.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at OracleOciConnection.main(OracleOciConnection.java:9)
can any tell me how to solve this problem
i changed path ,classpath many times
i search many sites but sloved my problem .
so plz tell me step by step connection to database
i am using oracle10g and jdk1.6.0 . i have also install jdk1.5.0
and also tell me what option to chose in ODBC Data Source Administrator window |
| | 1 answer | Add comment |
пятница, 3 июля 2009 г.
|
| Hi , Are u familiar with Oracle Cl... arabe 19:04:13 |
| | Hi ,
Are u familiar with Oracle Clinical? I need access to do some practice in writing the Validation Procedures. Any advice.
Thanks
LowLifeD |
| | Add comment |
среда, 13 мая 2009 г.
|
| When an audit record doesn't fit max event record size... Guest 18:41:03 |
| | When an audit record doesn't fit max event record size, oracle splits it and writes multiple event records to the event log. The perl script doesn't pick such records correctly.
I found utility called db audit expert that can pull oracle SYSDBA audit records from the event log and save them to OS files or save them to some table in the database
|
| | 1 answer | Add comment |
четверг, 7 мая 2009 г.
вторник, 9 декабря 2008 г.
|
| dag nab it all to sh******ttt!I have the same issue, but im... Guest 22:57:51 |
| | dag nab it all to sh******ttt!
I have the same issue, but im going from 10.2.0.2 on production to 10.2.0.4 on test server. As OP pointed out, it's only the last alter clone database open resetlogs that fails.
I can then shutdown instance, startup upgrade, but get "recovery needed", but its asking for loq seq number 1, which means it must have already reset the logs?? Or?, but log 1 is not archived yet, so I run recover database until cancel and give it the first online redo log, and it says media recovery complete, then I do alter database open, and get message that I need to use resetlogs... all seems fine and dandy, but alter database open resetlogs completed blows away the instance. Seems like you cannot startup upgrade, then open resetlogs in this scenario.
As the OP said, this seemed like an OK idea at the time... Customer is going to be very pissed, but I think I have a tar backup of the previous 10.2.0.2 home on disk, so I may still be able to recover from this. |
| | Add comment |
вторник, 21 октября 2008 г.
|
| If you really want to do this in a stored procedure, try... Guest 09:09:40 |
| | If you really want to do this in a stored procedure, try this:
execute immediate 'set autocommit off'; |
| | Add comment |
понедельник, 22 сентября 2008 г.
|
| I want to compare two times...which one came first!any... Guest 15:29:29 |
| | I want to compare two times...which one came first!
any help!please! |
| | Add comment |
четверг, 31 июля 2008 г.
вторник, 23 октября 2007 г.
|
| Unable to see the contents of only ... Guest 08:22:06 |
| | Unable to see the contents of only one view.
Other views are working properly.
Only oneview is creating some problem and throwing the following error:
ORA-03113: end-of-file on communication channel
Help me please |
| | Add comment |
четверг, 19 октября 2006 г.
|
| billy... nice story... but i do not see any answer...this... Guest 15:45:53 |
| | billy... nice story... but i do not see any answer...
this was not a modals course for developer
bla bla answer |
| | Add comment |
четверг, 12 октября 2006 г.
|
| =^B This info is winning.It is not obvious the approach of... Guest 08:21:26 |
| | 
This info is winning.
It is not obvious the approach of reusing statement handle.
Programmers usually implement with bind variables, but recreate statements in loops. It is the first time I see this point clearly stated. Thank you !!! |
| | Add comment |
понедельник, 11 сентября 2006 г.
|
| If you grant the create any trigger privilege to the user... Guest 16:11:14 |
| | If you grant the create any trigger privilege to the user he will be able to see triggers on other schemas. |
| | Add comment |
|
