RE: VB/Oracle question
How are you connecting - if you are using odbc you will need the Oracle client software. -Original Message- Sent: Wednesday, September 26, 2001 10:50 AM To: Multiple recipients of list ORACLE-L If I was going to distribute a client VB application connecting to Oracle, would I need to also distribute the Oracle Client tools or is there a small driver package to install without all the tools? Thanks, Brian King mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Copy - why doesn't this work?
SQL copy from lea/lea@fog to lea/lea@fog create test3 using select * from test; Array fetch/bind size is 15. (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 1. (long is 1) ERROR: ORA-00911: invalid character SQL desc test Name Null?Type - A CHAR(2) B LONG C CLOB SQL desc test3 ERROR: ORA-04043: object test3 does not exist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fail over with ODBC and standard edition
The problem I have is with the TnsNames.ora. With no changes it doesn't fail over (this is expected). I make the changes to the the file with the parameters from the failsafe doc's and get ora-01012 not logged on and then sp2-0575 use of sql feature not in sql92 entry level whenever I try to log in, I then get a sql prompt - I can then do describes but no selects. -Original Message- Sent: Tuesday, September 04, 2001 6:56 PM To: Multiple recipients of list ORACLE-L John, I have never used TAF(Transparent Application Failover) with MS Cluster(Only with OPS on NT) so I am not sure if TAF will work or not. TAF is built into Oracle's ODBC driver but not microsoft's. I only use the EE edition but TAF is part of NET8 and Oracle8 OCI developed application's. NET8 and ODBC is part of the EE and standard editions of Oracle. Oracle's ODBC driver is written with Oracle8 OCI and Microsoft's ODBC driver is not. You will also have to setup TNSNAMES for TAF to work with your application. Now my big disclaimer is that I only setup the ODBC driver, I never tested it because I don't have any apps that use ODBC. Scott --- Shaw, John B [EMAIL PROTECTED] wrote: Do you need to have Enterprise server for the odbc fail over to work. I have standard edition on a MS cluster and the odbc connection doesn't stay connected after failover. It doesn't indicate that you need enterprise (at least not that I noticed) for this feature to work, but so far I haven't been able to find a magic combination to make it work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fail over with ODBC and standard edition
Do you need to have Enterprise server for the odbc fail over to work. I have standard edition on a MS cluster and the odbc connection doesn't stay connected after failover. It doesn't indicate that you need enterprise (at least not that I noticed) for this feature to work, but so far I haven't been able to find a magic combination to make it work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Licensing for a Clustered Server Configuration
Title: Oracle Licensing for a Clustered Server Configuration Only if it's active on the fail over node - if it's passive you don't need a second license. -Original Message-From: Srinagesh Battula [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle Licensing for a Clustered Server Configuration Hi, Does Oracle Corp. require you to buy the RDBMS license for the fail-over server (as well) in a 2-node cluster server environment? Thanks Nagesh
Help - Fail Safe ODBC not working
I've got a new install on a HP cluster (windows NT service pack 6) oracle 8.1.7 and failsafe 3.1.2, oracle odbc 8.1.7.4. Everything seems to work - database and cluster all failover. I can reconnect to the node after failover, but the odbc driver (with the enable retry option checked) doesn't keep the connection alive during the failover - I get 3113 end-of-file error - both from access and a foxpro front end, I have to stop and restart the app's and then everything connects up fine. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
long to clob scripts?
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX We are finally getting around to replacing all our long data types with clobs and blobs - anybody already have a script that does this?
Probelm with W2K large datafile creation
I finally got 8.1.7 installed on the new Dell P4, had to manually set the path and create a listener thru command line interface. When I tried to create a tablespace at 8G (one datafile) the process went away (went to lunch still nothing). Anyone know of a bug in this area. A 6G tablespace create worked fine, and I could create tablespace datafiles this size on P3 systems. Did a pentium 4 search on metalink and all I got was the patch stuff. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unable to allocate 4096 bytes of shared memory - HELP!!!!
It might be the bug. The Oracle bug number is 1397603. According to Oracle, the bug involves a memory leak in their internal caching mechanism. The workaround is to put the following line in the init.ora file, and then restart Oracle: _db_handles_cached = 0 This is supposed to disable the buggy caching mechanism. This bug is supposed to be fixed in patch set 8.1.7.2 -Original Message- Sent: Wednesday, July 11, 2001 6:41 AM To: Multiple recipients of list ORACLE-L We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as follows : It appears to be related to dbms_job Can any one help? John Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc: ORA-12012: error on auto execute of job 11223917 ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,SERVER _PRINTER_RESET,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 Sun Jul 8 23:52:14 2001 Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp1_19492_prtgh1.trc: ORA-12012: error on auto execute of job 11227622 ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,SERVER _RECEPTION,PL/SQL MPCODE,BAMIMA: Bam Buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 81714 aborted upgrade and core dumps on NT
Are you running the 8.1.7 sqlnet clients and odbc drivers. We did have some as yet unexplained errors connecting older versions to 8.1.7 - most notably with large objects. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 3:05 AM To: Multiple recipients of list ORACLE-L Hi, I have just had the experience of upgrading to 81714, discovering a problem in our application that did not show up in any testing and having to go back to 815. The 815 instance is on a different server to the 817 instance and we still have the 817 instance available for further troubleshooting. This is on NT4. With 817, we were getting ora-3113 in the forms application and in ODBC connections and also seeing ora-03121 as well. We got core dump files produced (under 817 they are produced on NT) but Oracle support does not seem to know how to interpret them on NT - has anyone had any experience with this? No mention of the core dump file was contained within the alert log and no files were produced in the user dump directory. When I turned sql trace on for the session running forms, the ora-3113 did not occur - has anyone seen behaviour like this where SQL Trace will cause an ora-3113 to stop occurring? All suggestions on what to look for or how to interpret NT core dumps are welcome. Thanks, Bruce Reardon [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Client Connection-SQLNET and?/or? ODBC.
Yes you need SQLNET. odbc uses sqlnet on the client. -Original Message- Sent: Tuesday, July 10, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Dear DBA Colleagues, Please pardon me if this question is a bit elementary, but this concerns applications connecting to Oracle. Most of our Oracle Apps are PowerBuilder-based such that we use the appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to SQLNET and the Oracle RDBMS on the server. A new application we are proposing to build is Web-based, with Browser clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold Fusion. This Linux machine will then act as a client, connecting to the Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5. On the Linux box, we will of course need to specify the Cold Fusion DLLs to allow connection to the Oracle 8i Database. But my issue is this: On the Linux machine running as the client, if we do ODBC, do we need to do SQLNET (Net 8) as well? I.E. What is it on the client that actually makes the connection to the SQLNET (Net 8) running on the server: - ODBC itselfor - ODBC through SQLNET? Thanks very much in advance! Jim Damiano Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Pentium 4 (gotta love wintel) install (attempt)
Trying to install 8.1.7 on a new P4 and it wouldn't. Scanned metalink and found the work arounds (no patches yet), and I still can't get it to install the listener (installed the database and client so I can use sqlplus just no listener). Any one have the secret of how this actually works? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pentium 4 (gotta love wintel) install (attempt)
There is a patch (of sorts) and I have applied it with minor success - the installer actually ran and I got the database in - still didn't get listener installed. No its not limited to the P4 1.4 since I have a 1.7. -Original Message- Sent: Tuesday, July 03, 2001 10:17 AM To: Multiple recipients of list ORACLE-L I believe that was a known bug, but only with the P4 1.4 gigahertz? I know there is a patch for it, I found it on metalink once. kK -Original Message- B Sent: Tuesday, July 03, 2001 10:25 AM To: Multiple recipients of list ORACLE-L Trying to install 8.1.7 on a new P4 and it wouldn't. Scanned metalink and found the work arounds (no patches yet), and I still can't get it to install the listener (installed the database and client so I can use sqlplus just no listener). Any one have the secret of how this actually works? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql question
I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/0110 03/03/011 03/04/010 03/05/010 03/06/018 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another NT question
Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that they can handle a large system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Digestive
The Macallan 12 year old Described by Paul Pacult, the renowned international whisky writer, in his book Kindred Spirits as: simply the best 12 Year Old single malt around, The Macallan has justly reaped such critical acclaim. The secret of The Macallan lies in defiant adherence to traditional methods and ingredients. The continued use of finest Golden Promise barley and the insistence on oak sherry casks from Spain are just two of the pre-requisites for perfection. -Original Message- Sent: Tuesday, June 12, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Glenmorangie 12 year old oh yum From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Digestive Date: Tue, 12 Jun 2001 12:53:43 -0800 On Tuesday 12 June 2001 12:33, Thater, William wrote: single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT ODBC HELP REQUIRED
Title: URGENT ODBC HELP REQUIRED
be
something like this (check for errors):
open
database data1LOCAL lcCursorName, lnreturnlcCursorName =
"SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID =
'oracleuser'gcSQLPassword = 'oraclepass'
gnConnHandle = SQLCONNECT(gcODBCDataSource,
gcSQLUserID, gcSQLPassword)IF gnConnHandle = 0=
mbox('Cannot make connection', 16, 'SQL Connect
Error')RETURNENDIFSET DATABASE TO
data1CREATE CONNECTIONmytest DATASOURCE
gcODBCDataSource USERID gcSQLUserID PASSWORD
gcSQLPasswordcreate sql view tmp remote connectionodbcname as
select * from tmp
DBSETPROP('TMP', "VIEW",
"MAXRECORDS", -1) DBSETPROP('TMP', "VIEW", "FETCHMEMO",
.T.)DBSETPROP('TMP', "VIEW", "FETCHSIZE",
50)USE
'tmp'CURSORSETPROP("KeyFieldList", 'prime_id)
CURSORSETPROP("Tables", 'tmp')
CURSORSETPROP("SendUpdates", .T.)
IF
!USED("real")USEreal IN 0 ALIAS realENDIFIF
!USED("tmp")USEtmp IN 0 ALIAS tmpENDIFSELECT
tmpSCANSELECTrealreplace all real.col with tmp.col
; for real.key =
tmp.keyENDSCAN
-Original Message-From: Arslan Dar
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 8:55
PMTo: Multiple recipients of list ORACLE-LSubject:
URGENT ODBC HELP REQUIRED
Hi dba's, I want
to communicate between Oracle 8 and Clipper.I want to get data from
Clipper/Foxpro Dbf file into oracle through ODBC.
can anybody guide me how to do that.
Any links, ?
TIA Arslan
RE: ODBC Connections Bad?
We have lots of clients who use odbc for ad hoc tools - access,excel, foxpro,vb ... While not quite as quick as a native tool they are ok for these applications, however they can be really bad, like any application, with poorly written queries (and what other kind do they ever write?). -Original Message- Sent: Thursday, May 10, 2001 2:07 PM To: Multiple recipients of list ORACLE-L I have been told in the past that ODBC connections to the database are slow and very resource intensive, but unfortunately this was not explained. Fortunately, I haven't really had to deal with ODBC connections much. However, in my new job, several users are using MS Access as their query tool and it looks like the number is growing. So, are ODBC connections to the database really slow and a resource problem? If so, why? Also, is there anything special in regards to the database that I should be watching or tuning outside of the norm just because I have a bunch of Access users hitting the database? Thanks again for the assistance! -w __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need oracle patch 8.1.7.1.1
I finally found it - ID:611940 Patchset::1711240 it's not returned in the initial patch download query page - you need to go to the new click here page to get the patch returned. -Original Message- Sent: Tuesday, May 08, 2001 10:46 AM To: Multiple recipients of list ORACLE-L I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ... could you provide the ID number and/or a working method to find the .1.1 patch for NT? The Oracle DBA wrote: I guess you are not on NT because the .1.1 patch is there. The std procedure for 817 is to install 817, patch it to .1.1 then .1.2. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 04 May 2001 10:31:23 Shaw, John B wrote: I just downloaded patch 8.1.7.1.2 from metalink - in the readme (yes I actually read it before installing ) it states that the earliest version that this patch may be applied to is 8.1.7.1.1 - I can't find this patch on metalink anybody know where I can get it? . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw Intergraph Public Safety mailstop LR24A4 [EMAIL PROTECTED] 256-730-8038 All the usual disclaimers and some of the certifications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need oracle patch 8.1.7.1.1
I just downloaded patch 8.1.7.1.2 from metalink - in the readme (yes I actually read it before installing ) it states that the earliest version that this patch may be applied to is 8.1.7.1.1 - I can't find this patch on metalink anybody know where I can get it? . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw Intergraph Public Safety mailstop LR24A4 [EMAIL PROTECTED] 256-730-8038 All the usual disclaimers and some of the certifications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - temp tablespace growing constantly
No but, when I turned it off it kept running out of space. -Original Message- Sent: Friday, April 27, 2001 4:33 PM To: Multiple recipients of list ORACLE-L Does the temp tablespace has it's autoextend turned off? [EMAIL PROTECTED] 04/27/01 04:55PM Under this situation try to offline temp tablespace and online it immediately. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 26 Apr 2001 13:05:26 -0800 I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly growing. It's initially set to 1G , then grows up to around 25G before I drop and recreate it. Called oracle support and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - temp tablespace growing constantly
The temp tablespace started at 1G and grew to 29G before croaking, we have the same software running on older oracle versions without incuring the temp creep. -Original Message- Sent: Monday, April 30, 2001 2:46 PM To: Multiple recipients of list ORACLE-L If you have the autoextend off, you might run out of space in your temp tablespace. If you have autoextend on, your temp file will keep growing. If you have a reasonably sized tablespace, you might want to look at the queries or index creations. How big is your entire database and how large is your temp tablespace. For example, we have a database of 35.3 gig and a temp tablespace of 1.5 gig and almost never run out of space. And when we do, it is almost always a bad select that is returning too much data. [EMAIL PROTECTED] 04/30/01 01:10PM No but, when I turned it off it kept running out of space. -Original Message- Sent: Friday, April 27, 2001 4:33 PM To: Multiple recipients of list ORACLE-L Does the temp tablespace has it's autoextend turned off? [EMAIL PROTECTED] 04/27/01 04:55PM Under this situation try to offline temp tablespace and online it immediately. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 26 Apr 2001 13:05:26 -0800 I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly growing. It's initially set to 1G , then grows up to around 25G before I drop and recreate it. Called oracle support and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Can you create a database link back to same database?
Can you create a database link back to same database? I have a product that uses database links to create a copy of the database, the users now want to copy it back to another schema on the same instance. I get ORA-02019: connection description for remote database not found or ORA-2082 Either I'm missing something in my syntax or this can't work - which is it? SQL create database link fr.is.inr.com@toad connect to test identified by test using 2 'fr.is.inr.com'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz
vented ski-doos, jet-skis, velcro, zippers, insulin, penicillin, zambonis, the telephone and short wave radios that save countless lives each year * We ALL have frozen our tongues to something metal and lived to tell about it. * BUT MOST IMPORTANT! * the handles on our beer cases are big enough to fit your hands with mitts on. ooh Canada!! Oh yeah... and our elections only take one day. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication - 8.1.6 to 8.1.7
I installed (NT) 8.1.7 on a secondary server and am trying to get replication going (master to updateable snapshot). OEM is not responding to any of the setup commands for the snapshot. Anybody know any secrets? I tried all this with an 8.1.6 to 8.1.6 and had no problems (other than stock market). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Java pools and 8i -- necessary?
I dropped mine to 1M and had export problems - support had me raise to 20M and export started working again (NT) -Original Message- Sent: Thursday, March 15, 2001 9:02 AM To: Multiple recipients of list ORACLE-L Hi, We've got an 8.1.6 DB running on HP/UX. I created a java pool because I didn't know if something in the 3rd party software would use Java code. Well, it doesn't. So, is there any reason to keep ANY java pool? It's at 30MB right now. I was gonna drop it to 5MB to be conservative, but if I don't need that, why take up the RAM. TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle and America
Not ICBM's - but they do control Patriot's. -Original Message- Sent: Monday, March 12, 2001 2:06 PM To: Multiple recipients of list ORACLE-L GRAANN! -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: oracle and America yes, but perhaps if they were within a polar circle, it would be ok for them to have control of a few Icy B.M.s? On 12 Mar 2001, at 11:07, Gogala, Mladen scribbled with alacrity and cogency: Date sent:Mon, 12 Mar 2001 11:07:02 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... Having Microsoft controlling the ICBMs would definitely be too close to disaster for my taste. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: COPY command dieing - help
I didn't - but now I have with the following result. * ERROR at line 1: ORA-00900: invalid SQL statement -Original Message- Sent: Friday, February 02, 2001 11:46 AM To: Multiple recipients of list ORACLE-L Did you try leaving off the semi colon? Like this, for instance: copy from v55/v55@int to user/pwd@frog create DMF - using select * from DMF@int / Notice that if you have several lines, you need to put a space and hyphen after each line except the last one. At least, that has been my experience. [EMAIL PROTECTED] 02/02/01 11:00AM On Thu, 1 Feb 2001, Shaw, John B wrote: I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables have come across successfully. One table is having a problem. The command: copy from v55/v55@int to user/pwd@frog create DMF using select * from DMF@int; This table gives ora-00911 error (invalid character ? where? - this same command worked on many other tables). I manually created the table in the local db and tried to do an append of the data copy from v55/v55@int to user/pwd@frog append DMF using select * from DMF@int; This causes sqlplus and sqlworksheet to die (this is on NT0 anybody have an idea of what's going on? Maybe a silly question, but do the databases use the same character set? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
COPY command dieing - help
I am attempting to copy a table from a 8.1.6 db to 8.1.7. Most of the tables have come across successfully. One table is having a problem. The command: copy from v55/v55@int to user/pwd@frog create DMF using select * from DMF@int; This table gives ora-00911 error (invalid character ? where? - this same command worked on many other tables). I manually created the table in the local db and tried to do an append of the data copy from v55/v55@int to user/pwd@frog append DMF using select * from DMF@int; This causes sqlplus and sqlworksheet to die (this is on NT0 anybody have an idea of what's going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
