Hi. I'm trying to experiment with oracle spatial, the geocoder and routing engine. There is sample geodata from NAVTEQ on OTN that I want to experiment with....
The error message is correct: imp is not a SQL*Plus command. It is an executable program, so you need to issue the command from the operating system command...
You might be thinking of Oracle Rdb (formerly DEC Rdb) where import is a command from SQL. In straight "Oracle 7/8/9/10" it is a separate executable outside...
Dr Robert Young
rcyoung@...
Jan 10, 2005 6:03 pm
642
I'm trying to find the best way to implement a DR solution for Oracle running on legacy systems. I would like to move from the old hardware/software to a...
Export/Import is one option that has historically been used for this type of reorganization going well back to V6. You will find a lot of information on its...
Dr Robert Young
rcyoung@...
Jan 18, 2005 2:19 am
644
Can anyone tell me if there are advantages to running Oracle on NT over Solaris ? From the NT side, the cost is smaller, but you loose tracking individual...
Steff Gonos
steff_gonos@...
Jan 20, 2005 7:01 pm
645
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Michael Robison" <mrrobison@...> Slight tangent on...
Hi I am trying to help a friend. He is using Erwin 3.51. All he was tasked to do was to add some UDP (user defined properties). He did that successfully. He...
Shariq, It has been a long time since I used ERWin, but do recall that the datatypes are specific to the the database connection/driver. For instance using a...
Moody, Mark
moodymark@...
Jan 21, 2005 9:43 pm
649
Allen: A question I missed - what do you mean that you can't backup files while Oracle is running? Is the oracle files or system files of which you write ? ...
Steff Gonos
steff_gonos@...
Jan 21, 2005 9:48 pm
650
Thanks for everyone's comments. The bottom line seems to be that oracle is oracle and runs similarily on all platforms. The comment about NT was correct as...
Steff Gonos
steff_gonos@...
Jan 21, 2005 9:49 pm
651
I think he must have changed the target database driver. Datatypes are linked to the target database. Thanks Jignesh...
Jignesh Patel
jporadba@...
Jan 24, 2005 12:59 pm
652
+ Interjection by listserv moderator: + Follow-up on this series of postings from last week... ... From: "Allen Shepard" <ashepard@...> ...
VOUG Membership - If you're considering a trip to a large Oracle conference this year then the following information may be of insterest. IOUG conferences are...
Hi, I'm inserting data into a table, if the insert returns an ORA-02291 exception I want to handle the error and continue: -- -- INSERT INTO PRICE_LIST_DTL...
Hi, We are converting some Pro*C code use multiple process threads. We're encountering periodic data not found errors when we do this. The data being queried...
HI Use something like this under declare section: declare l_errmsg EXCEPTION; Pragma EXCEPTION_INIT(l_errmsg,-02291); begin insert ... exception when l_errmsg...
i'm assuming your GOTO targets are in the code after the INSERT_PRLSTDTL block first, avoid using GOTO's at all costs -- instead, modularize your code or use...
Mark C. Stock
mcstock@...
Feb 3, 2005 3:05 pm
660
+ Interjection by listserv moderator: + As always, responses by individuals to these types of postings + are most welcome - corporate solicitations and spam,...
+ Interjection by listserv moderator: + Many interesting and helpful responses to this posting, below, + plus an offer to start a study / support group in the...
All, I am using latest version of erwin that does not suport the mySQL database drivers and we have to manually modify the generated scripts to run on MySQL...
Hiya All, I don't understand how the UNION operator works. If I union together two simple queries from one of our tables: SQL> l 1 select spriden_id 2 from...
Larry Blankenship
lblankenship@...
Feb 18, 2005 8:44 pm
664
Think of set algebra (and check out the descriptions in the Oracle SQL Manual, at tahiti.oracle.com) UNION: Items that reside in either set (duplicates...
Mark C. Stock
mcstock@...
Feb 21, 2005 1:32 pm
665
Hi, you would generally use the union operator to link two queries together for example if you had two tables with people information in them and you wanted a...
We're trying to do an implementation of Oracle Streams using 9iR2 and finding it a very bumpy road. Is anyone familiar with Streams in 10g? Is it a more...
Willis-Ford, Carl
carl_willis-ford@...
Feb 25, 2005 3:21 pm
667
Your results may vary depending on the version of 9iR2. I first used Streams in 9.2.0.3 and found it nearly impossible to manage. 9.2.0.4 was a lot better...
Brett Ogletree
bretto97@...
Feb 25, 2005 9:01 pm
668
Enter your vote today! A new poll has been created for the VOUGlist group: "VOUG" has always been the acronym for "Virginia Oracle User's Group". Since many...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
