Re: Oracle Applications Development Database Refresh

[jared . still]

Thanks John!

I *think* this is 10.7 character.  

I don't believe it  is NCA ( isn't that the Java Workstation version?
You know, the one at Open World that never worked?  ;)

How would I identify Smart Client?

Thanks,

Jared

On Friday 05 July 2002 17:03, John Kanagaraj wrote:
> Jared,
>
> > In addition to the usual SAP system that runs most of our
> > company, we have
> > Oracle Apps 10.7 HR.  For some reason the HR folks didn't
> > like the SAP HR
> > module, so I have SAP and Oracle Apps.
> >
> > The problem is a request I have to refresh the Dev database from the
> > Production database.
>
> I haven't read any official documentation for 10.7 'cloning' (as the
> Apps-aware call it). However, it is pretty simple compared to 11.0 and 11i
> if this is NOT 10.7 NCA. In addition, this also changes if you are using
> 10.7 Character, 10.7 SC (Smart Client) or 10.7 NCA, so do let us know. In
> simple terms, you will have to do the following (assuming you have a copy -
> hot or cold - of the DB):
>
> On the Application/Database server side:
>
> 1. Copy over the APPL_TOP/Custom top (basically all owned by 'applmgr') and
> Database files to the respective locations. Adjust the environment
> variables for log/TOP locations including APPLCSF (conc. program output
> logs) and any Custom tops. I assume you already have ORACLE_HOME copied
> over and setup (with envs, etc.) - this does not change frequently.
>
> 2. Change the listener ports for the database, FNDFS listener and OEORPC
> listener if required.
>
> 3. Startup the Database and listeners - recover to a point in time if from
> a hot backup. Do NOT startup the Concurrent Managers yet. Delete _ANY_
> DBlinks that point to other production systems - this may cause some
> Invalid objects, and you may have to ignore/fix them as the case may be.
>
> 4. Change the global name (alter database rename global_name ..)
>
> 5. Reset all Alerts from 'Enabled' to 'Disabled'. This can be achieved
> either from the Alerts form or using the following SQL (unless you want to
> do this off the Alerts screen!):
>
> update applsys. alr_alerts set enabled_flag = 'N' where enabled_flag = 'Y';
> This will disable all alerts and avoid erroneous messages to
> Users/Functional folks.
>
> 6. Update all pending jobs to reset copies to print. This is to avoid
> double-printing when you (or someone else) turn on some of the Concurrent
> jobs back on - at least you can avoid confusion from double-printing of
> reports. This can be done using the following SQL:
>
> UPDATE APPS.FND_CONCURRENT_REQUESTS
> SET NUMBER_OF_COPIES = 0;
>
> 7. Startup your forms interface (not the Concurrent Manager) and go to the
> Profiles screen (or the Profile->System form). Modify profile options:
> Query OE: Transaction Manager - change to the OEORPC listener name
> Query Site Name - change to the right name (this changes the Help->About
> information in forms)
>
> 8. Change the APPS/APPLSYS and other schema passwords. Open a SQL*Plus
> using 'SYSTEM' or a DBA account in a separate window. Open the
> 'Security->ORACLE->Register' (Oracle Users) screen. Enter the Password
> twice for each of APPLSYS, APPS and schemas and Commit, making sure that
> you change the corresponding Oracle user (APPLSYS/APPS/Schema) as you
> change them. It is critical to commit this, and make sure that this does
> not break inbetween - as the APPLSYS/APPS password combination needs to be
> correct and match in both the internal FND tables as well as the SYS.USER$
> tables... You may also have to reset the SYSADMIN passwords.
>
> 9. I would also cancel all pending concurrent jobs before starting up the
> Concurrent Manager, but that is something that you will need to agree with
> the functional folks. If this is Ok, you can use the following SQL:
> update apps.fnd_concurrent_requests
> set phase_code = 'C',
> status_code = 'D'
> where phase_code = 'P';
>
> 10. Startup the Concurrent Managers (using 'applmgr' account!) and watch
> the logs in $APPLCSF/log/*.mgr for any problems/issues.
>
> 11. You may also choose to resize the Queue sizes on the Dev instance. This
> reduces the number of processes that start up from the CM. This can be done
> from the 'Concurrent Managers' screen (Concurrent->Manager->Define) - click
> on the 'Work Shifts' button and change the value in 'Processes'. The
> Internal Manager will reduce this number at the next cycle.
>
> Depending on your customizations and environment, you may have to perform
> some additional steps. I have not included the steps for the Client side :
> I will have to know what you use and can suggest what needs to be done.
> This is off some of our internal documentation - I have given you the
> essentials that should make sense in a general Apps installation.
>
> Hth,
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> Want to know about a carpenter who built a bridge with two sticks and three
> nails? Write me for details!
>
> ** The opinions and statement

RE: 2003 IOUG Meeting

[Rachel Carmichael]

I NEVER get to see every presentation I want to see there. For my
money, IOUG is the BEST conference around and more than worth the money

Rachel
--- Stephen Andert <[EMAIL PROTECTED]> wrote:
> 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)
> 
> "Karniotis, Stephen" wrote:
> 
> > Angel:
> >
> >The 2003 IOUG Live! Conference is being conducted between the
> Dolphin
> and
> > the Swan Hotels in Orlando, FL from April 27th 2003 - May 1st,
> 2003. 
> Both
> > of these hotels are on Disney property.  Based on past experience
> with
> these
> > events, the price of the registration fee should be approximately
> the
> same
> > as this year.
> >
> > Stephen Karniotis
> > DBA Focus Area Manager
> > IOUG Live!
> >
> >  -Original Message-
> > Sent:   Friday, July 05, 2002 11:44 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:2003 IOUG Meeting
> >
> > Hello!
> >
> > I am developing cost estimates for my company to possibly send a
> couple
> > of people to next year's IOUG meeting. Can some one tell me where
> it
> > will be, when it is, and the cost to attend?
> >
> > TIA
> > --
> > Angel Tirone
> > Information Architecture   email:
> [EMAIL PROTECTED]
> 
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> > --
> > Author: Angel Tirone
> >   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).
> 
> --
> Angel TironePhone: (703) 833-5181
> Information Architecture   email: [EMAIL PROTECTED] 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Angel Tirone
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> ---

RE: Oracle Applications Development Database Refresh

[John Kanagaraj]

Jared,

> In addition to the usual SAP system that runs most of our 
> company, we have
> Oracle Apps 10.7 HR.  For some reason the HR folks didn't 
> like the SAP HR
> module, so I have SAP and Oracle Apps.
> 
> The problem is a request I have to refresh the Dev database from the 
> Production database.
 
I haven't read any official documentation for 10.7 'cloning' (as the
Apps-aware call it). However, it is pretty simple compared to 11.0 and 11i
if this is NOT 10.7 NCA. In addition, this also changes if you are using
10.7 Character, 10.7 SC (Smart Client) or 10.7 NCA, so do let us know. In
simple terms, you will have to do the following (assuming you have a copy -
hot or cold - of the DB):

On the Application/Database server side:

1. Copy over the APPL_TOP/Custom top (basically all owned by 'applmgr') and
Database files to the respective locations. Adjust the environment variables
for log/TOP locations including APPLCSF (conc. program output logs) and any
Custom tops. I assume you already have ORACLE_HOME copied over and setup
(with envs, etc.) - this does not change frequently.

2. Change the listener ports for the database, FNDFS listener and OEORPC
listener if required.

3. Startup the Database and listeners - recover to a point in time if from a
hot backup. Do NOT startup the Concurrent Managers yet. Delete _ANY_ DBlinks
that point to other production systems - this may cause some Invalid
objects, and you may have to ignore/fix them as the case may be.

4. Change the global name (alter database rename global_name ..)

5. Reset all Alerts from 'Enabled' to 'Disabled'. This can be achieved
either from the Alerts form or using the following SQL (unless you want to
do this off the Alerts screen!):

update applsys. alr_alerts set enabled_flag = 'N' where enabled_flag = 'Y';
This will disable all alerts and avoid erroneous messages to
Users/Functional folks.

6. Update all pending jobs to reset copies to print. This is to avoid
double-printing when you (or someone else) turn on some of the Concurrent
jobs back on - at least you can avoid confusion from double-printing of
reports. This can be done using the following SQL:

UPDATE APPS.FND_CONCURRENT_REQUESTS 
SET NUMBER_OF_COPIES = 0;

7. Startup your forms interface (not the Concurrent Manager) and go to the
Profiles screen (or the Profile->System form). Modify profile options:
Query OE: Transaction Manager - change to the OEORPC listener name
Query Site Name - change to the right name (this changes the Help->About
information in forms)

8. Change the APPS/APPLSYS and other schema passwords. Open a SQL*Plus using
'SYSTEM' or a DBA account in a separate window. Open the
'Security->ORACLE->Register' (Oracle Users) screen. Enter the Password twice
for each of APPLSYS, APPS and schemas and Commit, making sure that you
change the corresponding Oracle user (APPLSYS/APPS/Schema) as you change
them. It is critical to commit this, and make sure that this does not break
inbetween - as the APPLSYS/APPS password combination needs to be correct and
match in both the internal FND tables as well as the SYS.USER$ tables... You
may also have to reset the SYSADMIN passwords.

9. I would also cancel all pending concurrent jobs before starting up the
Concurrent Manager, but that is something that you will need to agree with
the functional folks. If this is Ok, you can use the following SQL:
update apps.fnd_concurrent_requests 
set phase_code = 'C',
status_code = 'D' 
where phase_code = 'P'; 

10. Startup the Concurrent Managers (using 'applmgr' account!) and watch the
logs in $APPLCSF/log/*.mgr for any problems/issues.

11. You may also choose to resize the Queue sizes on the Dev instance. This
reduces the number of processes that start up from the CM. This can be done
from the 'Concurrent Managers' screen (Concurrent->Manager->Define) - click
on the 'Work Shifts' button and change the value in 'Processes'. The
Internal Manager will reduce this number at the next cycle.

Depending on your customizations and environment, you may have to perform
some additional steps. I have not included the steps for the Client side : I
will have to know what you use and can suggest what needs to be done. This
is off some of our internal documentation - I have given you the essentials
that should make sense in a general Apps installation.

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Want to know about a carpenter who built a bridge with two sticks and three
nails? Write me for details!

** The opinions and statements above are entirely my own and not those of my
employer or clients **
-- 
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 

Oracle Applications Development Database Refresh

[Jared . Still]

Fellow listers,

In addition to the usual SAP system that runs most of our company, we have
Oracle Apps 10.7 HR.  For some reason the HR folks didn't like the SAP HR
module, so I have SAP and Oracle Apps.

The problem is a request I have to refresh the Dev database from the 
Production database.

If you can point me to the correct documentation for this, I'll take a 
look at it.

There's a lot of stuff to wade through in the docs and MetaLink, and I'd 
rather just
read documentation that's actually relevant.

Thanks,

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

RE: 2003 IOUG Meeting

[John Kanagaraj]

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

Re: insert nologging parallel/noparallel and archiving

[Jared . Still]

I'm doing this from memory, so you may want to RTFM 
to verify this information.

With a non-parallel insert, you will need to use the APPEND
hint to avoid generating redo.  Read the fine documentation
as to why this is necessary.

With a parallel INSERT, the data will all be APPENDed 
by default anyway, so the logs will not be generated.

Jared






Gurelei <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/05/2002 11:43 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:insert nologging parallel/noparallel and archiving


Hi all.

I've been trying to copy a 20mil rows table between
two databases via insert as select statement. I 
have dropped all the indices and ran in nologging mode
with hints forcing parallel execution of both ISERT
and SELECT. While checking the archive directory I
have noticed that the archives have been created every
2 minutes. I have cancelled the load and noticed that
I forgot to alter system enable parallel dml so in
effect the load was going in sequential mode. Then I
reran my script having added the alter system
statement and there we no archive created while it
ran.
So it looks like even without the indices a sequential
insert as select nologging still creates the archives
wihle the parallel - doesn't. Does it sound right? If
so, why. I thought the nollogging and with no indices
shouldn't produce any log info regardless of the mode.

TIA

Gene

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



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

Copy

[Ramon E. Estevez]

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: insert nologging parallel/noparallel and archiving

[Jack Silvey]

sorry, meant insert as select, not insert as append
--- Jack Silvey <[EMAIL PROTECTED]> wrote:
> Gene,
> 
> This sounds right. 
> 
> Standard insert as append does freelist block
> checking
> and generates redo. Parallel DML generates minimial
> redo, just for the new temp segments being created,
> not for the datablock updates. This is one reason it
> is so fast.
> 
> Index changes are always logged, even in PDML and
> append modes.
> 
> One way to consider would be to alter indexes to
> unusable and rebuild with nologging and compute
> statistics clauses. This way, your load is fast, you
> generate minimal redo, and your indexes are
> balanaced
> and have good stats afterwards.
> 
> A space consideration with PDML and dictionary
> managed
> tablespaces - each PQ process in your PDML is going
> to
> have its own extent. This extent will begin life
> with
> a size=initial, but will have the empty space
> trimmed
> off at the end of the write, leaving an odd size
> extent. Since you are doing PDML, you might have
> these
> extents close together, and when the trim occurs, it
> will leave odd sized holes in between and throw off
> your space managment strategy. I don't believe that
> LMT tablespaces have this issue.
> 
> hth,
> 
> jack
> 
> 
> --- Gurelei <[EMAIL PROTECTED]> wrote:
> > Hi all.
> > 
> > I've been trying to copy a 20mil rows table
> between
> > two databases via insert as select statement. I 
> > have dropped all the indices and ran in nologging
> > mode
> > with hints forcing parallel execution of both
> ISERT
> > and SELECT. While checking the archive directory I
> > have noticed that the archives have been created
> > every
> > 2 minutes. I have cancelled the load and noticed
> > that
> > I forgot to alter system enable parallel dml so in
> > effect the load was going in sequential mode. Then
> I
> > reran my script having added the alter system
> > statement and there we no archive created while it
> > ran.
> > So it looks like even without the indices a
> > sequential
> > insert as select nologging still creates the
> > archives
> > wihle the parallel - doesn't. Does it sound right?
> > If
> > so, why. I thought the nollogging and with no
> > indices
> > shouldn't produce any log info regardless of the
> > mode.
> > 
> > TIA
> > 
> > Gene
> > 
> > __
> > 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).
> 
> 
> __
> 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 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 information (like subscribing).

RE: 2003 IOUG Meeting

[Stephen Andert]

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 YouStephen 
P. KarniotisProduct ArchitectCompuware 
CorporationDirect:    (248) 
865-4350Mobile:    (248) 408-2918Email:    
[EMAIL PROTECTED]Web:    www.compuware.com-Original 
Message-Sent:    Friday, July 05, 2002 12:49 
PMTo:    Multiple recipients of list 
ORACLE-LSubject:    Re: 2003 IOUG MeetingThanks! I 
should have mentioned I have checked the IOUG page, but can notfindthe 
actual cost of attending. Or is it FREE to IOUG members, and 
therefore,Ineed to have my company pay for memberships for a couple of 
people toattend?thanks!Angel Tirone (an oracle 
newbie)"Karniotis, Stephen" wrote:> 
Angel:>>    The 2003 IOUG Live! Conference is being 
conducted between the Dolphinand> the Swan Hotels in Orlando, FL from 
April 27th 2003 - May 1st, 2003.  Both> of these hotels are on 
Disney property.  Based on past experience withthese> events, 
the price of the registration fee should be approximately the same> as 
this year.>> Stephen Karniotis> DBA Focus Area 
Manager> IOUG Live!>>  -Original 
Message-> Sent:   Friday, July 05, 2002 11:44 AM> 
To: Multiple recipients of list ORACLE-L> 
Subject:    2003 IOUG 
Meeting>> Hello!>> I am developing cost estimates 
for my company to possibly send a couple> of people to next year's IOUG 
meeting. Can some one tell me where it> will be, when it is, and the cost 
to attend?>> TIA> --> Angel Tirone> 
Information 
Architecture   email: 
[EMAIL PROTECTED]>> --> Please see the official 
ORACLE-L FAQ: http://www.orafaq.com> 
--> Author: Angel Tirone>   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, 
ordisclose> it to anyone else. If you received it in error please 
notify usimmediately> 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).--Angel 
Tirone    
Phone: (703) 833-5181Information 
Architecture   email: 
[EMAIL PROTECTED]-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Angel Tirone  INET: [EMAIL PROTECTED]Fat 
City Network Services    -- (858) 538-5051  FAX: (858) 
538-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).The contents of this e-mail 
are intended for the named addressee only. Itcontains information that may 
be confidential. Unless you are the namedaddressee or an autho

Re: Re:Should we upgrade from 9.0.1.2 to 9.2?

[Eric D. Pierce]

To be clear: 9.0.x will *NOT* have any EAS ("extended" 
support) either after June 2003. Gruesome.

regards,
ep

On 5 Jul 2002 at 1:18, Yechiel Adar wrote:

Date sent:  Fri, 05 Jul 2002 01:18:23 -0800
to  9.2?
To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>

> Yes. No more bugs fixed after June 2003.
> 
> from metalink:
> 
> Product Obsolescence / Desupport Information:
> Oracle Corporation announces the end of Error Correction Support for Oracle
> Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC
> & Standard Edition version(s) 9.0.1 on the following platform(s): ALL
> Platforms, effective 30-JUN-2003.

...


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

Re: insert nologging parallel/noparallel and archiving

[Jack Silvey]

Gene,

This sounds right. 

Standard insert as append does freelist block checking
and generates redo. Parallel DML generates minimial
redo, just for the new temp segments being created,
not for the datablock updates. This is one reason it
is so fast.

Index changes are always logged, even in PDML and
append modes.

One way to consider would be to alter indexes to
unusable and rebuild with nologging and compute
statistics clauses. This way, your load is fast, you
generate minimal redo, and your indexes are balanaced
and have good stats afterwards.

A space consideration with PDML and dictionary managed
tablespaces - each PQ process in your PDML is going to
have its own extent. This extent will begin life with
a size=initial, but will have the empty space trimmed
off at the end of the write, leaving an odd size
extent. Since you are doing PDML, you might have these
extents close together, and when the trim occurs, it
will leave odd sized holes in between and throw off
your space managment strategy. I don't believe that
LMT tablespaces have this issue.

hth,

jack


--- Gurelei <[EMAIL PROTECTED]> wrote:
> Hi all.
> 
> I've been trying to copy a 20mil rows table between
> two databases via insert as select statement. I 
> have dropped all the indices and ran in nologging
> mode
> with hints forcing parallel execution of both ISERT
> and SELECT. While checking the archive directory I
> have noticed that the archives have been created
> every
> 2 minutes. I have cancelled the load and noticed
> that
> I forgot to alter system enable parallel dml so in
> effect the load was going in sequential mode. Then I
> reran my script having added the alter system
> statement and there we no archive created while it
> ran.
> So it looks like even without the indices a
> sequential
> insert as select nologging still creates the
> archives
> wihle the parallel - doesn't. Does it sound right?
> If
> so, why. I thought the nollogging and with no
> indices
> shouldn't produce any log info regardless of the
> mode.
> 
> TIA
> 
> Gene
> 
> __
> 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).


__
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 information (like subscribing).

Re: insert nologging parallel/noparallel and archiving

[Connor McDonald]

You'll need the APPEND hint to avoid the logging in
serial mode.

hth
connor

 --- Gurelei <[EMAIL PROTECTED]> wrote: > Hi all.
> 
> I've been trying to copy a 20mil rows table between
> two databases via insert as select statement. I 
> have dropped all the indices and ran in nologging
> mode
> with hints forcing parallel execution of both ISERT
> and SELECT. While checking the archive directory I
> have noticed that the archives have been created
> every
> 2 minutes. I have cancelled the load and noticed
> that
> I forgot to alter system enable parallel dml so in
> effect the load was going in sequential mode. Then I
> reran my script having added the alter system
> statement and there we no archive created while it
> ran.
> So it looks like even without the indices a
> sequential
> insert as select nologging still creates the
> archives
> wihle the parallel - doesn't. Does it sound right?
> If
> so, why. I thought the nollogging and with no
> indices
> shouldn't produce any log info regardless of the
> mode.
> 
> TIA
> 
> Gene
> 
> __
> 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). 

=
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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).

insert nologging parallel/noparallel and archiving

[Gurelei]

Hi all.

I've been trying to copy a 20mil rows table between
two databases via insert as select statement. I 
have dropped all the indices and ran in nologging mode
with hints forcing parallel execution of both ISERT
and SELECT. While checking the archive directory I
have noticed that the archives have been created every
2 minutes. I have cancelled the load and noticed that
I forgot to alter system enable parallel dml so in
effect the load was going in sequential mode. Then I
reran my script having added the alter system
statement and there we no archive created while it
ran.
So it looks like even without the indices a sequential
insert as select nologging still creates the archives
wihle the parallel - doesn't. Does it sound right? If
so, why. I thought the nollogging and with no indices
shouldn't produce any log info regardless of the mode.

TIA

Gene

__
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: 2003 IOUG Meeting

[Karniotis, Stephen]

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
Subject:Re: 2003 IOUG Meeting

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)

"Karniotis, Stephen" wrote:

> Angel:
>
>The 2003 IOUG Live! Conference is being conducted between the Dolphin
and
> the Swan Hotels in Orlando, FL from April 27th 2003 - May 1st, 2003.  Both
> of these hotels are on Disney property.  Based on past experience with
these
> events, the price of the registration fee should be approximately the same
> as this year.
>
> Stephen Karniotis
> DBA Focus Area Manager
> IOUG Live!
>
>  -Original Message-
> Sent:   Friday, July 05, 2002 11:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject:2003 IOUG Meeting
>
> Hello!
>
> I am developing cost estimates for my company to possibly send a couple
> of people to next year's IOUG meeting. Can some one tell me where it
> will be, when it is, and the cost to attend?
>
> TIA
> --
> Angel Tirone
> Information Architecture   email: [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Angel Tirone
>   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).

--
Angel TironePhone: (703) 833-5181
Information Architecture   email: [EMAIL PROTECTED]



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

Re: Perl Question - Split using |

[Jared . Still]

Well, I guess this is why Andy's name is first on the book.  ;)

Jared





Andy Duncan <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/05/2002 08:38 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Perl Question - Split using |


Hi Celine,

> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list. 
> So if you Oracle Gurus, can help me with this Perl
> problem,  I would greatly appreciate it.
> I have a problem with  "split"  when my delimiter is "|". 
> I know that if I escape the pipe, split should work, 
> that is only when it is a literal like split(/\|/, "abc|def|123)
> 
> But when my delimiter is to be dynamically read from a
> file,  I have it in a variable.  Then this escaping
> stuff doesn't work..
> eg: 
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";
> 
> prints 
> a
> instead of 
> abc.
> 
> Does somebody have a solution to this.

You might want to try and use the quotemeta function, to create a regex
variable, which backslashes all alphanumerics within string variables, eg:

my $HeaderAttributes = "abc|defgh|123";
print "$HeaderAttributes\n";
my $Delimiter = "|";
my $regex = quotemeta($Delimiter);
(@Fields) = split(/$regex/, $HeaderAttributes);
print "Delimiter = $Delimiter Field[0] = $Fields[0]\n";

At this end, this produced:

abc|defgh|123
Delimiter = | Field[0] = abc

In a reckless bid towards on-topic status, I can only say that there's 
much
more of this kind of thing in Appendix C of "Perl for Oracle DBAs", 'The
Essential Guide to Regular Expressions'! :-)

HTH! :)

Rgds,
AndyD

__
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: Andy Duncan
  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: Perl Question - Split using |

[Alex]

my $HeaderAttributes = "abc|defgh|123";
$HeaderAttributes =~ s/\|/\\|/g;


On Fri, 5 Jul 2002, Celine John wrote:

> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list.
> So if you Oracle Gurus, can help me with this Perl
> problem,  I would greatly appreciate it.
> I have a problem with  "split"  when my delimiter is
> "|".
> I know that if I escape the pipe, split should work,
> that is only when it is a literal like
> split(/\|/, "abc|def|123)
>
> But when my delimiter is to be dynamically read from a
> file,  I have it in a variable.  Then this escaping
> stuff doesn't work..
> eg:
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";
>
> prints
> a
> instead of
> abc.
>
> Does somebody have a solution to this.
> Thanks much.
>
> __
> 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: Celine John
>   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: Alex
  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: Reset Sequence code

[Ramon E. Estevez]

Nice trick Joe !!!

  - Original Message - 
  From: 
  JOE 
  TESTA 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Friday, July 05, 2002 8:48 AM
  Subject: Reset Sequence code
  
  NO, you dont need to DROP the sequence, here is demo code i used to 
  reset a sequence(this resets it back to 1).
   
  SQL> drop sequence test_seq;
   
  Sequence dropped.
   
  SQL> create sequence test_seq;
   
  Sequence created.
   
  SQL> SQL> declare  2   seq_hold_var 
  number;  3  begin  4   for i in 1 .. 10 
  loop  5   select test_seq.nextval into seq_hold_var from 
  dual;  6   end loop;  7  end;  
  8  /
   
  PL/SQL procedure successfully completed.
   
  SQL> SQL> select test_seq.nextval from dual;
   
     
  NEXTVAL  
  --  
      
  11  
  
   
  SQL> SQL> alter sequence test_seq increment by -10;
   
  Sequence altered.
   
  SQL> SQL> select test_seq.nextval from dual;
   
     
  NEXTVAL  
  --  
   
  1  
  
   
  SQL> SQL> alter sequence test_seq increment by 1;
   
  Sequence altered.

Re: 2003 IOUG Meeting

[Angel Tirone]

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)

"Karniotis, Stephen" wrote:

> Angel:
>
>The 2003 IOUG Live! Conference is being conducted between the Dolphin and
> the Swan Hotels in Orlando, FL from April 27th 2003 - May 1st, 2003.  Both
> of these hotels are on Disney property.  Based on past experience with these
> events, the price of the registration fee should be approximately the same
> as this year.
>
> Stephen Karniotis
> DBA Focus Area Manager
> IOUG Live!
>
>  -Original Message-
> Sent:   Friday, July 05, 2002 11:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject:2003 IOUG Meeting
>
> Hello!
>
> I am developing cost estimates for my company to possibly send a couple
> of people to next year's IOUG meeting. Can some one tell me where it
> will be, when it is, and the cost to attend?
>
> TIA
> --
> Angel Tirone
> Information Architecture   email: [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Angel Tirone
>   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).

--
Angel TironePhone: (703) 833-5181
Information Architecture   email: [EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Angel Tirone
  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: 2003 IOUG Meeting

[Michael Cupp]

http://www.ioug.org 

or

http://www.ioug.org/ioug_p/live_2002?v_nav=ATTEND&v_text=LIVE_2002_WRAP_UP&v_trx=2606907

-Original Message-
Sent: Friday, July 05, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L


Hello!

I am developing cost estimates for my company to possibly send a couple of people to 
next year's IOUG meeting. Can some one tell me where it will be, when it is, and the 
cost to attend?

TIA
--
Angel Tirone
Information Architecture   email: [EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Angel Tirone
  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 message originated from the internet.  Its originator may not be who they claim 
to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Cupp
  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: Perl Question - Split using | - Resolved

[Celine John]

Wonderful!
Thanks for all who responded.
I always count on you guys.
--- Andy Duncan <[EMAIL PROTECTED]> wrote:
> Hi Celine,
> 
> > After seeing the e-mails about "Perl for
> Oracle-DBAs",
> > I presume, my question wouldn't be completely
> > inappropriate for this list.  
> > So if you Oracle Gurus, can help me with this Perl
> > problem,  I would greatly appreciate it.
> > I have a problem with  "split"  when my delimiter
> is "|".  
> > I know that if I escape the pipe, split should
> work, 
> > that is only when it is a literal like split(/\|/,
> "abc|def|123)
> > 
> > But when my delimiter is to be dynamically read
> from a
> > file,  I have it in a variable.  Then this
> escaping
> > stuff doesn't work..
> > eg: 
> > my $HeaderAttributes = "abc|defgh|123";
> > print "$HeaderAttributes\n";
> > my $Delimiter = "\|";
> > (@Fields) = split(/$Delimiter/,
> $HeaderAttributes);
> > print "Delimiter = $Delimiter Field[0] =
> > $Fields[0]\n";
> > 
> > prints 
> > a
> > instead of 
> > abc.
> > 
> > Does somebody have a solution to this.
> 
> You might want to try and use the quotemeta
> function, to create a regex
> variable, which backslashes all alphanumerics within
> string variables, eg:
> 
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "|";
> my $regex = quotemeta($Delimiter);
> (@Fields) = split(/$regex/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";
> 
> At this end, this produced:
> 
> abc|defgh|123
> Delimiter = | Field[0] = abc
> 
> In a reckless bid towards on-topic status, I can
> only say that there's much
> more of this kind of thing in Appendix C of "Perl
> for Oracle DBAs", 'The
> Essential Guide to Regular Expressions'! :-)
> 
> HTH! :)
> 
> Rgds,
> AndyD
> 
> __
> 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: Andy Duncan
>   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: Celine John
  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: 2003 IOUG Meeting

[Karniotis, Stephen]

Angel:

   The 2003 IOUG Live! Conference is being conducted between the Dolphin and
the Swan Hotels in Orlando, FL from April 27th 2003 - May 1st, 2003.  Both
of these hotels are on Disney property.  Based on past experience with these
events, the price of the registration fee should be approximately the same
as this year.

Stephen Karniotis
DBA Focus Area Manager
IOUG Live!

 -Original Message-
Sent:   Friday, July 05, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L
Subject:2003 IOUG Meeting

Hello!

I am developing cost estimates for my company to possibly send a couple
of people to next year's IOUG meeting. Can some one tell me where it
will be, when it is, and the cost to attend?

TIA
--
Angel Tirone
Information Architecture   email: [EMAIL PROTECTED]



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

Re: PostgeSQL?

[Daniel Wisser]

this maybe true in terms of administration, but not in terms
of object manipulation: handling sequences, writing pure
SQL functions etc. are really good stuff.

also to be implemented into ORA one day i hope

crucify me, thats my opinion

daniel


Alexandre Gorbatchev wrote:
> 
> > since oracle is not as handy and clever as PostgreSQL is,
> > at the moment, there is no other way than to drop the
> > sequence and create it again.
> 
> Since PostrgeSQL is not as reliable and scalable as Oracle is, at the
> moment, I wouldn't, from DBA perspective, use it for any seriuos project. :)
> and there are not many developer's tools. :)
> 
> > but it would be a great new feature for oracle 10.5.7.4.3.
> 
> I would better vote for other new features... :)))
> 
> Alexandre
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexandre Gorbatchev
>   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).

-- 
Daniel Wisser, Mag. 
Papyrus Quality Assurance 
DB Team 

ISIS Information Systems
Alter Wienerweg 12
A-2344 Ma. Enzersdorf, Austria

Phone: +43-2236-27551-149
Fax: +43-2236-21081
E-mail: [EMAIL PROTECTED]

Hotline: +43-2236-27551-111

Visit the ISIS Website: http://www.isis-papyrus.com

---
This e-mail is only intended for the recipient and not legally 
binding. Unauthorised use, publication, reproduction or 
disclosure of the content of this e-mail is not permitted.
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Wisser
  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: resetting sequence numbers

[Jared Still]

On Friday 05 July 2002 07:23, Mercadante, Thomas F wrote:
> Larry,
>
> I'm not as good as Jared, but maybe a little faster!  Check the function
> below out:

Faster?  I published this 2 years ago.  ;)

Jared

>
> CREATE OR REPLACE FUNCTION Reset_Seq(in_seq_name IN VARCHAR2) RETURN NUMBER
> IS
>
> current_value NUMBER;
> TYPE  refRS IS REF CURSOR;
> p_refRS refRS;
> select_str VARCHAR2(300) := 'select ' || in_seq_name || '.nextval from
> dual';
>
> BEGIN
>
>   SELECT last_number
>   INTO current_value
>   FROM USER_SEQUENCES
>   WHERE sequence_name = UPPER(in_seq_name);
>
>   EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || in_seq_name ||
> ' INCREMENT BY '  || (current_value-1) * -1;
>
>   OPEN p_refRS FOR
>select_str;
>   FETCH p_refRS INTO current_value;
>   CLOSE p_refRS;
>
>   EXECUTE IMMEDIATE 'ALTER SEQUENCE ' || in_seq_name || ' INCREMENT BY 1';
>
>   RETURN 1;
>
> END;
>
>
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Friday, July 05, 2002 9:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Jack,
>
> But then you have to redo grants, any invalidations. No big deal
> automating. But if you set the increment to a negative to take you right
> back down to zero, then set the increment to 1 (or whatever it was), there
> you go, no dropping the sequence.
>
> 10 to 1 odds Jared posts a nice little script that automates this second
> approach ;-)
>
> Regards,
>
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack Silvey
> > Sent: Friday, July 05, 2002 8:03 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: resetting sequence numbers
> >
> >
> > drop sequence, recreate sequence, rinse, repeat.
> >
> > Jack
> >
> > --- "Malik, Fawzia" <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > Is there a way of resetting sequence numbers back to
> > > zero???The application
> > > we have needs to have the sequence numbers reset...
> > >
> > > Thanks in advance
> > >
> > > Rgds
> > >
> > > Fawzia
> >
> > **
> >
> > > Information in this email is confidential and may be
> > > privileged.
> > > It is intended for the addressee only. If you have
> > > received it in error,
> > > please notify the sender immediately and delete it
> > > from your system.
> > > You should not otherwise copy it, retransmit it or
> > > use or disclose its
> > > contents to anyone.
> > > Thank you for your co-operation.
> >
> > **
> >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Malik, Fawzia
> > >   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 information (like subscribing).
-- 
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).

2003 IOUG Meeting

[Angel Tirone]

Hello!

I am developing cost estimates for my company to possibly send a couple
of people to next year's IOUG meeting. Can some one tell me where it
will be, when it is, and the cost to attend?

TIA
--
Angel Tirone
Information Architecture   email: [EMAIL PROTECTED]



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Angel Tirone
  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: OCP discount

[John . Hallas]

OPP gets you 35% discount (state member of OTN)

John

-Original Message-
Sent: 05 July 2002 16:13
To: Multiple recipients of list ORACLE-L


Anybody knows of a current "magic" code for a discount on OCP exams.  I am
particularly looking into the 8i DBA upgrade if this does matter.

Thanks.

Djordje
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  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: resetting sequence numbers

[Jared Still]

Dropping the sequence is unncessary.

see 

http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html

Jared

On Friday 05 July 2002 06:19, Alexandre Gorbatchev wrote:
> Fawzia,
> RTFM: "To restart the sequence at a different number, you must drop and
> re-create it."
> HTH
> Alexandre
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, July 05, 2002 2:23 PM
>
> > Hi,
> >
> > Is there a way of resetting sequence numbers back to zero???The
>
> application
>
> > we have needs to have the sequence numbers reset...
> >
> > Thanks in advance
> >
> > Rgds
> >
> > Fawzia
> >
> >
> > **
> > Information in this email is confidential and may be privileged.
> > It is intended for the addressee only. If you have received it in error,
> > please notify the sender immediately and delete it from your system.
> > You should not otherwise copy it, retransmit it or use or disclose its
> > contents to anyone.
> > Thank you for your co-operation.
> > **
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Malik, Fawzia
> >   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: 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).

Re: resetting sequence numbers

[Jared Still]

Close Larry.

I posted the URL to the nice little script.  :)

Jared

On Friday 05 July 2002 06:19, Larry Elkins wrote:
> Jack,
>
> But then you have to redo grants, any invalidations. No big deal
> automating. But if you set the increment to a negative to take you right
> back down to zero, then set the increment to 1 (or whatever it was), there
> you go, no dropping the sequence.
>
> 10 to 1 odds Jared posts a nice little script that automates this second
> approach ;-)
>
> Regards,
>
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack Silvey
> > Sent: Friday, July 05, 2002 8:03 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: resetting sequence numbers
> >
> >
> > drop sequence, recreate sequence, rinse, repeat.
> >
> > Jack
> >
> > --- "Malik, Fawzia" <[EMAIL PROTECTED]> wrote:
> > > Hi,
> > >
> > > Is there a way of resetting sequence numbers back to
> > > zero???The application
> > > we have needs to have the sequence numbers reset...
> > >
> > > Thanks in advance
> > >
> > > Rgds
> > >
> > > Fawzia
> >
> > **
> >
> > > Information in this email is confidential and may be
> > > privileged.
> > > It is intended for the addressee only. If you have
> > > received it in error,
> > > please notify the sender immediately and delete it
> > > from your system.
> > > You should not otherwise copy it, retransmit it or
> > > use or disclose its
> > > contents to anyone.
> > > Thank you for your co-operation.
> >
> > **
> >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Malik, Fawzia
> > >   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 information (like subscribing).
-- 
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).

Re: resetting sequence numbers

[Jack Silvey]

Alexandre,

Take it easy, just a little friday humor. All ways
have their advantages and disadvantages.

jack



--- Alexandre Gorbatchev
<[EMAIL PROTECTED]> wrote:
> Yeah?
> What if he had dropped the sequence, recreated it,
> and  goddamn application
> didn't work because he had lost goddamn grants? Good
> if he knew what were
> these grants.
> 
> Alexandre
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Friday, July 05, 2002 4:20 PM
> 
> 
> > ah jeez, you ferrin car drivers, always making
> thangs
> > complicated when all you need is a big hammer
> cubic
> > inch approach.
> >
> > What next? Setting maxvalue equal to the current
> > number and selecting one number? Renaming the
> sequence
> > and creating a synonym to point to another? Asking
> WHY
> > he needs to do this, only to find out that the
> code is
> > flawed since it should not rely on absolute
> > serialization from a sequence in the first place,
> for
> > god's sake?
> >
> > Don't you know that promoting alternate lifestyle
> DBA
> > ideas you are encouraging the inexperienced to
> > question authority and addin' to the moral
> corruption
> > of Ameruca?
> >
> > Stop poisonin the newbies with fancy ideas about
> > reverse select and such as that. If recreate was
> good
> > enuf for us, it is darn sure good enuf for them!
> >
> > 
> >
> >
> > I slay me. I am gonna be at work in one hour, and
> then
> > we can DO STATS!
> >
> >
> >
> >
> > --- Larry Elkins <[EMAIL PROTECTED]> wrote:
> > > Jack,
> > >
> > > But then you have to redo grants, any
> invalidations.
> > > No big deal automating.
> > > But if you set the increment to a negative to
> take
> > > you right back down to
> > > zero, then set the increment to 1 (or whatever
> it
> > > was), there you go, no
> > > dropping the sequence.
> > >
> > > 10 to 1 odds Jared posts a nice little script
> that
> > > automates this second
> > > approach ;-)
> > >
> > > Regards,
> > >
> > > Larry G. Elkins
> > > [EMAIL PROTECTED]
> > > 214.954.1781
> > >
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> > > Behalf Of Jack Silvey
> > > > Sent: Friday, July 05, 2002 8:03 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: Re: resetting sequence numbers
> > > >
> > > >
> > > > drop sequence, recreate sequence, rinse,
> repeat.
> > > >
> > > > Jack
> > > >
> > > >
> > > > --- "Malik, Fawzia" <[EMAIL PROTECTED]>
> > > wrote:
> > > > >
> > > > > Hi,
> > > > >
> > > > > Is there a way of resetting sequence numbers
> > > back to
> > > > > zero???The application
> > > > > we have needs to have the sequence numbers
> > > reset...
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > > Rgds
> > > > >
> > > > > Fawzia
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
**
> > > > > Information in this email is confidential
> and
> > > may be
> > > > > privileged.
> > > > > It is intended for the addressee only. If
> you
> > > have
> > > > > received it in error,
> > > > > please notify the sender immediately and
> delete
> > > it
> > > > > from your system.
> > > > > You should not otherwise copy it, retransmit
> it
> > > or
> > > > > use or disclose its
> > > > > contents to anyone.
> > > > > Thank you for your co-operation.
> > > > >
> > > >
> > >
> >
>
**
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > > http://www.orafaq.com
> > > > > --
> > > > > Author: Malik, Fawzia
> > > > >   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
> > > >
> > >
> >
>

Re: Perl Question - Split using |

[Andy Duncan]

Hi Celine,

> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list.  
> So if you Oracle Gurus, can help me with this Perl
> problem,  I would greatly appreciate it.
> I have a problem with  "split"  when my delimiter is "|".  
> I know that if I escape the pipe, split should work, 
> that is only when it is a literal like split(/\|/, "abc|def|123)
> 
> But when my delimiter is to be dynamically read from a
> file,  I have it in a variable.  Then this escaping
> stuff doesn't work..
> eg: 
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";
> 
> prints 
> a
> instead of 
> abc.
> 
> Does somebody have a solution to this.

You might want to try and use the quotemeta function, to create a regex
variable, which backslashes all alphanumerics within string variables, eg:

my $HeaderAttributes = "abc|defgh|123";
print "$HeaderAttributes\n";
my $Delimiter = "|";
my $regex = quotemeta($Delimiter);
(@Fields) = split(/$regex/, $HeaderAttributes);
print "Delimiter = $Delimiter Field[0] = $Fields[0]\n";

At this end, this produced:

abc|defgh|123
Delimiter = | Field[0] = abc

In a reckless bid towards on-topic status, I can only say that there's much
more of this kind of thing in Appendix C of "Perl for Oracle DBAs", 'The
Essential Guide to Regular Expressions'! :-)

HTH! :)

Rgds,
AndyD

__
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: Andy Duncan
  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: Perl Question - Split using |

[Jared Still]

Don't escape if it's in a variable.

Ask yourself why you have to escape it when used literally.

Jared

On Friday 05 July 2002 07:43, Celine John wrote:
> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list.
> So if you Oracle Gurus, can help me with this Perl
> problem,  I would greatly appreciate it.
> I have a problem with  "split"  when my delimiter is
> "|".
> I know that if I escape the pipe, split should work,
> that is only when it is a literal like
> split(/\|/, "abc|def|123)
>
> But when my delimiter is to be dynamically read from a
> file,  I have it in a variable.  Then this escaping
> stuff doesn't work..
> eg:
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";
>
> prints
> a
> instead of
> abc.
>
> Does somebody have a solution to this.
> Thanks much.
>
> __
> 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: 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).

Re: resetting sequence numbers

[Jared Still]

See:

http://www.cybcon.com/~jkstill/util/reset_sequence/reset_sequence.html

Jared

On Friday 05 July 2002 05:23, Malik, Fawzia wrote:
> Hi,
>
> Is there a way of resetting sequence numbers back to zero???The application
> we have needs to have the sequence numbers reset...
>
> Thanks in advance
>
> Rgds
>
> Fawzia
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
-- 
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).

Re: Perl Question - Split using |

[lembark]

-- Celine John <[EMAIL PROTECTED]> on 07/05/02 06:43:25 -0800

> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list.  
> So if you Oracle Gurus, can help me with this Perl
> problem,  I would greatly appreciate it.
> I have a problem with  "split"  when my delimiter is
> "|".  
> I know that if I escape the pipe, split should work, 
> that is only when it is a literal like
> split(/\|/, "abc|def|123)
> 
> But when my delimiter is to be dynamically read from a
> file,  I have it in a variable.  Then this escaping
> stuff doesn't work..
> eg: 
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter Field[0] =
> $Fields[0]\n";

Look up the '\Q' metachar (e.g., perldoc perlre and search for \Q).


--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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).

JDBC

[Sackwitz, Antje]

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

OCP discount

[Djordje Jankovic]

Anybody knows of a current "magic" code for a discount on OCP exams.  I am
particularly looking into the 8i DBA upgrade if this does matter.

Thanks.

Djordje
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djordje Jankovic
  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: resetting sequence numbers

[Alexandre Gorbatchev]

Yeah?
What if he had dropped the sequence, recreated it, and  goddamn application
didn't work because he had lost goddamn grants? Good if he knew what were
these grants.

Alexandre
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 4:20 PM


> ah jeez, you ferrin car drivers, always making thangs
> complicated when all you need is a big hammer cubic
> inch approach.
>
> What next? Setting maxvalue equal to the current
> number and selecting one number? Renaming the sequence
> and creating a synonym to point to another? Asking WHY
> he needs to do this, only to find out that the code is
> flawed since it should not rely on absolute
> serialization from a sequence in the first place, for
> god's sake?
>
> Don't you know that promoting alternate lifestyle DBA
> ideas you are encouraging the inexperienced to
> question authority and addin' to the moral corruption
> of Ameruca?
>
> Stop poisonin the newbies with fancy ideas about
> reverse select and such as that. If recreate was good
> enuf for us, it is darn sure good enuf for them!
>
> 
>
>
> I slay me. I am gonna be at work in one hour, and then
> we can DO STATS!
>
>
>
>
> --- Larry Elkins <[EMAIL PROTECTED]> wrote:
> > Jack,
> >
> > But then you have to redo grants, any invalidations.
> > No big deal automating.
> > But if you set the increment to a negative to take
> > you right back down to
> > zero, then set the increment to 1 (or whatever it
> > was), there you go, no
> > dropping the sequence.
> >
> > 10 to 1 odds Jared posts a nice little script that
> > automates this second
> > approach ;-)
> >
> > Regards,
> >
> > Larry G. Elkins
> > [EMAIL PROTECTED]
> > 214.954.1781
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Jack Silvey
> > > Sent: Friday, July 05, 2002 8:03 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: resetting sequence numbers
> > >
> > >
> > > drop sequence, recreate sequence, rinse, repeat.
> > >
> > > Jack
> > >
> > >
> > > --- "Malik, Fawzia" <[EMAIL PROTECTED]>
> > wrote:
> > > >
> > > > Hi,
> > > >
> > > > Is there a way of resetting sequence numbers
> > back to
> > > > zero???The application
> > > > we have needs to have the sequence numbers
> > reset...
> > > >
> > > > Thanks in advance
> > > >
> > > > Rgds
> > > >
> > > > Fawzia
> > > >
> > > >
> > > >
> > >
> >
> **
> > > > Information in this email is confidential and
> > may be
> > > > privileged.
> > > > It is intended for the addressee only. If you
> > have
> > > > received it in error,
> > > > please notify the sender immediately and delete
> > it
> > > > from your system.
> > > > You should not otherwise copy it, retransmit it
> > or
> > > > use or disclose its
> > > > contents to anyone.
> > > > Thank you for your co-operation.
> > > >
> > >
> >
> **
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Malik, Fawzia
> > > >   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 information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Larry Elkins
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Servic

PostgeSQL?

[Alexandre Gorbatchev]

> since oracle is not as handy and clever as PostgreSQL is,
> at the moment, there is no other way than to drop the
> sequence and create it again.

Since PostrgeSQL is not as reliable and scalable as Oracle is, at the
moment, I wouldn't, from DBA perspective, use it for any seriuos project. :)
and there are not many developer's tools. :)

> but it would be a great new feature for oracle 10.5.7.4.3.

I would better vote for other new features... :)))

Alexandre

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

Perl Question - Split using |

[Celine John]

After seeing the e-mails about "Perl for Oracle-DBAs",
I presume, my question wouldn't be completely
inappropriate for this list.  
So if you Oracle Gurus, can help me with this Perl
problem,  I would greatly appreciate it.
I have a problem with  "split"  when my delimiter is
"|".  
I know that if I escape the pipe, split should work, 
that is only when it is a literal like
split(/\|/, "abc|def|123)

But when my delimiter is to be dynamically read from a
file,  I have it in a variable.  Then this escaping
stuff doesn't work..
eg: 
my $HeaderAttributes = "abc|defgh|123";
print "$HeaderAttributes\n";
my $Delimiter = "\|";
(@Fields) = split(/$Delimiter/, $HeaderAttributes);
print "Delimiter = $Delimiter Field[0] =
$Fields[0]\n";

prints 
a
instead of 
abc.

Does somebody have a solution to this.
Thanks much.

__
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: Celine John
  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: Adding Control files

[ltiu]

Create Controlfile is only used during database recovery when all 
controlfiles are lost. This is not the Oracle recommended way of copying 
controlfiles since the newly created controlfile may not have the exact same 
parameters as the old one. Unpredictable results 

ltiu

On Friday 05 July 2002 06:13, you wrote:
> CREATE CONTROLFILE
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ltiu
  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).