Search the web
Sign In
New User? Sign Up
OraTechSupportGroup · Oracle Techniques Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 399 - 428 of 457   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#428 From: "Sood, Ankit \(GE Consumer Finance, consultant\)" <ankit.sood@...>
Date: Wed Aug 11, 2004 9:56 am
Subject: querry
getsood
Offline Offline
Send Email Send Email
 
Hi ,
If some has good doc  which explain in detail about this AURORA$SERVER$SHUTDOWN
trigger please share with me
If have searh in the metalink but not getting Good doc ................
except its java thing and all........actually i am looking that some which tell
each n everything ,,,,,,,,
like if disable this with Java option we are using what the effect .......
Regards
Ankit

#427 From: "gdnagapurkar" <gdnagapurkar@...>
Date: Tue Aug 10, 2004 7:51 pm
Subject: Urgent Help Reqd
gdnagapurkar
Offline Offline
Send Email Send Email
 
Hai

  Iam getting an error FRM-40815 when am running the
  form to generate a report on my local server which
  is
  on Win 200 OS where as my web server is on Unix
  machine.

  I have one more problem also when am taking a print
  out of a form on my local PC am getting it correctly
  where as the server which is based on Unix system
  there am getting the print out but whereas the list
  items are shown blank even after selecting the item
  from the  list.

  Please help me out in solving this problem

  Thnx in advance.

  Gajendra Nagapurkar

#426 From: "Sood, Ankit \(GE Consumer Finance, consultant\)" <ankit.sood@...>
Date: Wed Aug 11, 2004 10:01 am
Subject: 10Gdownload
getsood
Offline Offline
Send Email Send Email
 
Hi,
I want to downlaod the trial copy of 10G software can any one please tell me
from where to downlaod .
I have try otn.oracle.com,technet.oracle and so may oracle links but that is not
coming .
Regards

#425 From: Gajendra Nagapurkar <gdnagapurkar@...>
Date: Mon Aug 9, 2004 8:24 pm
Subject: Urgent Help
gdnagapurkar
Offline Offline
Send Email Send Email
 
Hai
I am using Oracle Forms 6i on win2000 on local machine
where as Unix on my web server

  Iam getting an error FRM-40815 when am running the
  form to generate a report on my local server which
  is
  on Win 200 OS where as my web server is on Unix
  machine.

  I have one more problem also when am taking a print
  out of a form on my local PC am getting it correctly
  where as the server which is based on Unix system
  there am getting the print out but whereas the list
  items are shown blank even after selecting the item
  from the  list.

  Please help me out in solving this problem

  Thnx in advance.

  Gajendra Nagapurkar


--- Yahoo! Groups Notification
<notify@yahoogroups.com> wrote:

>
> Hello,
>
> The moderator of the OraTechSupportGroup group has
> approved your request for membership.
>
>
> Here are a few key tips to get you started:
>
> * To learn more about the OraTechSupportGroup group,
> please visit
>   http://groups.yahoo.com/group/OraTechSupportGroup
>
> * To post a message to this group, send email to
>   OraTechSupportGroup@yahoogroups.com
>
> * To contact the moderator of this group, send email
> to
>   OraTechSupportGroup-owner@yahoogroups.com
>
> * To unsubscribe from this group, send email to
>   OraTechSupportGroup-unsubscribe@yahoogroups.com
>
> Thank you for choosing Yahoo! Groups as your email
> group service.
>
>
> Regards,
>
> Yahoo! Groups Customer Care
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
>
>




__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

#424 From: samoracle@...
Date: Fri Jul 30, 2004 6:57 am
Subject: ^_^ meay-meay!
samoracle
Offline Offline
Send Email Send Email
 
Argh,  i don't like  the plaintext  :)

pass: 73512

#423 From: pardhu saradhi <saradhimp2000@...>
Date: Fri Jun 25, 2004 2:22 pm
Subject: Oracle 9i AS installation
saradhimp2000
Offline Offline
Send Email Send Email
 
hi everyone,

    I want some information about Oracle 9i Application
Server installation steps on Linux 9.0.

thanks&regards,
saradhi




__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

#422 From: Ayesha Tanveer <t_ashee@...>
Date: Thu Jun 10, 2004 4:30 am
Subject: Error while starting logminer
t_ashee
Offline Offline
Send Email Send Email
 
Dear Group Members,

