Could you ask your Oracle rep. for a reference or two in your
industry? They're usually very quick to give those references.
You can contact the company in question and ask them for references.
HP-UX and terabyte sized oracle 9i database are rather frequent
combination, but you should contact
Hi there fellow Oracle people,
I am hoping that
some of you can help me and/or provide details etc. for my situation I find
myself in. So if you bear with me I will describe the
situation.
I currently
support an Oracle 9i (just moved from 7.3.4), windows, tuxedo, client server
application
Dear Gurus,
I have dbms_job in replication environment to push deffered transactions from site A
to B and B to A.
The job which is running at site A is working fine but job which is running at site
B is not pushing the transactions automatically. But if I do it manually (either
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes).
HTH
SF
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -
Date: Friday, November 14, 2003 8:59 am
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump
Hi,
I am an Oracle DBA, not failiar with Oracle APPS. But management put me into Oracle APPS DBA team. So I have to start from 0.Kindly Request you send me some guide lines to startup Oracle APPS DBA. Any documents, presentations, White papers and URLs are highly appreciated.
Thanks in advance,
Tim Gorman wrote:
Great idea, Mark!
By the way, does anyone remember the yes command in UNIX? Same concept.
I think it was invented to answer ³yes² to any program which mindlessly
prompt for ³yes/no² responses in situations where only ³yes² makes sense.
Case in point: ³fsck². As in:
y
y
y
y
y
..
On Fri, 2003-09-19 at 22:09, Tim Gorman wrote:
Great idea, Mark!
By the way, does anyone remember the yes command in UNIX? Same concept.
I think it was invented to answer yes to any program which mindlessly
prompt for yes/no responses in situations where only yes makes sense.
,
Mark.
Stephane
Faroult To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
orp.com Subject: RE: Re: SQL help
y
y
y
y
Continue to repair or build a new filesystem-
Do you want to build a new filesystem (y/n)?
y
Oops ;-)
..
On Fri, 2003-09-19 at 22:09, Tim Gorman wrote:
Great idea, Mark!
By the way, does anyone remember the yes command in UNIX? Same
concept.
I think it was invented to
Great idea, Mark!
By the way, does anyone remember the yes command in UNIX? Same concept.
I think it was invented to answer ³yes² to any program which mindlessly
prompt for ³yes/no² responses in situations where only ³yes² makes sense.
Case in point: ³fsck². As in: ³Do you want to repair this
Sorry for the last response in this thread which was truncated. Very
annoying! The full response looks as follows (hope this goes through in
it¹s entirety)...
-- Forwarded Message
Date: Fri, 19 Sep 2003 22:05:19 -0700
To: [EMAIL PROTECTED]
Great idea, Mark!
By the way, does anyone
You raise an interesting idea in my mind...
How useful would it be for us if Oracle created an INFINITE_DUAL table -
One where you could select as many rows as you wished. I guess it might
be
dangerous but it would at least be very efficient if Oracle coded it as a
special table. Then you
You would require something like this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857
HTH
GovindanK
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
I was thinking along the same lines minus the outer query which is totally
unnecessary, but it is the beginning of my day here :-).
SF
- --- Original Message --- -
From: Wolfgang Breitling [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue,
- --- Original Message --- -
From: Mark Richard [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 16 Sep 2003 19:59:41
I guess I should have added some criteria like:
1) user_objects must have enough rows in it to
cover the range (if not
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL
Hi Stephane,
I commiserate with you 8-)
Regards,
Guido
[EMAIL PROTECTED] 17.09.2003 10.44 Uhr
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please
Hi!
This one is a very interesting consideration. The use of 'pivot' tables,
as in this case, without being something you meet daily is fairly frequent
(completing series like here is one usage, otherwise I commonly use them to
generate test data). It should be some standard feature, a kind of
Hello All,
Thanks for your wonderful ideas.
I just forwarded those to my dear Developer (my wife, that is :)
After posting my question to the list last night, I was told that the query will be
run against
an Informix database :)
Typical Developers !!! ;)
Cheers!
- Kirti
---
I know you said that this was Informix, but I'll post the article below anyway for the
benefit of other listers.
Oracle Technology Network Oracle Magazine September/October 2002
Turning On Pivot Tables By Jonathan Gennick
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
Describes a method
Hey there kirti , good to have you back.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 19:09
Hello All,
Thanks for your wonderful ideas.
I just forwarded those to my dear Developer (my wife, that is :)
After
]
[EMAIL PROTECTED]cc:
orp.com Subject: RE: Re: SQL help needed
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
-- ---
100 1
200 4
300 8
400 9
50014
How would I find out the missing
:
Sent by: Subject: SQL help needed
[EMAIL PROTECTED
There is no way you can do it without some procedural programming.
PL/SQL is easy and, knowing you and your great knowledge , I'm not
going to offer that kind of advice. SQL was modelled on the set theory,
which essentially means that you are selecting subset, based on relatively
static criteria
[EMAIL PROTECTED]
ban.com.au cc:
Sent by: Subject: Re: SQL help needed
How about
select linenbr from (select rownum+min as linenbr from dba_objects where
rownum (max-min)
minus select linenbr from kirti where linenbr min and linenbr max)
/
pollux.stats.scott select * from kirti;
EMPNBRLINENBR
-- --
100 1
200
Hi All,
I am trying to install Oracle 9iAS on Win 2000
I installed Infra structure successfully. While trying to install next
component OAS with BI/Forms I get a message
Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of
existing Single Sign-On. Heck I do not know
if it
There is a ports.ini file somewhere in the infra and middle Oracle homes,
they would tell you what port to use.
Patrice.
-Original Message-
Sent: Tuesday, September 09, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
Hi All,
I am trying to install Oracle 9iAS on Win 2000
I
:
mpo.gc.ca Subject: RE: Oracle 9iOAS install help
needed
Sent
I installed our Oracle 9iAS on Win 2000 following Oracle 9iAS Release 2
(9.0.2.0.1) Windows Installation Cookboook (Note: 21469.1). It's been a
few months so I don't recall exactly how it went. The document does mention
to verify the SSO Login by going to
http://hostname.domain:port/pls/orasso,
are you using the full host
name? webbox.mycompany.com? Is iasdb or whatever you named your infrastructure
instance up and running? [EMAIL PROTECTED] 9/9/2003
8:59:26 AM
Hi All,I am trying to install Oracle 9iAS on Win
2000I installed Infra structure successfully. While trying to install
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve my
query performance.
Thanks and Best Regards
Munish Bajaj
Blank Bkgrd.gif
of list ORACLE-LSubject: Help
Needed regarding partitioning
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve
my query performance.
Thanks and Best Regards
Munish
Bajaj
Jack, Munish
First, verify that you have licensed partitioning. Additional cost item.
Second, learn about EXCHANGE PARTITION. This is a highly useful command that
can be used for a multitude of uses. Create a partitioned table and then
exchange your table into it. Extremely fast since it just
are strictly
personal. QOTD: Any clod can have facts,
having an opinion is an art !
-Original Message-From: Munish Bajaj
[mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 11:54
AMTo: Multiple recipients of list ORACLE-LSubject: Help
Needed regarding partitioning
Hi
Read about exchanging partitions in chapter 17 and especially Converting a Partition
View into a Partitioned Table :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/toc.htm
Even though you may not be using a partitioned view, you can use this technique to
create the
That is the greatest RTFM answer that I've ever seen!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 25, 2003 9:33 AM
To: Multiple recipients of list ORACLE-L
Read about exchanging partitions in chapter 17 and especially
ECTED]Sent: Wednesday, June 25, 2003 5:54
AMTo: Multiple recipients of list ORACLE-LSubject: Help
Needed regarding partitioning
Hi Listers,
Please let me know whether I can convert an
existing heavy table into a partitioned table and how? I need this to improve
my query performance.
Thank
Thanks for mentioning it
Just tried a little test and worked like a charm.
alter table part2 exchange partition JUNE2003 with table test_part1
Jacob A. van Zanen
-Original Message-
Sent: Wednesday, June 25, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Jack, Munish
First,
Hi List,
I have the below query which is very long and it contains an UNION
clause as the query has to select ac_type from op_ac_type table if
op_fl_plan.op-ac_type = 'JET' while it should select op_ac_type from
op_fl_plan table if op_fl_plan.ac_type = 'JET'.Is it possible to rewrite
Try something like this:
select a.OP_FL_PLAN_KEY,
a.FLIGHT_NO,
a.ORIGIN,
a.DESTINATION,
a.SEG_DEP_DATE_TIME,
a.SEG_ARR_DATE_TIME,
a.DEP_DAY_CHG,
a.ARR_DAY_CHG,
DECODE(a.ac_type, 'JET', c.AC_TYPE, a.AC_TYPE),
a.AC_GRP, b.exp_lat_date_time,
b.imp_toa_date_time,
b.spl_code
from op_fl_plan a,
select a.OP_FL_PLAN_KEY,
a.FLIGHT_NO,
a.ORIGIN,
a.DESTINATION,
a.SEG_DEP_DATE_TIME,
a.SEG_ARR_DATE_TIME,
a.DEP_DAY_CHG,
a.ARR_DAY_CHG,
decode(a.ac_type,'JET',c.AC_TYPE,a.ac_type)
a.AC_GRP,
Ranganath,
Why? Will making the query more concise provide any advantage at all? I
frequently break out such concise queries into multiple UNION'd statements
in order to improve performance, by clarifying unnecessarily concise
(therefore convoluted) logic.
Not to be too cheeky, but in this
Tim,
Following your trunc() line, have you come
across this feature of 9.2 (and some earlier
versions) -
create index t1_i2 on t1(d1);
analyze table t1 compute statistics;
select * from t1
where trunc(sysdate) = '01-Dec-2002';
Execution plan:
---
table access (by index
Title: Re: Query rewrite help needed
See if the following works:
select a.OP_FL_PLAN_KEY
, a.FLIGHT_NO
, a.ORIGIN
, a.DESTINATION
, a.SEG_DEP_DATE_TIME
, a.SEG_ARR_DATE_TIME
, a.DEP_DAY_CHG
, a.ARR_DAY_CHG
, CASE WHEN a.AC_TYPE = 'JET'
then (select c.ac_type from op_ac_type c where
Unfortunately the example loses
a little credibility and impact because
I put:
where trunc(sysdate) = '01-Dec-2002';
rather than
where trunc(d1) = '01-Dec-2002';
I just can't seem to get the cut and paste
to work properly from my laptop to my
email machine :(
Regards
Jonathan
-
From: Jonathan Lewis [mailto:[EMAIL PROTECTED]
Sent: 10 March 2003 15:24
To: Multiple recipients of list ORACLE-L
Subject: Re: Query rewrite help needed
Tim,
Following your trunc() line, have you come
across this feature of 9.2 (and some earlier
versions) -
create index
Notes inline.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
UK___March 19th
UK___April 8th
Hi DBA's
Need some help in post cloning.
DB: 8i
OS: SOlaris 2.8
Apps: 11i
Every sunday my test database
(including TOPs (APPL_TOP and other tops))
is refreshed with production (cloned). It is 11i
(11.5.5)
When it is refreshed, I am loosing my newly created
users and their responsibilities
Before cloning, you can create a temp table as select * from fnd_user
and fnd_user_resp_groups where creation_date (the date since last
clone).
Once the db is cloned, you can import this temp table and insert into
the main tables with this data.
If new users and responsibility groups had been
by: Subject: Urgent help needed, gurus
[EMAIL PROTECTED]
om
Oracle 817 on W2k:
SELECT FUNCTION(X) FROM TABLE works fine.
SELECT COUNT (*) FROM
(SELECT FUNCTION(X) FROM TABLE) where the function and the table are the
same as above, takes hours and hours, without any result, and I have to stop
it. There is NO ERROR MESSAGE.
The same story (no result,
What does the session statistics say when you are running the query?
Do an explain plan of both the queries and see the difference. Check the
session statistics for both the queries.
Regards
Naveen
-Original Message-
Sent: Tuesday, December 24, 2002 2:34 PM
To: Multiple recipients of
Hi people
Now it's my turn, i really need some help here.
I've got some forms developed in forms 6i (even some in forms 4.5) that are
working fine in client/server mode. But ... if i switch to web mode i will
lose loads of funtionalities here.
The real problem is:
How do i put the local devices
-Original Message-
From: Paulo Gomes
Sent: quinta-feira, 19 de Dezembro de 2002 12:50
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
Hi people
Now it's my turn, i really need some help here.
I've got
Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also.
Read through Forms information at http://technet.oracle.com
Raj
Hi All,
Oracle 8.1.6 WinNT
I have been trying to use sqlldr and I am getting following error
Record 1: Rejected - Error on table INTERVIEW, column COMMENTS.
end of logical record found when reading length of varying length field
Here is sample record and control file.
Any ideas why I get this
I am not sure if it helps, but I would use:
- FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY ''
- COMMENTS position(n:n+2000) where n=the offset of the first character of the field
COMMENTS including delimiters
- ROW_POCESSED SEQUENCE(MAX,1)
inka
-Original Message-
Sent: Wednesday,
HELP
Hi,
I am working with Oracle 8i version in our ERP applications. I have one
question regarding the backup of Oracle database. In the database I am
designing it is required to partition the database as per financial
year.Almost all the tables will be partitioned accordingly. I want to know
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 9:18 AM
HELP
Hi,
I am working with Oracle 8i version in our ERP applications. I have
Rakesh,
You have 2 options.
1. Either create the different partitions on different
tablespaces and take backup of selected tablespaces
2. You can take a logical backup using the export
utility by providing a query clause for the table.
HTH,
Naveen
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
Give each partition its own tablespace and back up the
tablespaces.
--- rakesh banerjee [EMAIL PROTECTED]
wrote:
HELP
Hi,
I am working with Oracle 8i version in our ERP
applications. I have one
question regarding the backup of Oracle database. In
the database I am
designing it is
Rakesh,
Yes. You can certainly export a single partition at a time for logical
backups. If you put each partition in its own tablespace, you can
physically back up individual partions as well.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
script
so that it assigns the tablespace automatically. Waiting for ur reply.
With Regards
Rakesh Banerjee
From: Igor Neyman [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put
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
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Help needed
Date: Wed, 03 Apr 2002 06:53:33 -0800
Put each partition into separate tablespace.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
help received...
I was responding to the question about the tablespace partitioning
with text and examples. My email package (groupwise) is still randomly
limiting the size of the emails.
Thanks for helping.
Ron
[EMAIL PROTECTED] 04/03/02 01:43PM
Help given
-Original Message-
Sent:
Rakesh,
Keep in mind the init parameter MAXDATAFILES when you initially build
your database. If the original database was built with a small limit
then you will have to rebuild to change the MAXDATAFILES parameter.
Search the metaslink site for information on changing the parameter if
you think
Can anyone recommend and low cost tool(s) for load testing a database
server? I looked at Quest's Benchmark Factory, but it doesn't provide
the flexibility I need in this situation I'm facing The $15K I was
quoted for the Quest tool is a bit pricey, so I don't believe more
expensive tools
The low cost testing tool that will do the job is called sqlplus.
Just develop your scripts and fire away
-Original Message-
From: Ed [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 8:23 AM
To: Multiple recipients of list ORACLE-L
Subject: Load Testing Help Needed
Check out Craig Shalamahar site
www.orapub.com under tools. He got a free loadtesting
tool.
Cheers,
RS
Can anyone recommend and low cost tool(s) for load
testing a database
server? I looked at Quest's Benchmark Factory,
but it
doesn't provide
the flexibility I need in this
Ed wrote:
Can anyone recommend and low cost tool(s) for load testing a database
server? I looked at Quest's Benchmark Factory, but it doesn't provide
the flexibility I need in this situation I'm facing The $15K I was
quoted for the Quest tool is a bit pricey, so I don't believe more
]]
Sent: Mon, February 18, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject: help needed
Hi folks !
I have some constants value i want to show then in tabular format with
two cloumns and n rows
is it possible to get them through in that way by manipulating SQL
PROTECTED]]
Sent: Mon, February 18, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject: help needed
Hi folks !
I have some constants value i want to show then in tabular format
with
two cloumns and n rows
is it possible to get them through in that way by manipulating SQL
Hi folks !
I have some constants value i
want to show then in tabular format with two cloumns and n rows
is it possible to get them through in that
way by manipulating SQL statements i dont want to define user defined data
type
i want the sql to be written in way that it
ud give me
Title: LOB Help needed
Hi,
Has anyone any document about implementation of Lobs/BFILES using Oracle Developer 6/6i as front end tool. Manulplating LOBs within the database is not a big problem, but getting them out to display it is what I need. I have found a doc which explains
Hallo,
anyone who canhelp me with this?
I have PL/sql procedure and if something goes wrong I would like the following things
to occur. Please help me with them
If some errors occur I want this to happen.
- pick out the name of the procedure thatis currently running,
-pick out the
Hallo,
anyone who canhelp me with this?
I have PL/sql procedure and if something goes wrong I would like the following things
to occur. Please help me with them
If some errors occur I want this to happen.
- pick out the name of the procedure thatis currently running,
-pick out the start_time
Alan,
What do you mean the file is to large for vi? If you are going to string the lines
together be sure that you don't overrun the linitations of the server input line
length. If you need to have continuations in the line I think that the \ tells the
server the command is continued on the
Title: UNIX help needed for sed multi-line pattern space
Alan,
Why not use awk?
cat filename | awk '{if (
substr($0,length($0),1) == ";") {print " " $0 } else {printf($0)
}}'
Hope this helps
Chris
-Original Message-From: Martin, Alan
[mailto:[EMAIL
Hi,
I'm in the middle of a conversion and something is holding the conversion
program:
v$session_wait:
Enter value for sid: 285
SUBSTR(EVENT,1,20) SUBSTR(P1TEXT,1,30)SUBSTR(P2TEXT,1,20)
--
SUBSTR(P3TEXT,1,30)
Jeroen
it might indicate that your batch program is busy and
doing stuff. the wait event you have mentioned is a
idle wait event. In your next run, i would recommend
that have breakpoints coded in the batch that writes
into a error/log table about status and where the pgm
has reached. also write
Background:
We have 2 databases (7.3.4.5) on aix 4.3.3. When executing the strings command
(strings system.dbf | pg) on one of the database's datafiles it returns the
database and the
oracle_home location. For example:
prdr:/optc/oracle/rdbms/7.3.4
The other database does not display this
Title: Help needed
HI DBA Guru's
It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I
RTFM on auditing - this should provide all that you need. A good start would
be to read:
Oracle Concepts Guide - Chapter 28 - Auditing.
HTH
Mark
-Original Message-
Sent: Tuesday, August 07, 2001 09:00
To: Multiple recipients of list ORACLE-L
HI DBA Guru's
It has been a painful
Title: RE: Help needed
If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise.
rgds
amar
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE
look up auditing it is your friend ;)
joe
Deewaker G.V. wrote:
HI DBA Guru's
It has been a painful process for me everytime when I change the
password of the user in ORACLE.. The reason is simple Some one is
trying to play with the tables and change the INDEXS... delete the
Deewaker,
you can run the listed srcipt to find the users that are connected to your server.
With a little modification you can get all of the information you need.
ROR mª¿ªm
+ user1.sql++
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT
COLUMN OSU
If I understand the question, he wants the time to always be
one-minute-to-midnight, and just insert dates. This can be done with a
trigger.
g
-Original Message-
Sent: Tuesday, July 03, 2001 10:56 PM
To: Multiple recipients of list ORACLE-L
Harvinder,
If you want time in a date
Hi,
I have a table with colum defined as date datatype..for
example
create table dd(dd date);
when we insert into this table like :
insert into dd values('04-jul-01');
when we do select as:
select to_char(dd,'DD-MON- HH24:MI:SS') from dd;
the result displayed is :
TO_CHAR(DD,'DD-MON-Y
Harvinder,
You never inserted the time component of the date so how can you get it
from the database. Either explicitly insert time component or if possible
use a la sysdate/now (datetime function of your tool) when inserting a date.
Shailesh
-Original Message-
Sent: Tuesday, July
hello Siva,
You can concatenate raw SQL_TRACE files as a single file, then upload this
file to itrprof.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 2:30 AM
Hello Gurus,
I was trying to pull distinct sql's and their
Hello Gurus,
I was trying to pull distinct sql's and their total execute count from a
bunch of 250 trace output files(output from tkprof trace files). How can I
achive this. What i need the cumulative sum of execute count from different
files for each sql's.
As u all know sql can extend more
Hi, Sinha
indexing = for easy searching something like building table of content in
your book
sorting = you know SORT
hasing = using sort of formula for search particular item, there will be
hashing algorithm here
Have a nice day
Sinardy
-Original Message-
Sent: Friday, 4 May 2001
My goal is to have Oracle user JOHNQPUBLIC bounce a database from the
local host or remotely. Any UNIX account for that user would NOT be part
of the DBA group.
I performed the following steps:
orapwd file=$ORACLE_HOME/dbs/orapwXXX password=YYY
$ ls -l
-rwSr- 1 oracle dba
Title: RE: Urgent - Help needed - Reports
Hi,
Thanks for ur reply.
The printer drivers are installed on the server, is there any specific settings/configuration to be done on report server/builder?
-Original Message-
From: Dasko, Dan [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 16
Title: Help needed - Reports
Hi all,
C:\RWCLI60 REPORT=d:\oracle\oas408\report60\test.rdf [EMAIL PROTECTED] server=rep60_mp5main destype=Printer desname=\\RRSRV\RR_Printer,172.17.1.204: schedule=every_1_minute_from_now Jobname=testjob05
When i execute the above statement (used to put
1 - 100 of 103 matches
Mail list logo
