My question may be so vauge as to be unanswerable in anything less than a book, but if anyone can provide any assistance I will appreciate it. I have been...
I'm using Oracle9i on a Windows 2000 box. I'm new to XML and I'm attempting to run a .XSQL file. I only get the headers specified in the HTML, none of the...
Hiya All, I have been experimenting with external files, and was able to successfully set one up. (Yea!) When I granted select permissions to other schemas,...
Larry Blankenship
lblankenship@...
Dec 17, 2004 11:13 am
637
+ Interjection by listserv moderator: + Here's three helpful replies to this posting, below... ... From: Vaibhav Dani <vdani@...> Hello , You also need...
Larry, Hi. I found 3 good articles but have not tried external tables yet http://www.dbasupport.com/oracle/ora9i/External_Tables9i.shtml ...
Allen Shepard
ashepard@...
Dec 17, 2004 10:37 pm
639
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...
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.