I'v just joined in the group, and seek your help.
while starting Logminer with starttime and endtime
parameter it gives an error :Fatal Error at line 42 of
DBMS_LOGMINER.
I'm totally bugged pl help me...
Regrads




__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

#421 From: "geekaustin" <yahoolists@...>
Date: Thu Jun 3, 2004 4:11 pm
Subject: dbconsole on 10g?
geekaustin
Online Now Online Now
Send Email Send Email
 
I just installed ora 10g on two Win2K machines.

On one machine I couldn't bring the Enterprise Manager up.

I checked Administrative Tools\Services to see if
if dbconsole was running, and noticed that it was
missing.

Any recommendations on how I would begin to troubleshoot?



Thanks,
Lynn

#420 From: "saradhimp2000" <saradhimp2000@...>
Date: Thu May 6, 2004 3:40 pm
Subject: hi friends
saradhimp2000
Offline Offline
Send Email Send Email
 
hi everyone,


    I have one problem ie, What is Database(Oracle) testing? How to
write test cases for DB Stored procedures (DB Code checking) and data
integrity checking scripts etc. How to write the Data base scripts
using pl/sql and perform the QA from the backend point of view.  How
to able to understand the DB code and should be able to write the db
test scripts for various functions in the backend.

    If anybody knows pls guide me.


thanks&regards,
saradhi

#419 From: Wei Xia <yoxst@...>
Date: Mon Mar 29, 2004 3:16 pm
Subject: Re: remove carriage return
yoxst
Offline Offline
Send Email Send Email
 
Thanks, Goddie. I used replace function in my query,
but your pl/sql code gave me hint about chr(13).

wei

