Re:How to learn XML ?

2002-07-08 Thread dgoulet
TRY: http://www.w3schools.com/xml/ Dick Goulet Reply Separator Author: "Eriovaldo Andrietta" <[EMAIL PROTECTED]> Date: 7/7/2002 12:38 PM Hi friends : How can i do for learn XML ? Does anyone know some good site that teaches it for us ? Regards

RE: Copy

2002-07-08 Thread Hand, Michael T
Also, as the example points out, make sure you use the hyphen at the end of line if your command spans more than 1 line. -Original Message- Sent: Sunday, July 07, 2002 9:23 AM To: Multiple recipients of list ORACLE-L copy has been around for a lng time from the 8.1.7 docs COPY {FRO

RE: converting fmt to fmb

2002-07-08 Thread Amjad
Title: converting fmt to fmb Hi Amar,   use the following to convert ur files   ifcmp60 along with the various parameters that u want to pass   regards, Ams. www.medicomsoft.com   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Amar Kumar

Re: insert nologging parallel/noparallel and archiving - thanks

2002-07-08 Thread Gurelei
Just wanted to thank Jack, Connor and Jared for their help!! Gene --- Jack Silvey <[EMAIL PROTECTED]> wrote: > sorry, meant insert as select, not insert as append > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > Gene, > > > > This sounds right. ___

Re: Copy

2002-07-08 Thread Ramon E. Estevez
Rachel, Joe, Anjo and for all that reply, The only way it worked for me was using a dblink. As always tks for your comentaries !!! Tks Ramon - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 07, 2002 8:23 AM > copy has been aroun

Re: Exporting stats for a production server to a dev/test server

2002-07-08 Thread Jack Silvey
Cherie, Great name. Our initial stats were generated with the ANALYZE command. We did export all the stats with the dbms_stats - one parameter of the GATHER_TABLE_STATS procedure is CASCADE, which picks up the index and column stats too. Please test first on your own system to make sure this is

Re: Copy

2002-07-08 Thread Ramon E. Estevez
Yechiel,   No, it is available at 8.1.7 also, it worked through a dblink.  I thought it will do it thru the local tnsnames.   tks   Ramon   - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, July 07, 2002 7:33 AM Subject

RE: converting fmt to fmb

2002-07-08 Thread Jamadagni, Rajendra
Title: converting fmt to fmb Same way, just the executable name has changed.   Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of E

Re: C++ classes

2002-07-08 Thread Peter Gram
Waleed In version 9i there is very neat C++ classes for OCI to be able to access Oracle. Have a look at Oracle C++ Call Interface Programmer's Guide ( http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/a89860/toc.htm ). If you Khedr, Waleed wrote: >Check this: ht

RE: 2003 IOUG Meeting

2002-07-08 Thread Karniotis, Stephen
Everyone: This is great!! Please pass the word on about IOUG-Live! Any help with marketing this extremely valuable event is greatly appreciated. Besides the one on one events, you can experience what others have called "DBA Frenzy". Lots of people with varied opinions but lots of expertise.

converting fmt to fmb

2002-07-08 Thread Amar Kumar Padhi
Title: converting fmt to fmb Hi, may be a bit off topic. How can I convert my forms 6i FMT files to FMB files, from command line. In forms 4.5 this was feasible by using the following command, but I am unable to locate the command line option for Forms 6i. f45gen32 module=sync userid=s

Re: Exporting stats for a production server to a dev/test server

2002-07-08 Thread Cherie_Machler
Jack, Were your old statistics generated with the ANALYZE command? If yes, were you able to export ALL of the old statistics with the export option of DBMS_STATS before you actually analyzed with DBMS_STATS for the first time? If yes, after exporting them, did you delete the old statistics usi

copy command

2002-07-08 Thread Sackwitz, Antje
Notice taht there are limits to the copy command COPY The COPY command is not being enhanced to handle datatypes or features introduced with, or after Oracle8. The COPY command is likely to be made obsolete in a future release. Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ: h

How to administer OAS at server without using Browser ?

2002-07-08 Thread arul . kumar
Hi DBAs, I would like to know the ways we can manage OAS ( ver. 4.0.8 ) without using Browser. For example, how do we create DADs without using browser admin utility. Is there any Oracle utility available to use at OS prompt? Possible ? Thanks, Arul. -- Please see the official ORACLE-L FAQ: htt

RE: DB_FILE_NAME_CONVERT issue

2002-07-08 Thread John . Hallas
If you have a proper OFA setup then the problem is not to big. The syntax is db_file_name_convert=('/vobs/oracle/dbs','/fs2/oracle/stdby') log_file_name_convert=('/vobs/oracle/dbs','/fs2/oracle/stdby') where you are changing files that are in /vobs/oracle/dbs on prod to /fs2/oracle/stdby/ on for

Dynamically preventing use of index

2002-07-08 Thread Amar Kumar Padhi
Title: Dynamically preventing use of index Hi, I have a table with two column, each having  non-unique index. The following select is used to fetch records. The variables ‘var1’ and ‘var2’ are provided for execution. Only one of the two variables is provided. The requirement is to use the ind

Oracle 9.2 and Solaris 9

2002-07-08 Thread Carlo Antoniotti
Dear DBAs, anybody out there have experience/knowledge about the compatibility between Oracle 9.2 and Solaris 9 ? On the Metalink site the server certification matrix say "projected" and I'm confident that this will turn into "Certified" quite soon, but the direct experience it's a different ma

AW: JDBC

2002-07-08 Thread Stefan Jahnke
Hi Antje Eventhough I never migrated Sybase (or SQL Server) code (JDBC/Java) to Oracle, maybe that helps anyway: In Transact SQL, you can actually return data from an anonymous block, that's correct. An equivalent to do this in PL/SQL might be the use of OUT parameters within stored procedure

Comparison between Oracle 8 and Oracle 9

2002-07-08 Thread emre . hancioglu
Hi everybody, Currently we are using Oracle 8.1.7 in our company and for a new datawarehouse project, a consultant company has suggested us to use Oracle 9. The have claimed that applications run much faster and it's more reliable etc... Of course I was not convinced. Could you please tell me, whe

RE: DB_FILE_NAME_CONVERT issue

2002-07-08 Thread Sinardy Xing
Hi, I am not using RMAN, This is what I try to do. I try to create standby database manually 1. Copy all datafiles to new location (so call standby location) 2. create initstandby.ora ("almost" the same with the production) 2.a. DB_FILE_NAME_CONVERT = (production path, standby path) is one of t

RE: Hints being ignored

2002-07-08 Thread rabbit
I'm on 8.1.6 and the other day I was trying to use a hint on the GL_INTERFACE table from Oracle Financials (i know OF is rule based)that I had copied to another database instance and I couldnt get a hint to work. And i know that Hint is not SQL supported and therefore the syntax has to be 100% cor

<    1   2