Re:How to learn XML ?

[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 

Eriovaldo


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eriovaldo Andrietta
  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: 
  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

[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 {FROM database | TO database | FROM database TO database}
{APPEND|CREATE|INSERT|REPLACE} destination_table
[(column, column, column, ...)] USING query

and the example

SQL> COPY FROM SCOTT/TIGER@HQ -
> CREATE SALESMEN (EMPNO,SALESMAN) -
> USING SELECT EMPNO, ENAME FROM EMP -
> WHERE JOB='SALESMAN'
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: converting fmt to fmb

[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 PadhiSent: 
  Monday, July 08, 2002 5:48 PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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=scott/tiger 
  batch=YES parse=YES 
  rgds amar http://amzone.netfirms.com 

Re: insert nologging parallel/noparallel and archiving - thanks

[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. 



__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  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

[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 around for a lng time
> from the 8.1.7 docs
> 
> COPY {FROM database | TO database | FROM database TO database}
> {APPEND|CREATE|INSERT|REPLACE} destination_table
> [(column, column, column, ...)] USING query
> 
> and the example
> 
> SQL> COPY FROM SCOTT/TIGER@HQ -
> > CREATE SALESMEN (EMPNO,SALESMAN) -
> > USING SELECT EMPNO, ENAME FROM EMP -
> > WHERE JOB='SALESMAN'
> 
> if you are copying within the same database you can leave out the
> from/to clause. If you are logged onto one of the two databases, you
> can leave out the from or to clause
> 
> 
> --- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> > I checked the docs for 8.1.6 and 9.0.1.
> > I think that the copy command is new in 9i.
> > make sure that you are logged on to 9i sqlplus when you issue this
> > command.
> > 
> > Yechiel Adar
> > Mehish
> >   - Original Message - 
> >   From: Ramon E. Estevez 
> >   To: Multiple recipients of list ORACLE-L 
> >   Sent: Friday, July 05, 2002 10:08 PM
> >   Subject: Copy
> > 
> > 
> >   Hi list,
> >
> >   I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB
> > 8.1.7 on NT using this statement
> >
> >   COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING SELECT
> > * FROM DATOS_BALANCES;
> >
> >   ERROR at line 1:
> >   ORA-00900: invalid SQL statement
> >
> >   Do I need a DBLINK, if yes, is it obligatory ?
> >
> >   TIA,
> >
> >
> >   Ramon E. Estevez
> >   [EMAIL PROTECTED]
> >   809-565-3121
> > 
> 
> 
> __
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.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: Ramon E. Estevez
  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: Exporting stats for a production server to a dev/test server

[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 true for your version and setup.

We did not delete the stats before doing the new, what
we did was this:

1) export the old stats
2) analyze using a new sample, cascade, with histos
3) export the new stats (with a new label)
4) test, reimport the old and new stats as necessary

Do this quick test to show yourself what it can do:

a) create table tester.statstest as select * from
dba_tables;
b) create index tester.statstestidx on
statstest(table_name);
c) analyze table tester.statstest estimate statistics
sample 1 percent for table for all indexes for all
columns size 254;
d) create the stats holding table in the tester schema
using
DBMS_STATS.CREATE_STAT_TABLE('tester','stats','tsuser01')
e) export the stats using
DBMS_STATS.EXPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null);
f) select * from tester.stats to see what is stored
g) analyze table tester.statstest delete statistics;
h) import the stats using
DBMS_STATS.IMPORT_TABLE_STATS('tester','statstest',null,'stats','1pcttest',true,null);
i) select * from dba_tables, dba_indexes,
dba_tab_histograms to see what was imported

You can store multiple versions of stats for the same
table with different lables ('1pctest' in the example)
but if you try to store stats with the same label it
will overwrite.

We did have some data dictionary locking issues trying
to import multiple partitions of the same table at the
same time, but our db has suspect dd issues anyway, so
this might just be a feature of our system.

hth,

Jack