--- Godfrey Mwamsojo <goddie_sojo@...> wrote:
> Try expanding on this,
>
> set serveroutput on
> declare
>   phrase varchar2(32767) :=
> 'inter'||chr(13)||'national'||chr(13)||'lization';
>   newphrase varchar2(32767) := '';
>   current_char char;
>   i number;
>
> begin
>   /* substitute phrase with your column using cursor
> or select ..into construct */
>    dbms_output.put_line('.......Column with carriage
> return ......'||chr(13)||phrase||chr(13));
>    for i in 1..length(phrase) loop
>        current_char := substr(phrase,i,1);
>        if current_char != chr(13) then
>           newphrase := newphrase||current_char;
>        end if;
>    end loop;
>    dbms_output.put_line('.......Column without
> carriage return ......'||chr(13)||newphrase);
> end;
>
>
> Goddie
>
> yoxst <yoxst@...> wrote:
> I have a column containing large data with carriage
> return. When I
> query this column, it will give me several rows for
> one record because
> of carriage return. Does anyone know how to remove
> the carriage return
> in the record?
>
> Thanks
>
>
>
> Ask Your Question by sending Email direct to
> OraTechSupportGroup@...  your
> comment your suggestion about OraTechSupportGroup at
> Wadhwa_S@...
> Sameer Wadhwa (Moderator)
>
>
> omment your suggestion about OraTechSupportGroup at
> Wadhwa_S@...
> Sameer Wadhwa (Moderator)
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
>    To visit your group on the web, go to:
> http://groups.yahoo.com/group/OraTechSupportGroup/
>
>    To unsubscribe from this group, send an email to:
> OraTechSupportGroup-unsubscribe@yahoogroups.com
>
>    Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on
time.


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

#418 From: Wei Xia <yoxst@...>
Date: Sun Mar 28, 2004 2:56 am
Subject: Re: remove carriage return
yoxst
Offline Offline
Send Email Send Email
 
Thanks. I did it.

--- Varughese M <varughesem@...> wrote:
> Or,
>
>   select  replace(column,chr(13),null) from table
> ...
>
>
>
>
>  --- Godfrey Mwamsojo <goddie_sojo@...> wrote:
> >
> This query remove a carriage return between two
> > strings, "inter[carriage return]national" and give
> a
> > single string "international".
> >
> > You may expand this to a pl/sql loop and
> reconstruct
> > the entire column. I may be able to come up with
> an
> > example later
> >
> >  select 'inter'||chr(13)||'national' "Old
> Phrases",
> > substr('inter'||chr(13)||'national', 1,
> > (instr('inter'||chr(13)||'national', chr(13), -1)
> -
> > 1)) ||
> >  substr('inter'||chr(13)||'national',
> > instr('inter'||chr(13)||'national', chr(13)) +1)
> > "New Phrase"
> >  from dual;
> >
> >
> > Goddie.
> >
> >
> > yoxst <yoxst@...> wrote:
> > I have a column containing large data with
> carriage
> > return. When I
> > query this column, it will give me several rows
> for
> > one record because
> > of carriage return. Does anyone know how to remove
> > the carriage return
> > in the record?
> >
> > Thanks
> >
> >
> >
> > Ask Your Question by sending Email direct to
> > OraTechSupportGroup@...  your
> > comment your suggestion about OraTechSupportGroup
> at
> > Wadhwa_S@...
> > Sameer Wadhwa (Moderator)
> >
> >
> > omment your suggestion about OraTechSupportGroup
> at
> > Wadhwa_S@...
> > Sameer Wadhwa (Moderator)
> >
> >
> >
> >
> >
> >
> > ---------------------------------
> > Yahoo! Groups Links
> >
> >    To visit your group on the web, go to:
> > http://groups.yahoo.com/group/OraTechSupportGroup/
> >
> >    To unsubscribe from this group, send an email
> to:
> > OraTechSupportGroup-unsubscribe@yahoogroups.com
> >
> >    Your use of Yahoo! Groups is subject to the
> > Yahoo! Terms of Service.
> >
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Finance Tax Center - File online. File on
> time.
>
> Find local movie times and trailers on Yahoo!
> Movies.
> http://au.movies.yahoo.com
>


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

#417 From: Varughese M <varughesem@...>
Date: Sat Mar 27, 2004 2:03 pm
Subject: Re: remove carriage return
varughesem@...
Send Email Send Email
 
Or,

   select  replace(column,chr(13),null) from table ...




  --- Godfrey Mwamsojo <goddie_sojo@...> wrote: >
This query remove a carriage return between two
> strings, "inter[carriage return]national" and give a
> single string "international".
>
> You may expand this to a pl/sql loop and reconstruct
> the entire column. I may be able to come up with an
> example later
>
>  select 'inter'||chr(13)||'national' "Old Phrases",
> substr('inter'||chr(13)||'national', 1,
> (instr('inter'||chr(13)||'national', chr(13), -1) -
> 1)) ||
>  substr('inter'||chr(13)||'national',
> instr('inter'||chr(13)||'national', chr(13)) +1)
> "New Phrase"
>  from dual;
>
>
> Goddie.
>
>
> yoxst <yoxst@...> wrote:
> I have a column containing large data with carriage
> return. When I
> query this column, it will give me several rows for
> one record because
> of carriage return. Does anyone know how to remove
> the carriage return
> in the record?
>
> Thanks
>
>
>
> Ask Your Question by sending Email direct to
> OraTechSupportGroup@...  your
> comment your suggestion about OraTechSupportGroup at
> Wadhwa_S@...
> Sameer Wadhwa (Moderator)
>
>
> omment your suggestion about OraTechSupportGroup at
> Wadhwa_S@...
> Sameer Wadhwa (Moderator)
>
>
>
>
>
>
> ---------------------------------
> Yahoo! Groups Links
>
>    To visit your group on the web, go to:
> http://groups.yahoo.com/group/OraTechSupportGroup/
>
>    To unsubscribe from this group, send an email to:
> OraTechSupportGroup-unsubscribe@yahoogroups.com
>
>    Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on
time.

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

#416 From: Godfrey Mwamsojo <goddie_sojo@...>
Date: Fri Mar 26, 2004 4:50 pm
Subject: Re: remove carriage return
goddie_sojo
Offline Offline
Send Email Send Email
 
This query remove a carriage return between two strings, "inter[carriage return]national" and give a single string "international".
 
You may expand this to a pl/sql loop and reconstruct the entire column. I may be able to come up with an example later
 
 select 'inter'||chr(13)||'national' "Old Phrases", substr('inter'||chr(13)||'national', 1, (instr('inter'||chr(13)||'national', chr(13), -1) - 1)) ||
 substr('inter'||chr(13)||'national', instr('inter'||chr(13)||'national', chr(13)) +1) "New Phrase"
 from dual;
 
 
Goddie.


yoxst <yoxst@...> wrote:
I have a column containing large data with carriage return. When I
query this column, it will give me several rows for one record because
of carriage return. Does anyone know how to remove the carriage return
in the record?

Thanks



Ask Your Question by sending Email direct to
OraTechSupportGroup@...  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)


omment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)





Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.

