 | | | Oracle List | | Mike
Just for grins try creating this function in another schema - something
*not* named "query ". I 'm wondering of this is a reserved word.
I tried the same function in my database (9 2.0.3)Is anyone in this DL using ODM (Oracle Disk Manager) from Veritas? We
are using ODM in a 9.2.0.4 (64-bit) single instance 11i (11.5.9)
E-business suite environment on Sun Solaris 8 platform. The harThe single release beta OCP upgrade exams for
9i and 10g covered lots of topics. For Oracle 9i
OracleWorld had upgrade exam cram sessions
yet a few weeks later Oracle announced that 110
people Thanks Stephane / Zorac
I am able to run the query and can retrieve the individual component of the date
SELECT rownum to_char( ret_date 'DD ') day to_char( ret_date 'MM ') month to_char( ret_datHello
20
I did try that with no sucess.
20
Can you explain me better please?
20
Thanks
Ant F3nio Trindade
-----Mensagem original----- 20
De oracle-l-bounce@(protected) em nome Hi
I want to generate one script which can return me dd mm yyyy part of every day for a duration for example ..
if I start from Jan 01 1999 to jan 01 2010 then wanted the record for every day..Fabrizio it sounds like you 're using a cross-over cable as your interconnect and you don 't have a swtich in there - correct?
If so it isn 't the Oracle release that is the problem. There is an elJuan
I looked at using this feature. The data is not updated in 'real ' time. I remember seeing something about the smon process updating the data supporting this feature asycronously. It is helpfRaid? Depends on the raid-type you have. RAID-F hurts. Baarf! Read
www.baarf.com.
Other interesting reading in
http //www.scaleabilities.co.uk/papers/scalingOracle8i.pdf chapter 2.
Best regards
On 02/01/2005 12 05 06 AM Lyndon Tiu wrote
> Hello
> 20
> I have a lookup table with a column.
That 's interesting. Are you sure you have a column in the lookup table?
> 20
> This columnI once heard that there is a threshold percentage for DBMS_STATS after whi
ch
the whole table is implicitly analyzed but I am unable to find that
threshold percentage on ixora asktom or MetalinIn the "deleted *.dbf files " thread Les said
(BTW I have been an SA in past lives so I do have
somewhat of a concept of the job...that was until I encountered the
'force ' and switched to a DBA
While running a large CREATE INDEX using a Tablespace Temporary which is
Dictionary Managed
I "grabbed " my session from v$SORT_USAGE
SQL > l
1 select s.username s.sid p.spid su.blocksShould I be running dbms_stats on the system objects? If so does Oracle
have a recommendation on what parameters to use when running it?
I am running EE 9.2.0.3 on Solaris 2.8
Thanks I am having big troubles with parses.
The application was developed using Java technology ( oc4j jdbc
connection pooling).
The application send a sql statement to the oracle db using a connectiOn Fri 28 Jan 2005 16 31 35 -0400 Boivin Patrice J
<BoivinP@(protected) > wrote
> It 's amazing to me that they
> think it 's normal. Imagine if their toaster or their oven was like that iOn Mon 31 Jan 2005 23 40 10 +0000 stephen booth
<stephenbooth.uk@(protected) > wrote
> On Mon 31 Jan 2005 23 26 36 +0000 David Sharples
> <davidsharples@(protected) > wrote
> > lock down the os acHi John
>execute dbms_stats.gather_system_stats(gathering_mode 3D > 'START ')
>select owner object_type count(*)
>from dba_objects group by owner object_type
>-- Optionally introduce a !sleep I believe as long as it 's perceived by career-minded managers that windows
is less of a risk for their careers than alternatives Windows will rule in
the corporate setting.
In many cases if a maHas anyone used Oracle workspace on 9i r2? Any critical issues?
Muru Data Architect
--
http //www.freelists.org/webpage/oracle-l
Please excuse my ignorance. Especially when it comes to licensing.
Because Im learning by fire like most of you may have im sure im
curious about partition licenses. I have a 9i datawarehouse oGood thought. I was also thinking about Distributed Query option. That might help using remote indexes..
-Scott
+++ Daniel Wittry [31/01/05 09 36 -0800]
> You didn 't ask about materialized v
I am having Oracle Apps 11.5.9 dev instance and I
need to give Read kind of access to some Of the
Modules. Is there any method that can be used to
restrict DDL/DML to the new user. User are deveDO you want notification to be sent when forms server is down ?
On Mon 31 Jan 2005 08 03 21 -0800 (PST) Sanjay Mishra
<smishra_97@(protected) > wrote
>
> I am using Oracle 9iAS Forms using LI am importing a 7.3.4 dump into a 9.2 database. All went well but
when I do a compare I get several objects with different data types and
even more object that differ in degree instance type. I Hi I received today my prometric carnet and certificate and I noted
three interesting things r
1) the site and password of members is the same than database
certificated professoinals.
2) I doNicolai
> I am not sure if it was discussed before but I would
> like to ask if there is a way to see the inside of
> archivelog files without shutting down the database.
It was discussed a fOn Mon 31 Jan 2005 10 02 45 +0200 Nicolai Tufar <ntufar@(protected) > wrote
> Greetings
> I am not sure if it was discussed before but I would
> like to ask if there is a way to see the inside of
Goodmorning Jacinta
> I need to know in oracle - Is there a way i can
> determine those recently changed table at a given
> time?
If you need to know who did a change to data at a
known pHi 20
>Let me rephrase . I would like to know is there a way
>to find out which table had been change at some point
>in time. For example i have an web base customer
>complain application I a |
|
|