--- [EMAIL PROTECTED] wrote:
> 
> 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 using the
> delete option of ANALYZE command before gathering
> new statistics using
> DBMS_STATS?
> 
> Thanks,
> 
> Cherie Machler
> Oracle DBA
> Gelco Information Network
> 
> 
> 
> 
>
> Jack Silvey 
> 
>
>  Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]> 
> ahoo.com>cc:
> 
>
> Sent by: Subject:   
>  Re: Exporting stats for a production server to a
> dev/test  
> [EMAIL PROTECTED]server
> 
>
> om  
> 
>
> 
> 
>
> 
> 
>
> 07/07/02 08:58  
> 
>
> PM  
> 
>
> Please respond  
> 
>
> to ORACLE-L 
> 
>
> 
> 
>
> 
> 
>
> 
> 
> 
> 
> We just used it with great success to test our new
> analyze strategy. You can label each set of stats,
> and
> quickly switch between different analyze levels.
> Store
> your old stats first and you can always fall back if
> necessary.
> 
> 
> Jack
> 
> 
> --- [EMAIL PROTECTED] wrote:
> > Hi
> >
> > Can anyone give feedback good or bad on the
> > dbms_stats feature of
> > exporting statistics. Is there any gotcha's or
> does
> > it work well
> >
> > Cheers
> >
> >
> > --
> > =
> > Peter McLarty   E-mail:
> > [EMAIL PROTECTED]
> > Technical ConsultantWWW:
> > http://www.mincom.com
> > APAC Technical Services Phone: +61 (0)7 3303
> > 3461
> > Brisbane,  AustraliaMobile: +61 (0)402 094
> > 238
> > Facsimile: +61 (0)7
> 3303
> > 3048
> > 

Re: Copy

