2,157 reputation
513
bio website
location Austria
age 57
visits member for 3 years, 1 month
seen 40 mins ago

Jul
8
answered Load Java Class To Oracle Database
Jul
8
comment Load Java Class To Oracle Database
@Justin Cave: who should load the java classes?
Jul
7
reviewed Approve suggested edit on Configuring Reporting Services - ExecutionLogDaysKept
Jul
5
answered How does the Oracle DUAL table work?
Jun
28
comment Not able to connect to non-default oracle database after reboot
1. check which databases are running ps -fe|grep pmon 2. check if there are the appropriate configuration files ls -l /u01/app/oracle/product/11.2.0/db_1/dbs/*HAYER* and show us the output
Jun
27
comment Not able to connect to non-default oracle database after reboot
sorry, I see now that you wrote you cannot start your database. so my previous tests are meaningless because you already have not database named HAYERTEST.
Jun
27
comment Not able to connect to non-default oracle database after reboot
The error message of sqlplus says that the listnener doew not know a service HAYER_TEST. If you ask the listener directly using lsnrctl you can see that the listner does not know a service HAYER_TEST. 1)Do you have an instance HAYERTEST with a service called HAYER_TEST. 2)Why does the definition of tnsname HAYER_TEST contain a service_name and a sid? 3) can you show us the output of the following query: select 'Service' "Type", NETWORK_NAME "Name" from dba_services where NETWORK_NAME is not null union all select 'Instance',sys_context('USERENV','INSTANCE_NAME') from dual ;
Jun
27
comment How to run oracle PL/SQL in C++?
I thinks this question is more appropriate for stackoverflow.com. But I think you should supply more information. What error message do you get? What kind of access to the database do you use? Is this ODBC? What Version of Software are you using: OS, datbase client libraries, compiler, database,...
Jun
19
comment IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer
$ORACLE_HOME is the directory where you have installed Oracle software. lsnrctl is an executable binary in the $ORACLE_HOME/bin directory. This $ORACLE_HOME/bin directory should be one of your pathes set in your PATH environment variable. The path variable should be exported.-bash: lsnrctl: command not found means that the system does not find lsnrctlin a path set in your PATH environment variable. Why? Please check this.
Jun
19
comment IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer
would you be so kind to add these error messages properly formatted to the original post?
Jun
19
answered How to reference a table from another schema inside a package?
Jun
18
comment Mysql find 10 nearest point from given lat/long per type?
The problem with this approach is that the whole table must be scanned and the distance must be calculated for every point. Maybe one can use the spatial extension or one tries to implement some computational geometry algorithms without usage of the spatial extension. Besides the performance problem of your approach it can be severly limited by the fact that the earth is approximately a sphere. But this depends on the data and can be overcome by the appropriate formulas.
Jun
17
comment How to select specific rows if a column exists or all rows if a column doesn't
This is really funny but @RolandoMySQLDBA I think one should not use such obfuscating code. A lot of comment is needed to to guide the reader of the code in the right direction. Using exceptions or quering INFORMATION_SCHEMA is a much better approach.
Jun
17
comment How to reference a table from another schema inside a package?
you must have granted select permission on this table to the dschema thaat owns the package. It is important that this permissions are granted directly to the package owner and not indirect using a role. Using a role is sufficient to select the table directly by Toad but it is not sufficient if you want to select the table in a package.
Jun
17
comment increased tablespace but dba_tablespace_usage_metrics order shows same
There are problems with this view in 10g, "The DBA_TABLESPACE_USAGE_METRICS View Needs to be Rebuilt in 10g (Doc ID 738101.1)": "Download and apply the patch from Metalink for Bug 6629893. This is a generic patch which is available for: 10.1.0.5, 10.2.0.2, 10.2.0.3, 10.2.0.4. As this is a generic patch, this means the patch is essentially a script that rebuilds DBA_TABLESPACE_USAGE_METRICS prerequisite objects. This bug is fixed in the 10.2.0.5 patchset."
Jun
16
reviewed Approve suggested edit on How do I write a mysql query to combine data from related tables into a single summary?
Jun
16
revised sqlplus is not starting
error in LD_LIBRARY_PATH
Jun
16
comment sqlplus is not starting
There is an error in these profile: The variable LD_LIBRARY_PATH is set twice. Thje value set first is overridden by the second set. Especially the $ORACLE_HOME/lib cannot be found in the final LD_LIBRARY_PATH. I will change this because I think this error was only intoduced to get a better format of the post
Jun
14
comment Why is add timestamp column with default not null so slow in Oracle 11g?
can you add the statement that tooks long.
Jun
13
awarded  Custodian