Oracle Help
in [SQL]
|
Oracle Spatial Selecting Overlaps returning no results (whenit should)? john.e.major.jr(a)gmail.com wrote: Hello- I'm looking for advice on a problem I've hit with Oracle 10g spatial. I am storing a large number of rows with a feature_rectangle column defined for each entry(which is just a variable sized solid 2d rectangle). I have followed a table & index creation ... 5 Aug 2008 20:26
"Drop Public Synonym" hangs We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance. When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time. Attempted things done that all hang: Select * from our_synonym; drop public synonym our_synonym FORCE;... 6 Aug 2008 15:55
Can this be done with a trigger? Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED We also have a history table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS SOURCE DATE_ADDED We want to put a trigger on the first table such that when a record is inserted or updated it will m... 7 Aug 2008 15:31
Triggers Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED We also have a history table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS SOURCE DATE_ADDED We want to put a trigger on the first table such that when a record is inserted or updated it will m... 5 Aug 2008 20:26
Trigger Question Hi, We have a table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS DATE_ADDED DATE_MODIFIED We also have a history table like this: CUSTOMER_ID PRODUCT_ID FORMAT STATUS SOURCE DATE_ADDED We want to put a trigger on the first table such that when a record is inserted or updated it will... 5 Aug 2008 12:10
AD4J Installation with JBoss Hi, Does anybody know Oracle AD4J? I´ve got the AD4J-Console running on Suse Linux and the agent-file upon JBoss (Suse Linux, too). The console works fine but when i try to deploy the "jamagent.war" file on the JBoss-Server, i always see the following error-message: ########################################... 5 Aug 2008 11:08
Oracle DSN creation in Windows XP - default enabled parameters ... hi, in windows xp when you create an oracle DSN using %SystemRoot% \system32\odbcad32.exe then by default - enable result sets - enable query timeout - enable thread safety are all checked. i am wondering if anyone knows of a way to change these defaults. is there any way to influence these defaults at the re... 5 Aug 2008 11:08
how to get standby cluster node activity time? Hi Oracle license says, that standby node does not need a license if its not used for more then 10 days per calendar year. How can i obtain this activity time? Thanks ... 7 Aug 2008 19:39
Select one field/value from two different tables I have two tables: "Old" and "New". Both table have the same primary key name and type: "PKEY", NUMBER. "Old" table has a column called "oldschool", while "New" table has a column called "newschool". Both columns are the same type (NUMBER) and cannot be null. I'm told that the two tables are mutually exclusiv... 6 Aug 2008 12:49
Oracle table Replication between versions Can anyone suggest a way of Replicating a group of tables from one database out to another under these conditions: + Source database is version 8.1.7.4 + Destination database is version is 10.2 + Tables contain Longs + Tables do not have primary keys + Changes need to be applied to destination tables asap afte... 4 Aug 2008 18:46 |