I posted the note below a few weeks ago, hope it helps
John
Listers,
Here is a little summary of commands to identify the bit version of an o/s
and 2 methods of identifying whether a database is a 32 bit or 64 bit
installation
Operating System
Compaq Tru 64 - will be 64 bit
HP-UX
Heh heh,
Just popped in for a quicky !!!
Regards
Lee
-Original Message-
Sent: 03 October 2002 19:29
To: Multiple recipients of list ORACLE-L
Lee, you're alive. I'll let the OT list know! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Leslie,
Did you check your oradim.log? What it says?
Also, you may check that your ORA_instance name_PFILE parameter in
registry points correctly to your pfile.
Yulduz.
-Original Message-
Sent: Thursday, October 03, 2002 3:41 PM
To: Multiple recipients of list ORACLE-L
Thank
What follows might be all hogwash, you could have
tried this:
DECLARE
devtype varchar2(256);
doneboolean;
BEGIN
devtype := dbms_backup_restore.deviceallocate('',
params='');
dbms_backup_restore.restoresetdatafile;
dbms_backup_restore.restorecontrolfileto('/tmp/foo.bar');
I know this has been discussed before and I have monitored the discussions
but I am not sure that I have seen a clear summary
and set of conclusions.
I am trying to identify how much memory is used by the instance and all
connections.
I can show sga to give a total memory of the base instance
Qs Is Wait Event queue messages any Cause for Concern ?
Qs If so What is the Resolution for the Same ?
Qs Any Links , Docs for the Same ?
Top 5 Wait Events
~ Wait % Total
Event Waits
Kirti,
They won't pay relocation, and they don't want someone who is going to
be commuting back home on weekends 'cause they might need that person
on a weekend :)
Rachel
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
Rachel,
I don't mind getting that experience first hand ;)
But why
yea the last question was rhetorical, i'd forgotten to back up the
control file, a hole in my backup strategy.
joe
DENNIS WILLIAMS wrote:
Joe - You da man. An impressive tour de force in working around RMAN. Was
your last statement rhetorical? I think you answered that question - that
you
Connor, my problem(fault) was I didnt make a copy of the control
file(and in 8.1.7, you don't get it backed up by default like in 9i,
right?).
I attempted to bring the db in nomount and restore the control file,
rman reply no controlfile backup found.
joe
Connor McDonald wrote:
What
Hi
Qs What do you mean by raw(4) / raw(8) ?
Does it mean Length of the Field Data Value ?
From my Database :-
SQL select saddr from v$session where rownum 2
2 /
SADDR
313941C0
CASE - Assuming on receiving a Database from a 3rd party
1) My Existing Installed ORACLE_HOME
Qs Why is the Followign Query being parsed 3 Times ?
SELECT ORDER_ACTION_ID
FROM
TASK_LOCATION_DETAILS WHERE ORDER_ACTION_ID='7118439A1' AND LOCATION_CD='B'
AND LOCATION_ID='LOCALNSTRTT' AND KIND_OF_INFO='A'
call count cpuelapsed disk querycurrentrows
Isn't the object point in time recovery called LogMiner? :)
-Original Message-
Sent: Thursday, October 03, 2002 5:11 PM
To: Multiple recipients of list ORACLE-L
You are lucky to have all your databases in archivelog mode. We have large
datawarehouses here, where business is quite
Ask the person that sent it to you?
On Thursday 03 October 2002 23:53, VIVEK_SHARMA wrote:
Given a Database . It is 32 Bit or 64 Bit , how can it be found ?
Assuming Cold Backup of Database Sent from Elsewhere
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared
Whoever takes the job, make sure you use spell checker!!
;o)
-Original Message-
Sent: Thursday, October 03, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L
well, if it's what I think it is (although I didn't know it went to
Orastaff), it's working with me :)
--- [EMAIL
Probably arguments both ways however if you have existing support from
Oracle I would be inclined to upgrade to the terminal release of 8i since it
will lengthen your support window (8i desupports Dec 2003). We have had to
patch up to 8.1.7.3 for a few applications although we are running on
This is related to the AQ mechanism and can be ignored. Oracle posts this
wait while waiting to dequeue a message from AQ queue.
To remove it from the 'Top 5' list in statspack report, you can add a row to
perfstat.stats$idle_event table. And while at it, you may want to review
what other waits
Dennis,
I guess you just gotta have faith after a complete test of various types of
recovery that the software works. Once it passes all your tests, and you
are comfortable that it orks as advertised, it's just a matter of going for
it.
I am also convinced that Oracle support is able to help
How about aliens, of the extraterrestrial kind.
-Original Message-
Sent: Thursday, October 03, 2002 4:11 PM
To: Multiple recipients of list ORACLE-L
and if it's what I think it is.. the job spec is wrong and while there
is no relocation package, we did NOT say locals only
and we have
RAW is a datatype in oracle. Do a
describe which gives the details of an object. For a table/view it tells you
about the columns.See the TYPE, which tells you about the datatype of
the column. If it is RAW(4) it is 32-bit, if RAW(8) 64-bit.SQL desc
v$session;Name
Null?
Hi All,
I am not very clear on how the Multiple Oracle Homes' concept works. Does
one need an ORALE_HOME and ORACLE_SID environment veriable with appropriate
values ONLY when starting the DB instance, or launching an application that
uses these variables? Are these environment variables
Here is an example from 8.1.7.4
oracle@loki:/orabak rman nocatalog
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN connect target /
RMAN-06005: connected to target database: LIVL
(DBID=750735866)
RMAN-06009: using target database controlfile instead
of recovery catalog
RMAN run {
2
you need to 'describe' v$session, not to 'select' from it
SQL desc v$session
-Original Message-
Sent: Friday, October 04, 2002 8:08 AM
To: Multiple recipients of list ORACLE-L
Hi
Qs What do you mean by raw(4) / raw(8) ?
Does it mean Length of the Field Data Value ?
From my
One of the local dbas said to me recently that Oracle docs
indicate that cold backups are required. I did a search and
could not find what he was talking about. Anyone got such a
reference?
On Thu, Oct 03, 2002 at 09:38:20PM -0800, Jared Still wrote:
OK, Gene, you asked for it. :)
Rachel,
Well, I for one will not apply. First off I've no use for NYC. Been there
once in my life have absolutely no desire to return. I thought people in
Boston were rude, was I ever in for a shock! Second, two bull headed people
like us could never work together and live. One of us
The controlfile gets backed up automatically when you do a RMAN full backup.
I have been having a debate this morning regarding a situation where we do
weekly full backups using RMAN and and a daily RMAN archivelog all delete
input.
I contend we should do a archivelog all delete input INCLUDING
the subject line pretty much describes it.
9.2.0.1, Solaris 2.8
We are using the ANYDATA datatype and while we have no problems with
insert or select or delete, the process blows up (ora-7445, coredump)
when we try to update the ANYDATA column. Within a PL/SQL process,
using aliased tablenames
HI all
We had those messages yesterday in the listener.log
file
TNS-12500: TNS:listener failed to start a dedicated
server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Also on the unix
sql server 7???
and you are trying to find an answer on Oracle
board?
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Santosh
Varma
To: Multiple recipients of list ORACLE-L
Sent: Friday, October 04, 2002 2:23
AM
Subject: RE: Sql query
I haven't really been following this thread closely but whenever you do a
level 0 rman backup it will include the controlfile. If you need to recover
to a point in time you can recover using backup controlfile to that point in
time.
HTH,
Ruth
- Original Message -
To: Multiple recipients
lol, OK my reasons for occasional cold backups. As a prior sysadmin, I prefer single
user mode full filesystem backups (i.e. databases shut down) prior to any upgrade
whether its an application, database, or operating system. There are benefits of cold
over hot backups (of course this
Darn!
Besides I won't be qualified based on this requirement:
Must have 5+ years Oracle 8i DBA (development and production
support) experience.
:(
-Original Message-
Sent: Friday, October 04, 2002 6:08 AM
To: Multiple recipients of list ORACLE-L
Kirti,
They won't pay
If you try to run sqlplus or any other sql utility on the database without
those environment variables set, it won't know where to look for the
utilities or where to look for a database whose name it doesn't know. Your
best bet to see exactly what it does is do what you are describing and try
to
When you are doing point-in-time recovery you have to use the backup
controlfile anyway and start with a level 0 which has the backup controlfile
and roll forward using incrementals or just the archivelogs. I don't know
if this answers your question but I will be glad to try again with more
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To: Multiple recipients of list ORACLE-L
sql server 7???
and you are trying to find an answer on Oracle board?
Igor Neyman, OCP DBA
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
- Original Message -
To: Multiple
Anyone knows how to get rid of a column default value ? I rtfm and search
metalink with no luck.
Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
I never heard that, and I never do them, except my recovery catalog database
which I can shut down.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 10:03 AM
One of the local dbas said to me recently that Oracle docs
Secretly recorded conversations by FBI between Rachel and her ex-junior DBAs
What do you mean you don't have a version of this script for Oracle 5, 6, 7.1.6,
7.3.4, 8.0.5, 8.1.5, 8.1.7, 9.0.1, 9.2??? I have a version of every one one of my
1,831 scripts for Oracle 2.1 through pre-beta
Oracle 6 and prior releases required cold backups. Hot backups became available in
version 7. The trend appears RMAN is the new way! Still waiting for Robert Freeman's
new book :).
Gene
[EMAIL PROTECTED] 10/04/02 10:03AM
One of the local dbas said to me recently that Oracle docs
My guess is to alter it DEFAULT NULL.
Michael Armstead
Principal Database Administrator, OCP-Certified
World Wide Corporate IT Database Administration
GlaxoSmithKline
-Original Message-
From: Louis BROUILLETTE [SMTP:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 11:29 AM
ARE YOU AN IDIOT
-Original Message-
Sent: 04 October 2002 16:13
To: Multiple recipients of list ORACLE-L
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To: Multiple recipients of list ORACLE-L
sql server 7???
and you are trying to find an answer on Oracle board?
Obligatory...
ARE YOU AN IDIOT?
-Original Message-
Sent: Friday, October 04, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To: Multiple recipients of list ORACLE-L
sql server 7???
and you are trying to find an
Raj,
I've seen this problem when dblinks are used extensively. A transaction
slot is allocated when a dblink is used, even if only selecting over the
dblink. It remains allocated until the session commits or ends. However,
if the session doesn't make any changes, it won't commit, and the user
Rachel,
First time I hear about the ANYDATA type but I like to share my ignorance and I
guess it must be something akin to a C 'void *' - ie a pointer to 'something'. To bind
properly, Oracle needs two things :
a) a pointer to the start of the memory area
b) something to tell how big this
Hi gurus,
I need to transfer a few tables from SqlServer to
Oracle. I've installed Heteroegous Service between the
SqlServer and our Oracle database according to the
Metalink doc no : 109730.1
I began the transfer between those two databases with
this kind of statement :
create table TableA as
HELP!
is this also sql server 7 command? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 11:13 AM
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To:
Hi Rahul;
I tried to send you a file to your email, with diferents choices of tapes
for your IBM server... but had no luck.
We did kind of a survey to find the tape device that solved our problems of
time during backup, and finally picked the IBM 7205 Model 345.
Time during backup went down from
Not mentioning that there is usually hot in Florida, so cold is good.
Saying that, I wonder how many people would go into software upgrade or a major change
without a full cold backup.
-Original Message-
Sent: Friday, October 04, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
Hi Louis
Anyone knows how to get rid of a column default value ? I rtfm and
search
metalink with no luck.
Just set the default back to NULL.
To apply the default:
ALTER TABLE BONUS MODIFY (COMM DEFAULT 10 );
To remove the default:
ALTER TABLE BONUS MODIFY (COMM DEFAULT NULL );
Regards
Get more cutlery! Increase the number of processes available both
system-wide and per capita.
-Original Message-
From: paquette stephane [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
Subject: TNS-00510: Internal limit
Louis,
I believe it is the ALTER TABLE command.
ALTER TABLE name
MODIFY ( column datatype);
match the column name and the datatype but do not include the DEFAULT
clause .
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 10/04/02 11:28AM
Anyone knows how to get rid of a column default value ? I rtfm
Are you an idiot?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 11:13 AM
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To: Multiple recipients of list ORACLE-L
sql server 7???
and you are
Dick--
People in New York are actually very friendly and helpful. What you
may have mistaken for rudeness is just the fact that they're always in
a hurry!
--- [EMAIL PROTECTED] wrote:
Rachel,
Well, I for one will not apply. First off I've no use for NYC.
Been there
once in my life
I agree with you Ruth.
Ray, this may be something that your local DBA read in an older manual
someplace.
Have your DBA start reading about Rman. If he/she needs to see it in a
book, it might change his/her mind.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Hi
I wanted to select a column from a v$ table
struggled with it
and finally came with a workaround as follows
archived_log='$archived_log'
begin_seq=`sqlplus -s /nolog EOF
connect / as sysdba
set head off
set echo off
set feedback off
set verify off
I have to create a tabular quarterly summary report, based on 4 different queries, but all are grouped by the same columns. Any suggestions on how to accomplish this - sql report etc. Thanks a lot.
Type category Col1 Col2 Col3 Col4
Elec Fac 500 100 200 400
ElecRates300 200 50 450
Elec Fran 200
that last comment was very very smart, I'd have had to send some of my
enforcers to beat on you otherwise
my presentations don't compete in number of slides with Mr Niemiec (all
my respect to him, I don't know how he manages to get through all that
in the alloted time!). In fact, I was
ARE YOU AN IDIOT! ;o)
-Original Message-
Sent: Friday, October 04, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
HELP!
-Original Message-
Sent: 04 October 2002 14:53
To: Multiple recipients of list ORACLE-L
sql server 7???
and you are trying to find an answer on
update table
set column = null
-Original Message-
Sent: Friday, October 04, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L
Anyone knows how to get rid of a column default value ? I rtfm and search
metalink with no luck.
Louis Brouillette
Analyste en informatique (DBA)
I believe it shows up in some upgrade documentation. I know our Oracle rep
recommended it.
And I'll admit that I did a cold backup before my upgrade rather than hot
just because it's a little easier to recover from if a problem arises (I
just padded the downtime for my upgrade to include the
Is password case-sensity in oracle database? And how do I encrypt it as it
shows unencrypted in password field?
Thanks,
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nguyen, David M
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Anyone using the subject matter
above.
I am getting complaints that suddenly the database going wrong.
What the developers are saying is that the JSP stuff that
they are creating
are not being
compiled automatically as before.
Everything looks fine from my perspective processes
I would do a cold backup of the Oracle executables and application stuff but
I would do an rman level 0 for the database(s).
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 12:18 PM
Not mentioning that there is usually
Funny you should mention... We had the same problem with an
8170 64bit db on AIX 4.3.3 yesterday at about 14:30. Paging space had
become exhausted. In brief, I'm guessing the rash of
memory leaks in 8170-8172 (or the temporary fix I did until I can patch to 8174)
is the cause. Details
What is difference between connect internal and connect / as sysdba in
sqlplus ?
Michael Ivanov
åy« ±ç
ê ~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+2)!j)H½©è¼DNh¯jz/µ×«j»
jТ·#^·
+'«¾' ³Î|ç9Óa¶Úÿ
+0}«\Ü¢d8'è®x1¨¥x%ËZÜ n,¶)à±êïǬND0åDÊ«±é_~º¶¬¨¥x%ËlzwZCY²Æ zÚ
What's returned in SQL*Plus when you DESC TableA@hsodbc?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Luc Demanche [mailto:[EMAIL PROTECTED]]
Sent: Friday,
How can I access the Oracle-L archives?
There's something I remember reading a few months ago that I want to look
up.
Embarassedly yours,
Jay Miller
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
INET: [EMAIL PROTECTED]
Fat City Network Services
I don't know squat about the ANYDATA type but I wonder if there is a
restriction that you can only update an ANYDATA column with a new value of
the same type. For example, if you initially put a '101' VARCHAR2 into the
ANYDATA column and then attempted to update it to 102, where 102 is a NUMBER
Possibilities:
Prebuild the table with the datatype you want.
i.e. varchar2, provided the text column from
SQL server is = 4000 bytes. ( notice I said
'bytes', not 'characters' . No, it wasn't because
most of this mail list is made up of characters. )
Prebuild the table with a LONG datatype,
Rachel,
The following worked for me:
create or replace type person as object (
last_name varchar2(20)
,first_name varchar2(20)
);
/
create table rc (
id number
, person_data sys.anydata
)
/
insert into rc ( id, person_data )
values (1,
4) Old habits are hard to break :).
Ah, there we have it. ;)
Jared
Gene Sais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/04/2002 07:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re:
Stephane,
if there is a new function, then it is hidden so deeply in the docs
that even I can't find it. And I'm pretty good and coming up with
creative search patterns.
ANYDATA is an object, a way of storing different types of data in a
single column. You store the data type metadata with the
This was sent by someone recently:
-
ListGuru GENERAL Command HELP
-
This help file contains basic information about each command recognized by
ListGuru. More detailed
the password is not case-sensitive
which table shows the password unencrypted? Not DBA_USERS, it's
definitely encrypted in there, unless you created the account with
quotes around the password, then it shows in plain text and the user
won't be able to login in in any case.
--- Nguyen, David M
Title: RE: Password is not case sensity and uncrypted
AFAIK password is NOT case sensitive unless of course you enclose in double-quotes. Also dba_users shows encrypted password. What table are we taking here that shows plain text passwords? Is it an application table?
Raj
'connect internal' is no longer supported in 9i+
'connect / as sysdba' is the replacement.
--- Mikhail Ivanov [EMAIL PROTECTED] wrote:
What is difference between connect internal and connect / as
sysdba in
sqlplus ?
__
Do you Yahoo!?
New DSL
and in a different environment, it worked for us as well.
We've narrowed it down to being due to some environment variable. We
thought it might be the privs (the account that worked was created with
resource, the one that died had connect only) but that's not it.
I'm just glad I don't have to
There are certain rules Oracle uses for its names, one of which is that names are case
insensitive. Password falls under these rules.
That said, you can override these rules by enclosing the password in quotation marks
(just as you could do the same for a table).
So
SQL alter user myuser
Us are very pleased about that. :)
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, October 04, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L
and no one but me (and my co-authors of course) write our books
--
Remember having done something similar some time ago...Check this out and see if this satisfies your requirement
Query :=select type, category, sum(col1) col1, sum(col2) col2, sum(col3) col3, sum(col4) col4from(select type, category, count(*) col1, 0 col2, 0 col3, 0 col4 from agroup by type,
List,
With all of the recent discussion and the forth coming books and the
upgrade here to 8i I have a question.
Where do you build your RMAN repository database?
If you build it in the same server as the one you are backing up then
you risk the loss of everything in the event of a disk farm
Also, I think an actual searchable list is on the orafaq site whickh is
in the footer of each message
For example
http://www.orafaq.com/supsearc.htm
I searched Goddess
And came back with a ton of hits, so, I figgure it must be hitting
archives from the fatcity list
;-)
Try it
Bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Raj,
I recently attended a conference where a very security obsessed individual
was giving a presentation. He recommended in very strong terms taking all
application usernames, where the tables etc... are housed, and doing an alter
user username identified by values 'NOBODY';. Now this
Thanks Dale, Michael and Ron.
The default null is what I thought about first and it almost does the
job. It's just that it appears like there is a default value which is
null. If I don't include the DEFAULT clause, it does nothing. I think
I'll have to live with the default null.
At
Rachel,
do you know which system privilege of resource did the trick?
inka
-Original Message-
Sent: Friday, October 04, 2002 1:24 PM
To: Multiple recipients of list ORACLE-L
Stephane,
if there is a new function, then it is hidden so deeply in the docs
that even I can't find it. And
On all of my 8.1.7 and below DB's I do a controlfile backup after the level backup and
archivelog all delete input is finished. I had problems cloning a database because
RMAN back's up the controlfile first and then does the level backup etc.
...JIM...
[EMAIL PROTECTED] 10/4/02 8:53:27 AM
Query the v$sql table. If the 'address' field contains
8 hex characters, it's 32 bit. If there are 16 characters,
it's 64 bit.
select address from v$sql
where rownum 2;
Robyn
Inka Bezdziecka wrote:
you need to 'describe' v$session, not to 'select' from it
SQL desc v$session
Thank you very much Sunny. It works.
MSN Photos is the easiest way to share and print your photos: Click Here
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erma Fernando
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Inka,
I'm not even sure that that is the reason it works in the other
account.. he's still digging into why and what. As soon as I have a
real answer, I'll post it to the list
Rachel
--- Inka Bezdziecka [EMAIL PROTECTED] wrote:
Rachel,
do you know which system privilege of resource did the
I have a small database on a separate disk which holds my recovery catalog.
I would like to have it on a separate server but that won't happen. I have
used the same recovery catalog for 4 years and it is onlyu ~88MB.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L
And wouldn't that be the place you wanted to start if you were doing a PITR?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 3:21 PM
On all of my 8.1.7 and below DB's I do a controlfile backup after the level
backup
Hi All,
Oracle 8.1.6, WinNT
I have view TIMEVIEW. I can do select * from timeview with no errors. If
I select a individual column I get 904 error.
I am doing everything from the schema owner.
Any hints
SQLWKS desc timeview
Column NameNull?Type
Title: RE: ora-904 invalid column name
Taking a Deep Breath ...
Are any columns in this view user defined functions ??
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
Rick,
What is the underlying view statement? I have found that there is an
object resolution difference between selecting individual columns and *. I'm
exploring exactly what happens, but the same issue can be found in
v$sort_usage, where there is a column USER (which is both a reserved
Title: RE: ora-904 invalid column name
try with quotes
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 4:06 PM
To: Multiple recipients of list ORACLE-L
Subject: ora-904 invalid column name
Hi All,
Oracle
Louis,
I still have not convinced myself that we have the proper answer.
If you query the DBA_TAB_COLUMNS table DATA_DEFAULT column you will see
that the original NON default created column has a null or blank as the
value for the data_default column. If the default is set to NULL then
the word
Hi gurus ,,,
i need check what do you doing the smon proc!!!
this process have 99% of CPU
somebody help me!!!
@lex
Lic. Alexander Ordóñez Arroyo
Soporte Tru64Unix BD Oracle
Caja Costarricense del Seguro Social
Thanks, Tom and Ruth and others yet to reply,
We to are a quasi-state agency but the Oracle licensing is under a
state controlled agency and must be purchased from them. If I use my
Linux/8i test platform for company business then I must purchase a
license. Although a 10 named license is not
Title: RE: ora-904 invalid column name
Rick,
I ask because in 8161 there is an internal bug that sometimes communicates (with users) by displaying ora-904 error. This happens when you have a user defined function and you are selecting from that user defined function AND you have privileges
gentle correction: oracle6 had hot backup capability...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 9:48 AM
Oracle 6 and prior releases required cold backups. Hot backups became
available in version 7. The trend
1 - 100 of 135 matches
Mail list logo