#415 From: Godfrey Mwamsojo <goddie_sojo@...>
Date: Fri Mar 26, 2004 5:54 pm
Subject: Re: remove carriage return
goddie_sojo
Offline Offline
Send Email Send Email
 
Try expanding on this,
 
set serveroutput on
declare
  phrase varchar2(32767) := 'inter'||chr(13)||'national'||chr(13)||'lization';
  newphrase varchar2(32767) := '';
  current_char char;
  i number;
 
begin
  /* substitute phrase with your column using cursor or select ..into construct */
   dbms_output.put_line('.......Column with carriage return ......'||chr(13)||phrase||chr(13));
   for i in 1..length(phrase) loop
       current_char := substr(phrase,i,1);
       if current_char != chr(13) then
          newphrase := newphrase||current_char;
       end if;
   end loop;
   dbms_output.put_line('.......Column without carriage return ......'||chr(13)||newphrase);
end;
 
Goddie

yoxst <yoxst@...> wrote:
I have a column containing large data with carriage return. When I
query this column, it will give me several rows for one record because
of carriage return. Does anyone know how to remove the carriage return
in the record?

Thanks



Ask Your Question by sending Email direct to
OraTechSupportGroup@...  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)


omment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)





Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.

#414 From: "yoxst" <yoxst@...>
Date: Thu Mar 25, 2004 5:35 pm
Subject: remove carriage return
yoxst
Offline Offline
Send Email Send Email
 
I have a column containing large data with carriage return. When I
query this column, it will give me several rows for one record because
of carriage return. Does anyone know how to remove the carriage return
in the record?

Thanks

#413 From: "sm_hasanin" <hasan_mohamed@...>
Date: Sat Mar 13, 2004 7:37 am
Subject: is it possible to create Drill down reports in Oracle 9i ??
sm_hasanin
Offline Offline
Send Email Send Email
 
Dear all

I would like to know whether is it possible to create Drill down
reports in Oracle 9i Reports?Please let me know

Regards
Hassan

#412 From: "Rajesh Arora" <arora_rajesh@...>
Date: Thu Mar 4, 2004 11:41 pm
Subject: RE: Retrieve large amount of data
arora_rajesh@...
Send Email Send Email
 

Ernie,

Using pl/sql bulk feature you can retrieve number of rows together. Let me know if you need more detail, or go to metalink.oracle.com.

Rajesh Arora



 

----Original Message Follows----
From: Martinez Ernesto
Reply-To: OraTechSupportGroup@yahoogroups.com
To: OraTechSupportGroup@yahoogroups.com
Subject: [OraTechSupportGroup] Retrieve large amount of data
Date: Wed, 3 Mar 2004 14:35:50 -0800 (PST)
Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage.
Thank you
Ernie
---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.


Contact brides grooms FREE! Only on www.shaadi.com. Register now!

#411 From: Martinez Ernesto <ernesto33es@...>
Date: Wed Mar 3, 2004 10:35 pm
Subject: Retrieve large amount of data
ernesto33es
Offline Offline
Send Email Send Email
 
Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage.
 
 
Thank you
 
Ernie


Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster.

#410 From: P r e m c h a n d <urchandu@...>
Date: Sat Jan 17, 2004 11:58 am
Subject: Re: In which way is better User based or Roll based?
urchandu
Offline Offline
Send Email Send Email
 
Dear varughesem,
 
this giid concept yar. pls go varu is option. rgds pren

Varughese M <varughesem@...> wrote:
Hi Hassan,
  I don't think it is good idea to create 600 db users
and maintain  it. It will be nightmare to the dba to
add and delete and keep track of new users.

What I would do, is that, create one user for all the
tables, sequence, stored procedures/functions etc, ie
all DB objects go under one schema. Also create
several other DB users , which do not have any table
or any other Db objects, but have
execute/insert/delete/update permission on specific
tables/stored procedure/functions/SQLs etc, and give
access to very specific area of your application.

Create application users inside the application, and
connect as above specified users, to the DB. This will
transfer the user administration and access control to
ERP admin, rather than system/db admin. I think this
approch will more secure. - for example, on an order
entry form, one DB user have only insert access to
order table. no update/delete/select.


Hope this helps.
-Varughese