[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: Copy
  
  I checked the docs for 8.1.6 and 
  9.0.1.
  I think that the copy command is new in 9i.
  make sure that you are logged on to 9i sqlplus when you 
  issue this command.
   
  Yechiel AdarMehish
  
- Original Message - 
From: 
Ramon E. Estevez 
To: Multiple recipients of list ORACLE-L 

Sent: Friday, July 05, 2002 10:08 
PM
Subject: Copy

Hi list,
 
I am trying to copy one table from a DB 9.0.1 on Linux RH 
to a DB 8.1.7 on NT using this statement
 
COPY FROM RAMON@ORLNX TO 
RAMON@IBOR CREATE DATBAL_TMP USING SELECT * 
FROM DATOS_BALANCES;
 
ERROR at line 1:ORA-00900: invalid SQL 
statement
 
Do I need a DBLINK, if yes, is it obligatory 
?
 
TIA,
 
 
Ramon E. Estevez[EMAIL PROTECTED]809-565-3121

RE: converting fmt to fmb

[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 ESPN Inc. 
QOTD: Any clod can have facts, but 
having an opinion is an art!

  -Original Message-From: Amar Kumar Padhi 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 08, 2002 9:48 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  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=scott/tiger 
  batch=YES parse=YES 
  rgds amar http://amzone.netfirms.com 


*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Re: C++ classes

[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: http://www.roguewave.com/products/sourcepro/db/
>
>Waleed
>
>-Original Message-
>To: Multiple recipients of list ORACLE-L
>Sent: 7/7/02 10:28 AM
>
>Hi,
>
>   Is there any reliable C++ class library to access
>Oracle DB
>
>Vishal
>_
>There is always a better job for you at Monsterindia.com.
>Go now http://monsterindia.rediff.com/jobs
>
>  
>

-- 

/regards

Peter Gram

Mobil : +45 2527 7107
Fax   : +45 4466 8856
Home  : +45 3874 5696

Miracle A/S
Kratvej 2
2760 Måløv
http://miracleas.dk

/*
The process of preparing programs for a digital computer is especially
attractive, not only because it can be economically and scientifically
rewarding, but also because it can be an aesthetic experience much like 
composing poetry or music

Donald Knuth
*/ 





smime.p7s
Description: application/pkcs7-signature

RE: 2003 IOUG Meeting

[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.


Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Friday, July 05, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: 2003 IOUG Meeting

May I also add that you can also get to meet some of the luminaries in this
list at IOUG (Gaja, Tim, Cary, Rachel are regulars) and have a lot of
one-on-one as well as panel discussions that take up real-life issues (as
opposed to marketing fluff).
 
John Kanagaraj

-Original Message-
Sent: Friday, July 05, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


Add to that the cost of getting there (Orlando FL for 2003), 
transportation to/from the airport
hotel (4-6 nights at around $200/night depending on what hotel you stay at)
some meals (lunch is usually provided, some evening events include enough
food for dinner)
 
That said, I hope that doesn't scare your company off.  IMHO, this is the
best investment you can make in your DBA's.  (I can't speak for developers.)
Both years I've gone, I was frustrated because there were more sessions that
I wanted to attend that I could since they were at the same time.  This
year, there were no sessions that I attended that I didn't learn something
from.  Many of the sessions generated a list of "to do as soon as I get back
to the office".  
 
Hope to see you there.
 
Stephen

>>> [EMAIL PROTECTED] 07/05/02 10:13AM >>>
Believe me.  It is not free.  Attendee fees are around $ 1,200.00 but that
is an estimate.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct:(248) 865-4350
Mobile:(248) 408-2918
Email:[EMAIL PROTECTED]
Web:www.compuware.com  

-Original Message-
Sent:Friday, July 05, 2002 12:49 PM
To:Multiple recipients of list ORACLE-L

Thanks! I should have mentioned I have checked the IOUG page, but can not
find
the actual cost of attending. Or is it FREE to IOUG members, and therefore,
I
need to have my company pay for memberships for a couple of people to
attend?

thanks!
Angel Tirone (an oracle newbie)


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  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).

converting fmt to fmb

[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=scott/tiger batch=YES parse=YES 




rgds
amar
http://amzone.netfirms.com

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

[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 using the
delete option of ANALYZE command before gathering new statistics using
DBMS_STATS?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Jack Silvey
  
 
ahoo.com>cc:   
  
Sent by: Subject: Re: Exporting stats for a 
production server to a dev/test  
[EMAIL PROTECTED]server   
  
om 
  
   
  
   
  
07/07/02 08:58 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




We just used it with great success to test our new
analyze strategy. You can label each set of stats, and
quickly switch between different analyze levels. Store
your old stats first and you can always fall back if
necessary.


Jack


--- [EMAIL PROTECTED] wrote:
> Hi
>
> Can anyone give feedback good or bad on the
> dbms_stats feature of
> exporting statistics. Is there any gotcha's or does
> it work well
>
> Cheers
>
>
> --
> =
> Peter McLarty   E-mail:
> [EMAIL PROTECTED]
> Technical ConsultantWWW:
> http://www.mincom.com
> APAC Technical Services Phone: +61 (0)7 3303
> 3461
> Brisbane,  AustraliaMobile: +61 (0)402 094
> 238
> Facsimile: +61 (0)7 3303
> 3048
> =
> A great pleasure in life is doing what people say
> you cannot do.
>
> - Walter Bagehot (1826-1877 British Economist)
> =
> Mincom "The People, The Experience, The Vision"
>
> =
>
> This transmission is for the intended addressee only
> and is confidential
> information. If you have received this transmission
> in error, please
> delete it and notify the sender. The contents of
> this e-mail are the
> opinion of the writer only and are not endorsed by
> the Mincom Group of
> companies unless expressly stated otherwise.
>
>
> --
> 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).


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack Silvey
  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 informatio

copy command

[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: http://www.orafaq.com
-- 
Author: Sackwitz, Antje
  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).

How to administer OAS at server without using Browser ?

[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: 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).

RE: DB_FILE_NAME_CONVERT issue

[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 the standby.

 Oracle suggest that should cover most of your files and the other can be
renamed using alter database rename file syntax

HTH

John
-Original Message-
Sent: 08 July 2002 10:48
To: Multiple recipients of list ORACLE-L


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 them
2.b. let oracle know where is your initstandby.ora
3. alter database create standby controlfile as 'standbycontrol.ctl';
3. startup nomount pfile = where is your initstandby.ora
4. alter database mount standby database;
5. recover standby database;  <- this will apply daily archived log,
make sure your standby up to date.
6. shutdown; <- never open this database 

The problem is I don't know how to let Oracle know that my production
datafile paths are more than one.
I think Oracle 9i can do that with DB_FILE_NAME_CONVERT (para1, para2,
para3, para4).

I Don't think is very funny if I have to rename all my production data files
before I create standby control file. :(


Thanks

Sinardy



-Original Message-
Sent: 08 July 2002 16:03
To: Multiple recipients of list ORACLE-L


Hi,


I don't know the syntax you are looking for but you could explicitly rename
every file in your RMAN script (set newname for datafile command)


Jack


 

  "Sinardy Xing"

 
  omsvc.com>   cc:   (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE:
DB_FILE_NAME_CONVERT issue
  [EMAIL PROTECTED]

 

 

  08-07-2002 09:28

  Please respond to

  ORACLE-L

 

 




Hi guys,

Anyone that work in ASIA time please help me : )

Sinardy

-Original Message-
Sent: 08 July 2002 12:58
To: Multiple recipients of list ORACLE-L


Hi guys,

I try to create standby database and my datafile are all over my hard disk,
what should I do to my DB_FILE_NAME_CONVERT to let my standby database know
this issue ?

example

/prod_data1/system01.dbf
/prod_data2/user01.dbf
/prod_data3/rbs01.dbf

my standby datafile

/standby_data1/system01.dbf
/standby_data1/user01.dbf
/standby_data2/rbs01.dbf


I try this idiot way but there are no such parameters in v$parameter  :+)

DB_FILE_NAME_CONVERT1 = (/prod_data1, /standby_data1)
DB_FILE_NAME_CONVERT2 = (/prod_data2, /standby_data1)
DB_FILE_NAME_CONVERT3 = (/prod_data3, /standby_data2)


Thanks so much.

Oh by the way I am using 8i


Sinardy

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
  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: Sinardy Xing
  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).



===
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet 

Dynamically preventing use of index

[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 index on that column only for which the value is provided and avoid use of the other column index. Is this possible in a select stmt in RBO?

Oracle uses both the indexes by default, irrespective of the values provided.


Select col1, col2 
from   am49
where col1 = var1 
or   col2 = var2;


The above query should use the index on col1 only when var1 is provided and vice versa.


On Oracle 8.1.7 (RBO)


rgds
amar
http://amzone.netfirms.com

Oracle 9.2 and Solaris 9

[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 matter as usual.

I know that the two products are both really new, but I'm 
now in a lucky condition, with 2 brand new machines
to install from scratch (fire280) and some time
for the migration from 8.1.7, no critical apps dependent
on the Oracle version, so I'm thinking to configure
the two machines with the latest versions available,
both OS and Oracle.
On the other hand we need Oracle 9i for the Spatial
option that seems to be really improved on 9i.

Thanks for any info,


Carlo 

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Carlo Antoniotti   -   Land Management Unit
Institute for Environment and Sustainability (IES)
EC - Joint Research Centre
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carlo Antoniotti
  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).

AW: JDBC

[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 procedures. That means that you just have 
to write wrappers for your T-SQL blocks (put them into PL/SQL stored procs).
Done that, you can communicate from Java with the procedure through the OUT 
parameter, once you registered the proc with it's OUT parameters within the 
Java context. After binding the parameter to Java variables, the data will 
be transferred to those variables (when the proc is executed) for your
further 
use within the Java context. Nothing new, actually. A problem might be the 
syntactical difference between T-SQL and PL/SQL, eventhough Oracle is able 
to handle more of the syntax you encounter in T-SQL like CASE or ANSI SQL
joins.

Hope that helps a little bit. If not, pipe it to /dev/null ;)

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto:[EMAIL PROTECTED]

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Behalten Sie den Ueberblick - mit dem neuen BasicOverView, unserer
Seminaruebersicht fuer das 2. Halbjahr 2002. Sie haben noch kein Exemplar?
Schreiben Sie eine E-Mail an mailto:[EMAIL PROTECTED] oder rufen Sie uns
an unter 0 18 03 / 73 64 62 73!

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter
fremden Namen  erstellt oder manipuliert werden. Aus diesem Grunde bitten
wir um Verstaendnis dafuer, dass  wir zu Ihrem und unserem Schutz die
rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask for
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.


-Ursprüngliche Nachricht-
Von: Sackwitz, Antje [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 5. Juli 2002 17:13
An: Multiple recipients of list ORACLE-L
Betreff: JDBC


Hi, gurus,
collegues of mine told me, that Sybase can return information from anonymous
blocks.
When I do not want to use SQLJ, but only JDBC what is the best way to
migrate the Sybase code to Oracle.
Any tips appreciated,
Regards,
Antje Sackwitz


  Antje Sackwitz
  ppi Media GmbH
  Deliusstraße 10
  D-24114 Kiel
  phone +49 (0) 43 1-53 53-2 16
  fax   +49 (0) 43 1-53 53-2 22
  email mailto:[EMAIL PROTECTED]
  web   www.ppi.de




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sackwitz, Antje
  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: Stefan Jahnke
  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).

Comparison between Oracle 8 and Oracle 9

[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, where  I can get some documents about the comparison of these two databases? Thank you for your help.

Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]

RE: DB_FILE_NAME_CONVERT issue

[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 them
2.b. let oracle know where is your initstandby.ora
3. alter database create standby controlfile as 'standbycontrol.ctl';
3. startup nomount pfile = where is your initstandby.ora
4. alter database mount standby database;
5. recover standby database;  <- this will apply daily archived log, make sure 
your standby up to date.
6. shutdown; <- never open this database 

The problem is I don't know how to let Oracle know that my production datafile paths 
are more than one.
I think Oracle 9i can do that with DB_FILE_NAME_CONVERT (para1, para2, para3, para4).

I Don't think is very funny if I have to rename all my production data files before I 
create standby control file. :(


Thanks

Sinardy



-Original Message-
Sent: 08 July 2002 16:03
To: Multiple recipients of list ORACLE-L


Hi,


I don't know the syntax you are looking for but you could explicitly rename
every file in your RMAN script (set newname for datafile command)


Jack


   

  "Sinardy Xing"   

 
  omsvc.com>   cc:   (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)
  Sent by: Subject:  RE: DB_FILE_NAME_CONVERT 
issue
  [EMAIL PROTECTED] 

   

   

  08-07-2002 09:28 

  Please respond to

  ORACLE-L 

   

   




Hi guys,

Anyone that work in ASIA time please help me : )

Sinardy

-Original Message-
Sent: 08 July 2002 12:58
To: Multiple recipients of list ORACLE-L


Hi guys,

I try to create standby database and my datafile are all over my hard disk,
what should I do to my DB_FILE_NAME_CONVERT to let my standby database know
this issue ?

example

/prod_data1/system01.dbf
/prod_data2/user01.dbf
/prod_data3/rbs01.dbf

my standby datafile

/standby_data1/system01.dbf
/standby_data1/user01.dbf
/standby_data2/rbs01.dbf


I try this idiot way but there are no such parameters in v$parameter  :+)

DB_FILE_NAME_CONVERT1 = (/prod_data1, /standby_data1)
DB_FILE_NAME_CONVERT2 = (/prod_data2, /standby_data1)
DB_FILE_NAME_CONVERT3 = (/prod_data3, /standby_data2)


Thanks so much.

Oh by the way I am using 8i


Sinardy

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
  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: Sinardy Xing
  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 fr

RE: Hints being ignored

[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% correct. I was busy so I jut deleted records I didnt need but I
will go back and try again later. On the whole though using 8.1.6 Ive
remember situations where hints have not taken.


-- 
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).