Do you know initcap function?
SELECT INITCAP('the soap') Capitals FROM DUAL;
Capitals
-
The Soap
-Original Message-
Sent: Thursday, September 12, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L
Far be it from me to call you a dinosaur, but it is my personal opinion
There is also a copy table command in SQL.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 12:30 AM
How do I copy all data in one user's table to another user's table?
Regards,
David
--
Old stuff. Happens all the time.
Start stopping services on the machine and do retry until it works.
You get to services via: startsettingscontrol paneladministrative
toolsservices.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
no chance of me getting to either Cary, I am in the UK and our
training/seminar budget isn't exactly huge at the moment :-)
Regards
Lee
-Original Message-
Sent: 11 September 2002 16:39
To: Multiple recipients of list ORACLE-L
Lee,
Just to prevent any confusion: We are having a
Hi Dan
It should be possible to open that database !
1) You should restore the databse from tape once more to make sure we
start on somthing clean.
2) Add the _allow_resetlogs_corruption=true to the parameter file (init.ora)
3) Mount the database and create new controlfiles
4) Do a fake
Sivan Rabinovitz[SMTP:[EMAIL PROTECTED]] wrote:
Do you know initcap function?
SELECT INITCAP('the soap') Capitals FROM DUAL;
Capitals
-
The Soap
OK, how about Jaap van der Meer. Or any of a thousand other real-world
names that people, places and events have. Bottom line is
A classic example :
I got an e-mail this morning asking me to recreate a table with bigger
initial and second extents because they have bad response times. They talked
to the DBA ?? and he told them that it is because the table have many
extents. Checked the table. It has a lot of extents - 6.
From: Stephane Faroult[EMAIL PROTECTED]
Date: Wed, 11 Sep 2002 11:24:50 UT
Subject: RE: Index table last update?
- Original Message -
From: O'Neill, Sean [EMAIL PROTECTED]
Sent: Wed, 11 Sep 2002 03:13:21
Is there a way to determine when an index table was
last updated?.=0D
The answer
I
would be curious to hear what Oracle Support suggests, Dan.
Regards, Patrice Boivin Systems Analyst
(Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques Informatics
Branch | Direction de
l'informatique
When the row is moved to another block.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 5:28 AM
what are the cases for a rowid to be changed ?
Regards,
Prakash.
--
Please see the
Murphy's law expansion for writers:
When a writer receive his new book from print, he will always open it in the
place with the worst errata.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 4:08 AM
If I remember correctly netbackup can restore oracle DB only to the original
machine.
By setting this environment variable you trick it to think that this is the
original machine.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Use map network drive on your target machine and define the drive as a
directory on your recovery machine.
I mean: map drive K on the target machine as f:\backup on the recovery
machine.
Then backup to drive K.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
We are currently having a character set problem. We have a
third-party product that is used for on-line courses (Prometheus from
Blackboard, Inc.). The character set that the instance was created with
was US7ASCII. The vendor says it should be WE8ISO8859P1, but we need to
support Chinese
Title: RE: User-defined functions in WHEN clause of a trigger
Rich,
Remove the when clause from trigger definition and put it inside.
CREATE OR REPLACE TRIGGER my_trigger
BEFORE UPDATE ON my_table
FOR EACH ROW
BEGIN
If my_function = some_value then
do_something_meaningful;
end if;
end;
Hello Chetan
I think that you need to have administrator permission on the NT domain to
be able to logon as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 2:38 PM
Hi List ,
I have
Jarad,
Has there been a second printing already? I don't see the first two
errata you mention in my copy. The third one wasn't there, but your
notes just say it may need to be added, not that it will. :)
PAX,
John P Weatherman
Database Administrator
Replacements Ltd.
-Original
Scott,
You can only use the alter database command to move from one character set
that is a strict superset of your current character set. You can find
lists of superset relationships on Metalink. Search on something like
character set conversion and superset or UTF8 and WE8ISO8859P1.
You
NO
Yechiel AdarMehish
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Monday, September 09, 2002 5:18
PM
Subject: RE: test - please ignore
Can
you hear me now
Good
;o)
-Original
Well said, Philip. I have always used mixed case for the actual data stored
in the database and have never encountered a problem, except the index issue
you mention, and as you say, function-based indexes cure this problem.
If you uppercase the data on storage and rely on initcap to replicate
Check out the number of processes init.ora
parameter against open connections.
You may have run out of available processes.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 12, 2002
On Mon, Sep 09, 2002 at 09:53:26AM -0800, Ray Stell wrote:
Since I can't make a snapshot of a remote partition (this is really
what I wanted in the first place), I make a snapshot on the remote
machine first and then snapshot the remote snapshot.
--
snapshot of a snapshot is unsupported pre
You are not, but you can call his highness and then HE can kill the
sessions.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 5:13 PM
How are you going to kill another session without a DBA role?
Steve,
From one dinosaur to another, let them have mixed case.
Dick Goulet
Reply Separator
Author: Steve McClure [EMAIL PROTECTED]
Date: 9/11/2002 5:38 PM
I just had a heated, well perhaps not heated, but certainly adversarial
discussion with
Somebody say something???
peter
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: 12 September 2002
14:54To: Multiple recipients of list ORACLE-LSubject:
Re: test - please ignore
NO
Yechiel AdarMehish
- Original Message -
From:
The initcap function can work pretty well in a lot of cases but those
exceptions can be major. I remember there being discussions on this
list about how does one handle names starting with Mc or Mac. At the
time the original post came in I was dealing with some strings that
included the degrees
Thank you Stephane! Your final idea of FIRST_ROWS as a winner! Oracle
slapped the data back in just a second. Thanks everyone for the ideas to
try.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 10, 2002 3:42
Use auditing, or include timestamp column in your table.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 6:53 AM
From: Stephane Faroult[EMAIL PROTECTED]
Date: Wed, 11 Sep
Hello All;
I am being plagued with an error I can't get my hands around when I try to
recreate a context index. The index existed previously, but when I tried to
sync new data I got an error, then I attempted rebuilding the index from
scratch and got the same error (see below). I checked the
Geraldo,
Thanks for the advice. It's interesting that the Migration manual states
something like the only difference between 32 and 16 bit is the PL/SQL
compiled code - there is no difference in the data files. Since it all gets
recompiled anyway, I was wondering why we could not go directly
Steve,
I agree with what everyone said here. The data should be stored as the user
enters it. I regularly add additional columns to database table that will
take a name field, upper-case it and remove all punctuation for sorting
purposes. I do this with a database trigger, so applications do
God morning Dan,
I prefer to read the morning mail, especially from here, before posting an
answer just in case someone else has the same idea. But in this case I saw a
close one, but not the exact one. Where you've got a problem here is that
you've lost the damned control file. In that
Title: RE: mixed case text
SELECT INITCAP('mccoy') McCoy FROM DUAL;
McCoy
-
Mccoy
Better hope your name isn't Hatfield!
(Alluding to the famous Hatfield-McCoy feud in the USA a few years ago).
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
Grant - I have never encountered this one in Oracle. Are you receiving an
Oracle error number? It makes me wonder if it is a Cold Fusion message. Have
you received it outside of Cold Fusion? Check the Oracle logs, alert_log,
dump files, trace files. Check to see if there is a timeout parameter in
Hi DBAs,
I would like to analyze a few tables in production. My question does it
prevent any type of access i.e.,apply locks? If so I can wait to do it off
hours.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City
Grant,
ColdFusion does not use Oracle natively, but through ODBC. I have seen this
in the past and it's an ODBC setting that's causing the problem. Find out what
ODBC driver their using. Look for a timeout setting, I know that DataDirect
driver has one on the general panel.
Dick Goulet
One DBA to rule them all,
One DBA to define them
One DBA to kill sessions and replaceable parameters bind them.
-Original Message-
Mladen
Sent: 11 September 2002 16:14
To: Multiple recipients of list ORACLE-L
How are you going to kill another session without a DBA role?
A command
IMHO, I prefer to use both, mixed case text for reports, etc. and upper case text for
searches, etc. What's a few more characters in the db when it keeps everyone happy :)
Gene
[EMAIL PROTECTED] 09/12/02 10:18AM
Steve,
From one dinosaur to another, let them have mixed case.
Dick
Dear friends!
I have no idea in LDAP , but have been assigned to find out how much time it
takes to do a LDAP update operation?
Anyone got any clue ?
Thanks a lot in advance vor your help !
BTW, Can you please also recommend some LDAP intro readings .
cheers.
DBAndrey
* 03-9254520
*
Initcap?
What about:
abc garage
att
Mcneil and McNeil
Sivan Rabinovitz [EMAIL PROTECTED]@fatcity.com on 09/12/2002
03:33:18 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Do you know initcap
Are there any simple tools to query a database [SQLServer or Oracle]
and present the results in a Graphical format --- e.g. the database could
contain HelpDesk Call logs and a display could be an Ageing Report
or Call Rate.
Hemant K Chitale
Now using Eudora Email. Try it !
My home page is :
Jared, didn't you mean:
select
chr(84)||chr(104)||chr(97)
||chr(110)||chr(107)||chr(32)
||chr(71)||chr(111)||chr(100)
||chr(33)
from dual
Just being picky... :D
Rich Jesse System/Database Administrator
[EMAIL
Good example! ;=) Thanks, Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 3:38 PM
select decode(new_job_loc,'Vermont','TAKE IT','LEAVE IT') from dual;
Waleed
-Original Message-
Sent: Wednesday,
Check on MetaLink note: 147362.1;
also extproc might have been deleted (see Security Alert 29)
inka
-Original Message-
Sent: Thursday, September 12, 2002 10:33 AM
To: Multiple recipients of list ORACLE-L
Hello All;
I am being plagued with an error I can't get my hands around when I
Beware...nasty sql below
select decode((select deptno from dept where upper(loc) = upper('vloc')),
-- expression
(select deptno from dept where loc = 'NEW YORK'),
-- value1
(select count(*) from emp where deptno = 10),
-- return1
(select deptno from dept
Rick:
I've had problems trying to slip in an analyze on an index during
production hours. Our on-line users will see timeouts if the analyze is
lengthy. I assume analyze table will cause the same problem.
I decided to prove my case by analyzing a table and the looking for locks.
I didn't see
I've tried several approaches to the recovery. So far, no success. I have a
feeling that this is a truly unrecoverable db (without having Oracle Field
Support use their magic).
The main problem (in my mind) is that the current database physical
structure (files and sizes) does not match the
here's a decode that should *NEVER* be put into production! :)
-Original Message-
Sent: Thursday, September 12, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Beware...nasty sql below
select decode((select deptno from dept where upper(loc) = upper('vloc')),
-- expression
Hi List,
I have to make a presentation to the company's CEO
about several strategies to implement a FailOver for
an Oracle Server, this is the environment:
DB Server: Sun Enterprise 3500 Solaris 5.7 with an
A1000 StoreEdge Array (0+1), Oracle 8.0.6 EE
App Server: Sun Enterprise 3500 Solaris
Anybody have experience with stress testing software for Peoplesoft? Links,
thoughts, comments etc...
Thanks,
Ethan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Actually, the rowid will not change when a row is migrated. The original
rowid is preserved (for indexing purposes) with a pointer to the new row.
The rowid referenced by functions will be the original rowid.
I performed a test about a year ago that covered this scenario. I found that
when you
Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle 9 has ONLINE
option which allows DML while analyzing table...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 12 Sep 2002 06:33:29 -0800
Hi DBAs,
I would like to
Dan - When you say recreate a control file are you meaning the CREATE
CONTROLFILE statement? If so, then in answer to that specific issue, the
order of the datafiles does not matter. I do this regularly to create test
databases and I've never worried about making the order the same. I have
even
Gabriel - Are you just talking about failing the database over to a hot
standby database, and the users would have to be notified to log off and log
on the standby, or are you thinking about automatically failing their
connections over as well? The latter depends on what access methods they
use.
Dan,
I think there is a difference between migrated and moved.
Migrated in my mind refers to a split row - because an update could not fit
in the same block as the record.
Moved in my mind means deleted and re-created, or performed because of an
Alter Table {} Move Tablespace command.
Tom
Database 8.1.7
Cloning a database that was brought down using shutdown abort.
I know I have done this before and I can't remember what I had to do to resolve this.
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE TEST RESETLOGS
Title: RE: Decode
Wait till you see some of the SQL that we run ... it is dynamic sql used within SQR (a reporting tool). Compared to that, this is production quality.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
Gurus,
I need to implement a process to startup/shutdown a PeopleSoft Unix batch
scheduler job whenever the Oracle instance is shutdown or started back up.
Does anyone know of a way to tie this process to an Oracle Instance to get
invoked at shutdown/startup time?
Willie Townsend
Alverno
For some reason it would appear that you don't have the complete set of online
redo logs.
Dick Goulet
Reply Separator
Author: Kathy Duret [EMAIL PROTECTED]
Date: 9/12/2002 10:38 AM
Database 8.1.7
Cloning a database that was brought down using
What I do and have just done a couple of days ago is copy your latest redo
log into the suggested name below
'/u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf'
and do your recover again. Worked fine for me
HTH
Lee
-Original Message-
Sent: 12 September 2002 19:38
To: Multiple recipients of
I think you need the online redo log file that was current when you did
shutdown abort.
This is provided it was not recycled!
Waleed
-Original Message-
Sent: Thursday, September 12, 2002 2:38 PM
To: Multiple recipients of list ORACLE-L
Database 8.1.7
Cloning a database that was
Title: RE: Decode
Raj,
I know
SQR. Bought it when it was being peddled by Sql Solutions. Great
tool! Somehow, it never got marketed correctly. I had heard that at
one point, Oracle "almost" bought it, and was going to position it as one of its
products. But that boat has sailed.
Tom
Willie - At our site we have a Unix startup and shutdown script tied into
the system startup/shutdown scripts. You could use the same mechanism.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, September 12, 2002 1:13
O'Neill, Sean wrote:
From: Stephane Faroult[EMAIL PROTECTED]
Date: Wed, 11 Sep 2002 11:24:50 UT
Subject: RE: Index table last update?
- Original Message -
From: O'Neill, Sean [EMAIL PROTECTED]
Sent: Wed, 11 Sep 2002 03:13:21
Is there a way to determine when an index table
I agree with Mark on this. I had this problem on a 8.1.7.0 and it was solved
after the upgrade. (8.1.7.3)
If you're already above 8.1.7.3, the problem could be fragmentation.
Are you having any contention in the shared pool latch?
greetings
DC
- Original Message -
To: Multiple
Tom,
I completely agree with your point. It is one of those semantic
issues that always seems to cause so many problems ('Do what I meant, not
what I said'). So, Yechiel, did you mean move as in migrate or move as in
recreation of the row?
Dan
-Original Message-
Sent: Thursday,
Townsend Willie wrote:
Gurus,
I need to implement a process to startup/shutdown a PeopleSoft Unix batch
scheduler job whenever the Oracle instance is shutdown or started back up.
Does anyone know of a way to tie this process to an Oracle Instance to get
invoked at shutdown/startup time?
Let me clarify a bit. I cloned the database from coldbackup .
I opened the database fine, but I goofed up the name. I shutdown the database, it
hung so I
did a shutdown abort and forgot to open it up normally before I tried to rename the
database.
I don't have any archive files created by
its 8.1.7.4
From: Mark J. Bobak [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: ORA-04031
Date: Wed, 11 Sep 2002 21:08:18 -0800
Um, version? (To at least 4 places, please!)
On the off change you are on 8.1.7.x, where x 3,
Andrey Bronfin wrote:
Dear friends!
I have no idea in LDAP , but have been assigned to find out how much time it
takes to do a LDAP update operation?
Anyone got any clue ?
Thanks a lot in advance vor your help !
BTW, Can you please also recommend some LDAP intro readings .
Tom,
I regret to say that SQR is still running around. SOD awful piece of crap
that should have dies along with RPT and RPF. PeopleSoft makes a lot of use of
it it is a REAL performance boat anchor.
Dick Goulet
Reply Separator
Author: Mercadante;
select * from v$logfile. Specify the current logfile.
From: Kathy Duret [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: recovery question - I know I am missing something
Date: Thu, 12 Sep 2002 11:08:33 -0800
Let me clarify a
Can you say moo-cow.
This is most likely
http://www.foremostfarms.com/aboutus/contacts/contact.asp, and if so, I
think they have been trying to fill it for about 9 months. H, wonder
why?
Hi Dennis, at this moment I dont have users making
conections directly to the DB, only the application
connects to the DB, so the users access only the
application and I'd have to shutdown the app first of
all.. I think that something like the first option is
what I need..
Gabriel
--- DENNIS
Actually, if a row is migrated it keeps the same ROWID it has before the
update.
HTH
DC
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 3:03 PM
Dan,
I think there is a difference between migrated and moved.
Make sure you're LISTENER and tnsnames.ora have PLSExtProc set-up.
I have a separate listener for PLSExtProc:
listener.ora
LISTENER_PLS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY =
As one who has been there, I can sympathize. I had a TAR open for months
going back and forth with Oracle Support. The entire problem boiled down to
the fact that Oracle Corporation does not have a supported method
(supported is the key word) to query the free chunks of the shared pool to
Well, if we're going to be picky :)
select chr(84)||chr(104)||chr(97)
||chr(110)||chr(107)||chr(32)
||chr(71)||chr(111)||chr(100)
||chr(101)||chr(115)||chr(115)
||chr(33)
from dual
Jared, didn't you mean:
select
Kathy,
Let me clarify a bit. I cloned the database from coldbackup .
I opened the database fine, but I goofed up the name. I
shutdown the database, it hung so I
did a shutdown abort and forgot to open it up normally before
I tried to rename the database.
I don't have any archive
Thanks Dennis!
I may have to do it as you suggested. I was hoping there was a way to
automatically shutdown/startup Unix script if I shutdown Oracle via srvmgrl
command line prompt. For instance, if I executed 'shutdown immediate', this
would invoke command behind the scene to
stop the
Dick,
But is was a fun tool to program in! It was so string in that it (at the
time) was the only tool that could interface with OS files, Oracle, and
produce output at the same time. We bought it instead of RPT and RPF. I
almost had a heart-attack when Oracle classes showed us those POC and
Why yes I can: M-cow
Actually, the Dells area (Baraboo is a few miles south) is pretty nice if
you're an outdoorsy-type. Or if you just like to live in or near a town
that's one big waterpark (including the largest waterpark in the USA). It's
about 40 minutes from Madison and 5 minutes
Anyone got a script or scripts for setting up VERY SIMPLE replication(one
master site, one snapshot site) in 8.1.7? Including those pesky dblinks?
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services
Thanks Stephane!
As you alluded to, ideally, I want it to work automatically even when I do
manual shutdown/startup via svrmgrl etc. I will explore your suggestion of
triggers/external function etc.
Willie
-Original Message-
Sent: Thursday, September 12, 2002 2:44 PM
To: Multiple
Hi DBAs,
I have a query something like
SELECT sysdate,'txt1','txt2'
FROM dual
UNION
SELECT date1,txtfield1,txtfield2
FROM t1,t2,...,tn
WHERE
... ;
The output would be one header record from the first select then the data
from the second select.
If there are no records selected in second
OY, sounds like FUN, sign me up!! EY Yup *-)
Dick Goulet
Reply Separator
Author: Jesse; Rich [EMAIL PROTECTED]
Date: 9/12/2002 12:58 PM
Why yes I can: M-cow
Actually, the Dells area (Baraboo is a few miles south) is pretty nice if
you're
Sorry about the lack of photo's. :)
There's already some errata. sigh...
Maybe you can upload to your website ;-
Enquiring minds want to know.
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network
Title: RE: SQL help
Not tested but
select sysdate, 'test1','test2'
from dual
where exists ( your union clause)
union
your_union_clause
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion
I ended up giving it one of the log files but they all said stale so it took me a
couple of tries.
Thanks!
Kathy
-Original Message-
Sent: Thursday, September 12, 2002 11:38 AM
To: Multiple recipients of list ORACLE-L
Database 8.1.7
Cloning a database that was brought down using
For the archives: From another list, found out there is a known bug:
It's a known problem with Forms 6 vs Oracle9i. See Oracle MetaLink bug
number 2052790.
It hasn't been updated since February but it references bug 2166890 which I
cannot access.
DDL COMMAND HANGS IN SQL*PLUS IF THE TABLE IS
Title: RE: SQL help
Rick,
Is this in SQL*Plus? If so, use the COLUMN command to
populate the column headings with the information you want. You can populate a
variable with SYSDATE and use that in the column heading.
Dan
-Original Message-From: Jamadagni, Rajendra
Hi all,
I did a select sysdate from dual, and got 04:09:39 pm,
but my machine system time is 4:47pm, which is right.
SQL select to_char(sysdate,'mm/dd/yy hh:mm:ss am')
from dual;
TO_CHAR(SYSDATE,'MM/
09/12/02 04:09:39 pm
How did Oracle get the time? What needs to be set
Your format is asking for the month instead of the minutes
Hi all,
I did a select sysdate from dual, and got 04:09:39 pm,
but my machine system time is 4:47pm, which is right.
SQL select to_char(sysdate,'mm/dd/yy hh:mm:ss am')
^^
should be mi
X$KSMLRU is the free list chunks.
On Thu, 2002-09-12 at 17:03, Jesse, Rich wrote:
As one who has been there, I can sympathize. I had a TAR open for months
going back and forth with Oracle Support. The entire problem boiled down to
the fact that Oracle Corporation does not have a supported
Leslie,
Hint #1: Try 'mm/dd/yy hh:mi:ss am' for your format string.
Hint #2: 'mm' is month, 'mi' is minutes.
Hint #3: As September is the 9th month, I think your output makes
sense. ;-)
(I remember making this mistake, oh, probably more than 10 years ago, on
version 6. Some things never
Prior to Oracle ver 9 , yes.It is an exclusive lock ...Oracle
9 has ONLINE
option which allows DML while analyzing table...
Mohammed,
Have to differ with you on this - ANALYZE may place a DDL lock, but not a
DML lock. This would have otherwise severely restricted concurrency. Should
be
If I recall the original problem, you have a backup of the datafiles, and redologs,
but no controlfiles. In that case, just specify all the datafiles and redologs (that
are in the backup) in the create controlfile... statement.
The order does not matter, nor is the list required to be
Also check out Metalink note 146599.1 which is on diagnosing ora-4031 errors.
This has helped me.
Also you can consider adding an event in your init.ora file like 4031 trace name
errorstack level 3
This will dump an errorstack when the 4031 error occurs - this can be interpreted by
Oracle
Scott,
1) I have to agree with Oracle's statement that you need to have a UTF8
database to handle Chinese and Japanese characters. These characters
require multi-byte encoding to be stored and therefore a UTF8 database
is the way to go.
2) I am not sure where the Chinese and Japanese
Hi
I want to convert SQLSERVER DBs to ORACLE DBs? HOw to convert DBs it?
To import objects I have created one scripts but how to import data into
ORACLE DBs.
Thx
-Seema
_
MSN Photos is the easiest way to share and print your
1 - 100 of 105 matches
Mail list logo