--- sm_hasanin <hasan_mohamed@...> wrote: >
Dear all
>
> We are developing Oracle 9i based ERP system,this is
> actually intranet based application.We have around
> 600
> users will be connecting this application daily.
> Here we have some query
> whether we can use user based or Roll based
> privilege
> to access the database?
> In which way it would be better to maintain.
> please advice which is the best way?
> Here is full description for user based:
> All the 600 user name will be created at database
> Roll based: all the 600 user will be created in
> Application side.
> only single user will be created at database side.
>
> please provide me merit and de merit
>
> Thanks
> Regards
> Hassan
>
>


http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.


Ask Your Question by sending Email direct to
OraTechSupportGroup@...  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)


omment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)







Yahoo! Groups Links

Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more. Download now.


#409 From: P r e m c h a n d <urchandu@...>
Date: Sat Jan 17, 2004 11:59 am
Subject: Re: In which way is better User based or Roll based?
urchandu
Offline Offline
Send Email Send Email
 
Dear varughesem,
 
this is good concept yar.
 
hassan pls go varu's option. rgds pren

Varughese M <varughesem@...> wrote:
Hi Hassan,
  I don't think it is good idea to create 600 db users
and maintain  it. It will be nightmare to the dba to
add and delete and keep track of new users.

What I would do, is that, create one user for all the
tables, sequence, stored procedures/functions etc, ie
all DB objects go under one schema. Also create
several other DB users , which do not have any table
or any other Db objects, but have
execute/insert/delete/update permission on specific
tables/stored procedure/functions/SQLs etc, and give
access to very specific area of your application.

Create application users inside the application, and
connect as above specified users, to the DB. This will
transfer the user administration and access control to
ERP admin, rather than system/db admin. I think this
approch will more secure. - for example, on an order
entry form, one DB user have only insert access to
order table. no update/delete/select.


Hope this helps.
-Varughese

--- sm_hasanin <hasan_mohamed@...> wrote: >
Dear all
>
> We are developing Oracle 9i based ERP system,this is
> actually intranet based application.We have around
> 600
> users will be connecting this application daily.
> Here we have some query
> whether we can use user based or Roll based
> privilege
> to access the database?
> In which way it would be better to maintain.
> please advice which is the best way?
> Here is full description for user based:
> All the 600 user name will be created at database
> Roll based: all the 600 user will be created in
> Application side.
> only single user will be created at database side.
>
> please provide me merit and de merit
>
> Thanks
> Regards
> Hassan
>
>


http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.


Ask Your Question by sending Email direct to
OraTechSupportGroup@...  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)


omment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)







Yahoo! Groups Links

Yahoo! India Mobile: Ringtones, Wallpapers, Picture Messages and more. Download now.


#408 From: Varughese M <varughesem@...>
Date: Tue Jan 13, 2004 3:39 pm
Subject: Re: In which way is better User based or Roll based?
varughesem@...
Send Email Send Email
 
Hi Hassan,
   I don't think it is good idea to create 600 db users
and maintain  it. It will be nightmare to the dba to
add and delete and keep track of new users.

  What I would do, is that, create one user for all the
tables, sequence, stored procedures/functions etc, ie
all DB objects go under one schema. Also create
several other DB users , which do not have any table
or any other Db objects, but have
execute/insert/delete/update permission on specific
tables/stored procedure/functions/SQLs etc, and give
access to very specific area of your application.

  Create application users inside the application, and
connect as above specified users, to the DB. This will
transfer the user administration and access control to
ERP admin, rather than system/db admin. I think this
approch will more secure. - for example, on an order
entry form, one DB user have only insert access to
order table. no update/delete/select.


Hope this helps.
-Varughese

  --- sm_hasanin <hasan_mohamed@...> wrote: >
Dear all
>
> We are developing Oracle 9i based ERP system,this is
> actually intranet based application.We have around
> 600
> users will be connecting this application daily.
> Here we have some query
> whether we can use user based or Roll based
> privilege
> to access the database?
> In which way it would be better to maintain.
> please advice which is the best way?
> Here is full description for user based:
> All the 600 user name will be created at database
> Roll based: all the 600 user will be created in
> Application side.
> only single user will be created at database side.
>
> please provide me merit and de merit
>
> Thanks
> Regards
> Hassan
>
>
>

http://personals.yahoo.com.au - Yahoo! Personals
New people, new possibilities. FREE for a limited time.

#407 From: "sm_hasanin" <hasan_mohamed@...>
Date: Tue Jan 13, 2004 10:24 am
Subject: In which way is better User based or Roll based?
sm_hasanin
Offline Offline
Send Email Send Email
 
Dear all

We are developing Oracle 9i based ERP system,this is
actually intranet based application.We have around 600
users will be connecting this application daily.
Here we have some query
whether we can use user based or Roll based privilege
to access the database?
In which way it would be better to maintain.
please advice which is the best way?
Here is full description for user based:
All the 600 user name will be created at database
Roll based: all the 600 user will be created in
Application side.
only single user will be created at database side.

please provide me merit and de merit

Thanks
Regards
Hassan

#406 From: "badotzo" <djward@...>
Date: Sun Nov 30, 2003 4:28 pm
Subject: how-to improve speed/efficiency of a query
badotzo
Offline Offline
Send Email Send Email
 
Friends,

I need to improve the speed of this query, and don't know how. I
apologize if this isn't the proper group; please point me in the
right direction if not.

The query runs in SQL*Plus and generates a fixed-width output file.
Part of the performance problem is because the tables reside in a
remote DB2 database; the rest comes from my ineptitude as a SQL
programmer.

While I have access to the remote tables, I do not have direct access
to their structure.  Another hurdle...

Any help will be greatly appreciated. Thanks in advance.

Here is the query:

select lpad(AddrBook_T.ABAN8,12,'0')||rpad(AddrBook_T.ABALPH,24,' ')||
(
select rpad(ALADD1,24,' ')||rpad(ALADD2,24,' ')||rpad(ALCTY1,15,' ')
||rpad(ALADDS,2,' ')||
substr(replace(replace(ALADDZ,'-'),' ')||'000000000',1,9)
from F0116@HSODBC
where ALAN8 = AddrBook_T.ABAN8
)||
nvl
(
(
select rpad(replace(translate(WPAR1,' -()','~'),'~'),3,'0')||rpad
(replace(translate(WPPH1,' -()','~'),'~'),7,'0')
from F0115@HSODBC
where WPAN8 = AddrBook_T.ABAN8 and WPIDLN = 0 and WPPHTP = '' and
rownum = 1
),'0000000000'
)||
nvl
(
(
select rpad(replace(translate(WPAR1,' -()','~'),'~'),3,'0')||rpad
(replace(translate(WPPH1,' -()','~'),'~'),7,'0')
from F0115@HSODBC
where WPAN8 = AddrBook_T.ABAN8 and WPIDLN = 0 and WPPHTP = 'FAX'
and rownum = 1
),'0000000000'
)||' '||
rpad(replace(translate(upper(ABALPH),' ()+=?%$@!:;"?,/&-
*#''''.','~'),'~'),8,' ')||' '||
decode
(
Parent_T.MAPA8, null, rpad(' ',89,' ')||lpad('0',29,'0')||rpad
(' ',27,' ')||'|',
(
select rpad(ABALPH,24,' ')||
(
select rpad(ALADD1,24,' ')||rpad(ALADD2,24,' ')||rpad
(ALCTY1,15,' ')||rpad(ALADDS,2,' ')||
substr(replace(replace(ALADDZ,'-'),' ')||'000000000',1,9)
from F0116@HSODBC
where ALAN8 = Parent_T.MAPA8
)||
nvl
(
(
select rpad(replace(translate(WPAR1,' -()','~'),'~'),3,'0')
||rpad(replace(translate(WPPH1,' -()','~'),'~'),7,'0')
from F0115@HSODBC
where WPAN8 = Parent_T.MAPA8 and WPIDLN = 0 and WPPHTP = ''
and rownum = 1
),'0000000000'
)||
nvl
(
(
select rpad(replace(translate(WPAR1,' -()','~'),'~'),3,'0')
||rpad(replace(translate(WPPH1,' -()','~'),'~'),7,'0')
from F0115@HSODBC
where WPAN8 = Parent_T.MAPA8 and WPIDLN = 0 and WPPHTP
= 'FAX' and rownum = 1
),'0000000000'
)||' '||
rpad(replace(translate(upper(ABALPH),' ()+=?%$@!:;"?,/&-
*#''''.','~'),'~'),8,' ')
from F0101@HSODBC
where ABAN8 = Parent_T.MAPA8
)||' |'
)
FROM F0101@HSODBC AddrBook_T LEFT OUTER JOIN F0150@HSODBC Parent_T ON
Parent_T.MAAN8 = AddrBook_T.ABAN8
WHERE AddrBook_T.ABAT1 = 'C';

#405 From: "Rajan" <rajan_san@...>
Date: Sun Nov 30, 2003 6:19 am
Subject: Oracle Data Migration / Replication
rajan_san
Offline Offline
Send Email Send Email
 
Hi,

I am handling the responsibility of designing a strategy of Migrating
Data from Oracle 8.0 to Oracle 9i Release 2.0.The conditions that
apply for this are as follows.

We are having a very mission critical Oracle 8.0 Database with a DB
size of approximately 200GB running on Oracle 8.1.6 On hp tru unix.We
are building a new application that would replace the existing
application in phases that is the complete data in the existing
production server will not get invalidated on Day 1 the data of only
certein identified users will be migrated to the new system and this
would happen in phases.My new production server and the existing
production server are connected over a network link (Basicaly not in
the same LAN assume it has a 2MBPS dedicated link).Now our issue is
transferring the selected data from Existing to the new system over
the network link.Also the schema structure(ER Diagra) of the and the
New production system is variant that is i have to write a business
logic that selects data from the existing Oracle 8 Production server
and inserts into the Oracle 9i Release 2 server into a specific
table.Now since the Data is very huge and def cannot be transferred
overnight before the system goes live i want to establish a
replication strategy between these 2 server may be i will use an
additional server at the New production site wher i will get all the
pelicated Data and i will create a DB LINK between the 2 servers in
the new site and write a PL/SQL subroutine that will hlep me in Data
Mapping and Porting.Please let me know if the strategy is good enough
and if there are any majors problems that could occur how can Data
replication really help me in this scenario is it more efficient then
transfering archive logs and applying or export import method and how
do i go about setting up the replication between the servers.

A quick update on this would be very helpful
Thanks a Lot In Advance
Rajan.S
Wipro LTD

#404 From: vinay shivaiah <vinbinsoffice@...>
Date: Thu Nov 6, 2003 5:16 pm
Subject: SQL*Load Question
vinbinsoffice
Offline Offline
Send Email Send Email
 
Hello,
 
I am using sql*load to load my table.
I want to only load a record if it's length is less than 100.
I have a tried a no: of options. One that almost worked was the following:
 
My control file looks like this
  options (errors = 1000 )                     
  LOAD DATA APPEND              
  INTO table xxxxxx
  WHEN (101)=BLANKS
  (col_1    POSITION(1:100)     CHAR )  
 
This doesn't work if I use "WHEN (101)=BLANKS" but works if I have "WHEN (101)<>BLANKS"! I am guessing that this is because there are some unprintable chars at the end of the string.
 
Any help is greatly appreciated!
 
Thanks


Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

#403 From: "kotresh k.b." <kbkots@...>
Date: Wed Nov 5, 2003 4:00 am
Subject: Re: Length in SQL*Load
kbkots
Offline Offline
Send Email Send Email
 
Hi ,
U can try with pl/sql script using  file io package..
it may help..

--- vinay shivaiah <vinbinsoffice@...> wrote:
> Hello,
>
> I am using sql*load to load my table.
> I want to only load a record if it's length is less
> than 100.
> I have a tried a no: of options. One that almost
> worked was the following:
>
> My control file looks like this
>   options (errors = 1000 )
>   LOAD DATA APPEND
>   INTO table xxxxxx
>   WHEN (101)=BLANKS
>   (col_1    POSITION(1:100)     CHAR )
>
> This doesn't work if I use "WHEN (101)=BLANKS" but
> works if I have "WHEN (101)<>BLANKS"! I am guessing
> that this is because there are some unprintable
> chars at the end of the string.
>
> Any help is greatly appreciated!
>
> Thanks,
> Bindu
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

#402 From: vinay shivaiah <vinbinsoffice@...>
Date: Tue Nov 4, 2003 10:14 pm
Subject: Length in SQL*Load
vinbinsoffice
Offline Offline
Send Email Send Email
 
Hello,
 
I am using sql*load to load my table.
I want to only load a record if it's length is less than 100.
I have a tried a no: of options. One that almost worked was the following:
 
My control file looks like this
  options (errors = 1000 )                     
  LOAD DATA APPEND              
  INTO table xxxxxx
  WHEN (101)=BLANKS
  (col_1    POSITION(1:100)     CHAR )  
 
This doesn't work if I use "WHEN (101)=BLANKS" but works if I have "WHEN (101)<>BLANKS"! I am guessing that this is because there are some unprintable chars at the end of the string.
 
Any help is greatly appreciated!
 
Thanks,
Bindu


Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

#401 From: "Duraisamy, Jayakumar" <jayakumar.duraisamy@...>
Date: Tue Nov 4, 2003 9:01 am
Subject: RE: Cleared 1Z0-031
djkumar72
Offline Offline
Send Email Send Email
 
hi ,
   Congratulations!
 
Thanks,
Jay
-----Original Message-----
From: Oracle Fan [mailto:oracletips2000@...]
Sent: Monday, November 03, 2003 11:49 AM
To: OraTechSupportGroup@yahoogroups.com
Cc: ocp9i_study@...
Subject: Re: [OraTechSupportGroup] Cleared 1Z0-031

Hi ila,
 
Congrats!!! man...u did the god job.i appricate ur thoughts.even i have the plan to do this paper.can u sen the list of questions to following mail id..?
 
 
Thanks & Regards,
Nandha

ocp9i_study <ocp9i_study@...> wrote:
Hi Guys,
I have cleared the fundamental 1 Paper today with 98.33%( 59/60.)
I've send mail to all groups peoples who have cleared the papers...for thier precious tips and material......but no body replied me ...My special thanks to Ajay Rao..Who was the only guy who helped me a lot...
and  for Mr. Rajeev Parameswaran for providing links for STS.... 
If anybody have some quaries then do mail me....
Because I don't want myself in those lists ...
Thanks,
ila



Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Ask Your Question by sending Email direct to
OraTechSupportGroup@YahooGroups.com

To unsubscribe from this group, send an email to:
OraTechSupportGroup-unsubscribe@yahoogroups.com

Send  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)




Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Yahoo! India Matrimony: Find your partner online. Post your profile.

Ask Your Question by sending Email direct to
OraTechSupportGroup@YahooGroups.com

To unsubscribe from this group, send an email to:
OraTechSupportGroup-unsubscribe@yahoogroups.com

Send  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)




Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


#400 From: naresh thanvi <naresh_thanvi@...>
Date: Mon Nov 3, 2003 6:28 am
Subject: Re: Cleared 1Z0-031
naresh_thanvi
Offline Offline
Send Email Send Email
 
Hi ila,
 
Congrats!!!  of clearing the paper. i have the plan to do this paper.can u sen the list of questions to following mail id..?


ocp9i_study <ocp9i_study@...> wrote:
Hi Guys,
I have cleared the fundamental 1 Paper today with 98.33%( 59/60.)
I've send mail to all groups peoples who have cleared the papers...for thier precious tips and material......but no body replied me ...My special thanks to Ajay Rao..Who was the only guy who helped me a lot...
and  for Mr. Rajeev Parameswaran for providing links for STS.... 
If anybody have some quaries then do mail me....
Because I don't want myself in those lists ...
Thanks,
ila



Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Ask Your Question by sending Email direct to
OraTechSupportGroup@YahooGroups.com

To unsubscribe from this group, send an email to:
OraTechSupportGroup-unsubscribe@yahoogroups.com

Send  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)




Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

#399 From: Oracle Fan <oracletips2000@...>
Date: Mon Nov 3, 2003 6:19 am
Subject: Re: Cleared 1Z0-031
oracletips2000
Offline Offline
Send Email Send Email
 
Hi ila,
 
Congrats!!! man...u did the god job.i appricate ur thoughts.even i have the plan to do this paper.can u sen the list of questions to following mail id..?
 
 
Thanks & Regards,
Nandha

ocp9i_study <ocp9i_study@...> wrote:
Hi Guys,
I have cleared the fundamental 1 Paper today with 98.33%( 59/60.)
I've send mail to all groups peoples who have cleared the papers...for thier precious tips and material......but no body replied me ...My special thanks to Ajay Rao..Who was the only guy who helped me a lot...
and  for Mr. Rajeev Parameswaran for providing links for STS.... 
If anybody have some quaries then do mail me....
Because I don't want myself in those lists ...
Thanks,
ila



Do you Yahoo!?
Exclusive Video Premiere - Britney Spears

Ask Your Question by sending Email direct to
OraTechSupportGroup@YahooGroups.com

To unsubscribe from this group, send an email to:
OraTechSupportGroup-unsubscribe@yahoogroups.com

Send  your comment your suggestion about OraTechSupportGroup at Wadhwa_S@...
Sameer Wadhwa (Moderator)




Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Yahoo! India Matrimony: Find your partner online. Post your profile.


Messages 399 - 428 of 457   Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help