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
Title: RE: Group By - Without using aggregate functions
Rollup and cube are sql functions that place subtotals and grand totals into the query (usually shows the other columns as NULL to inidicate a total);
Check the sql reference in the oracle docs for examples of use or the iternet.
\
Hi,
I recieved an email today as follows:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Got trigger happy, so I'm resending.
-Original Message-
Sent: Thursday, August 29, 2002 10:11 AM
To: DBA List (E-mail); Fat Dba (E-mail)
Hi,
I recieved an email today as follows:
Display name of sender to me: NAV for Microsoft Exchange-DDS_MAIL
[EMAIL PROTECTED]@SUNGARD
Title: RE: assistance
Yup.
Its a scam. Believe it or not, some people have actually fallen for it!
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Robertson Lee - lerobe [EMAIL PROTECTED]
Sent: Thursday, August 22, 2002 10:49 AM
To: Multiple
Title: RE: List of all zip codes,city,state to load into table.
Hi, Hope this helps. Its a text file, then you can load it using SQLloader etc.
http://www.cwpm.com/ZIP_DB.html
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday,
Hi,
I had noticed that one of our triggers is performing very badly. I had disabled the
trigger to test replication and there was a issue with the trigger. When the developer
changed the trigger and enabled it, replication slowed down to one record per second
(other tables are being updated,
Got enough info to start looking around. I am using a third party replication tool ,
so that's won't be an issue.
Thanks for all the replies.
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hi All, I'm going to take some time now to look into the DBMS_PROFILER and DBMS_TRACE
packages. They have been suggested by several people.
So, I may repost later when I get a better hanlde on them.
Thanks,
Hannah
-Original Message-
From: Aponte, Tony [EMAIL
Hi Joe,
Its 8i, but the problem was that I was not qualifying a package constant. So,
it found the package, but not the constant. I thought I had sent a resovled message
to the list, sorry about that.
Thanks,
Hannah
-Original Message-
From: [EMAIL
I have seen this error when the UTL_FILE_DIR parameter is set incorrectly.
It may be a typo, the directory does not exist, or the user hase no access to it.
I have also found that if the value is entered in the OEM (at least on NT), that
sometimes it is not properly read. So, instead, I also
Selecting from a sequence DOES generate logs. The statement will be a UPDATE to the
SYS.$SEQ.
I have an issue right now where we have a runaway process that polls the sequences
(and doesn't use them), and it is generating SO much archiving that its a real
issue. (still workging on it)
Hi,
Having an issue where some code is constantly hitting a sequence (yes, I know...
this will be fixed also). But in the meanwhile, is there a way to NOT log
sequences to the redo log
Thanks,
Hannah
Hi,
I
would like to grant the ability to a user to run logminer. I tried
granting execute on both dbms_logmnr and dbms_logmnr_d to the user to no
avail. SQLPlus still requests for it to be declared (Ie. its not seeing
it). I have even tried qualifying the package Ie. sys.dbms_logmnr when
Hi,
We are seeing an error from a
3rd party etl tool that says:
Cannot find or load Oracle OCI module
This is occurring on a
production box. In comparing the oracle files to our development box, we
are seeing differences (files missing). However, Oracle seems to be
running ok
Is there a way to
captureall files hit by a process/user in unix (Sun Solaris 9, ksh)?
I am seeing an OCI file not found on my production box. I can't resovle
it.
So, I want to run
the same process on my development box (where it works) and get a list of files
that it is hitting (I can
Thanks,
But I don't know the file or pid. Here's what we are doing:
From an NT box, we are trying to run Sagent software to an Oracle db on unix
sun solaris (both 64bit). When we try to refresh, we get a sagent error - OCI file
not found.
Of course it does not
Title: RE: OCI files missing from installation? PRODUCTION - RESOLVED
It was the PATH order in the 3rd party'd ini file
ugh!
Thanks for all the replies!
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD
Sent: Friday, August 09, 2002 12:33 PM
To: Doran,
Hi,
I am writing a one-time proc to copy all records from one table to another table
with a commit level of 1 record. I wrote a proc to do this using a cursor and for
loop but was wondering if there was an alternative syntax for the insert using the
current cursor?
Ie. Insert into
Title: RE: INSERT INTO Syntax: Insert a complete record using a cursor
Hi,
The update method is interesting. I need to think the reprocussions through first, but that may save me a lot of hassle
Good idea!
Thanks,
Hannah
-Original Message-
From: [EMAIL
Hi,
Are there any list archives online ? Alot of some interesting threads are coming
throught to me blank (probably my server is blocking content) but I still want to
read them.
Please let me know.
Thanks,
Hannah
--
Please see the official ORACLE-L FAQ:
Every single message I get on this post gets blocked:
Can't tell you but how I am wondering what is being said!
-Original Message-
Sent: Tuesday, July 30, 2002 3:07 PM
To: Multiple recipients of list ORACLE-L
The original message content contained a virus or was blocked due to
$35k only! That wouldn't even PAY for all the certifications they request!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of ltiu [EMAIL PROTECTED]
Sent: Sunday, July 28, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Are you
Hi
List,
I
saw a similar post to this in the last 2 weeks, but deleted it (oops) as I
am in a unix shop. But I now have a client who is trying to install the
oracle client on his nt box in order to demo our *product*.
However, he can't get the installer to even launch. He thinks
Title: RE: Oracle Installer not launching in NT - RESOLVED
Everyone
Thanks so much!
Looks like you all just saved me a client!
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Depends what version of Adobe you have. I believe I had version five at my last job
and you could add notes and bookmarks..
Just most of us are using Adobe reader, Free but not containing the editing abilities!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On
Use comic sans font and hightlight with crayons.. then give him the real one
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Miller, Jay
[EMAIL PROTECTED]
Sent: Tuesday, July 23, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L
Subject:
_ _
| | | |
| | | |
| | | |
| OLD Location
Title: RE: RE: Rant
Not me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE.
I can find things much more quickly in the pdf's than paper.
Oracle is the only product that I feel this way about .. probably because they have more
I had experience with it once. Even took a training class. The project NEVER flew.
I guess it depends on how your data is laod out. Our database was SO complex that the
company I worked for hired a consultant to create the CUBE. after 4-6 months, he
had a few erroneous reports to show
Yeah, but what if they are taking the credentials to apply for US Visa's ...
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, July 18, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OFF
Ok,
Maybe its just been a rough day, but looking at the docs (PLSQL Devleopers
Guide), I only see that I can return only a record at a
time.
But say I want to
return a complete recordset from a stored procedure toa C program, what
would be my retrun type? Can I use a collection?
The
Ok, then the question is, can I pass a REF CURSOR to a C program?
That's my problem. I know I can do it with ref cursors lets say within a package but
what if I want to pass a complete recordset to a C program?
We have a programmer writing a program in C, wants us to write stored procs that
Thanks!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, July 11, 2002 5:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:PL/Sql Error Handling Package
Hanah,
This is one procedure out of an entire
Title: RE: Plagiarism?
I COMPLETELY missed this WHOLE thing. They pulled the article before I got there even though I went up right away.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
THAT DOES IT. I am starting training on DB2 right away (Yeah - I can actually AFFORD
to no $2000 requirements!!). I want a DB that KNOWS its a DB and not an
all-purpose quagmire of inter-related but not really related junk just because Larry
has a Bill complex!
Oracle and CHEAP cannot
Amy one have any decent stanard error handling packages or link to advice on creating
such a package?
Thanks,
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Ok,
The current *threads* on the subject have persuaded me to pursue the OCP.. I
remember the thread about the $2000 course. But I thought that this was
for Oracle Masters, NOT OCP...
Can anyone clarify this OCA, OCP, Masters thing hey and what ever happened
to DBO?
Thank you Rachel!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Rachel Carmichael
[EMAIL PROTECTED]
Sent: Monday, July 01, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Confused: Oracle OCP
think of it as
OCA is the
3) The third selection from the top on the Configuration menu of the
RunAmok Technologies Defibrillator for Dummies (TM) is:
a) voltage
b) amperage
c) frequency
d) duration
e) billing rate
..
LOL! This is exactly the kind of thing that has discouraged me from the exams! Now,
being a new
..
weaknesses and which way to go. One such was If you find a file named
'afiedt.buf', how was it probably created? That particular question caught
two very confident applicants without the foggiest clue a few years ago.
..
You GOTTA be kidding right? I consider this rank with
Title: RE: the ora certified masters cert, yet again
Wow, I guess Tom Hanks was right! All of the the answers to life even theOCP CAN be found in the Godfather!
hehehehehhe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City
Hi,
This should work. But I took the messier approach (I have 8i) and created before
insert/update/delete triggers on the suspect tables. I am testing in a schema on an
instance where there is alot of activity on the other schemas.
BUT, I will look into further for future use.
Thanks,
Hi,
I know for example, I can access :new values and :old values. I also thought that
I could access the TYPE of ddl that caused the trigger to fire and I am wondering if I
have access to the sql that caused the trigger to fire.
I am looking in the application development PL/SQL
Hi,
I discovered that you can use tests to garb the operation types as follows:
If Updating
If Inserting
If Deleting
etc.
I am trying to build my own sql trace using before insert,updatemdelete
trigger for each row.
Andy,
Consider yourself solicited! I am currently using Datamirror for our tandem
db2 to unix oracle replication. The product was not chosen for our oracle to oracle
replication for 2 reasons. #1 trigger based. #2 if the source transaction failed to
be commited at the target, then
Brian,
That is what I wanted to do, but I understood that it would not be *supported*
if we ran into issues.
Thanks,
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw
[EMAIL PROTECTED]
Sent: Thursday, June 20,
Hi,
The problem is fairly complex and I am unable to reproduce it by manually
feeding in the statements of the suspect transaction. Both statements hit triggers
which use autonomous transactions to do things. Its the second statement that fails
and I am unable to tell if something
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
My experience is that they do nothing for free.
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Tim Gorman [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 9:23 PM
To:
Title: RE: I/O contention with external process reading the oracle logs (online redo logs)
Quest.
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Tim Gorman [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L
Subject:
Dennis,
I was not referring to any one on this list. I was responding to the
statement that Quest should run a benchmark on someone actual redo logs... I say,
they might for a cost only I run Shareplex and haven't written full
response to this thread yet because at
Title: REPLICATION: Quest Shareplex
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread. Could be why there are no responses. A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as I am
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread.
Could be why there are no responses. A couple people on the list definitely use it
and I know I certaintly will have a lot to say about it but have to do it later as I
am working on Prod issues right now.
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppossedly fixed in 8.1.7.2 Will test with my 8.1.7.3 version.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
Title: RE: EXPORT BUG: oncorrect storage parameters being produced RESOLVED new bug
Hi,
Check out Bug 1575222 in metalink (someone sent it to me).
Exact bug. Suppoesedly fised in 8.1.7.2
-Original Message-
From: Patricia Karla Cordeiro [EMAIL PROTECTED]@SUNGARD
Sent:
Oh yeah,
The dumped controfile script with give you all of the files name s too. Then
just search and replace in a text editor PCLDB1 and ROLAND,
Hope it helps at all,
Hannah
-Original Message-
From: Doran, Johanna
Sent: Thursday, June 06, 2002 11:15 AM
NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no matter what
default i set!
Hi lists,
I am using Quest Shareplex product for Oracle to Oracle one way replication. I
have two systems (source and target) and two environments (dev, demo). On system
one, the
Title: RE: Oracle 32 Bit running on Solaris 64 Bit
Is it possible that you have vendor software that doesn't support Oracle 64-bit? Before any decisions are made, I would compile a list of all vendor software on the box and also those used specifically for the application. Then research each
Title: RE: How to move 200 GB db from prod to dev?
Dump the prod control to trace
Copy the db files over to dev
edit the dumped controlfile (you can change db name here)
replace the copied controlfile with the new eidted one and bring up dev
I forget exactly what needs to change in the
Hi,
I have One db instance containing three schemas to represent development, stage,
and demo environments. I occassionally need to *roll* the schemas as a release occurs.
We have been using import/export to accomplish this. In the past, another dba has
done this task (so this is
Hi,
I
have One db instance containing three schemas to represent development, stage,
and demo environments. I occassionally need to *roll* the schemas as a
release occurs.
We have been using import/export to accomplish this. In the past, another
dba has done this task (so this is why I
This was not always the case. We must have flooded the server and they shut off
public access. There are other sites that have the slides. The slides are actually
provided BY Oracle as part of some educational deal (ie. pre-marketing campaign!). But
I have found these on the net in the
I thought that there was a way via schema level triggers? I vaguely remember
discussion on this last year
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Kimberly Smith
[EMAIL PROTECTED]
Sent: Monday, May 06, 2002 10:28 PM
To: Multiple recipients
That's one I haven't heard about!
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Ji, Richard
[EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 11:58 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Erwin - Does this thing work?
In our case,
Hi Lisa,
Yes. But its a little convoluted. It took me quite some time to do it.
Depends what you want included. IE. storage paramters etc.
This is the product I use to generate all of our models and YES, it drives me
nuts. They had a bug in the last version that
At the expense of sounding like a sales person, let me
point this out again for the benefit of the group:
And, you certainly need to look at it:
http://www.iraje.com/docs/ActiveSecureDesigner.htm
I will find forward you some more info.
Keith
Ok Keith,
I give. Let's get a
As far as I am aware : NO. It has played a major role in me not being able to obtain
some more test boxes at my current job. I believe the licensing is a little better,
but it is still there. Plus, you also need the OS (Sun Solaris) so you get hit there
too.
Hannah
-Original
Hi,
Been searching for syntax to drop a default value (we decided NOT to use the
default value) for a colmun.
I looked in the docs and even tried to remove the default value via DBA Studio.
No go. Can you not modify a column to REMOVE a default value specification?
Thanks,
Yep,
ALTER TABLE table_name MODIFY(column DEFAULT NULL);
Works so I guess its ok. Was hoping to completely remove
Thanks All.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Why? For consistnecy. I am in charge of making ALL changes to the data model, then
rolling out those changes to the db. Our developers RELY on me and my tools for a
database that reflects the model that we developed (Without Error).
Therefore, everything we do here STARTS with the model
I dont mind the PK thing, I prefer it that way, but it also inconsistently places
migrated foreign keys on the bottom (this is just mdoeling, no reverse engineering).
This is just a slight pain for us as we have a bunch of auditing fields that I like to
be last for readability. Sometimes I
I did something way back wehn using PIPES to catch a runaway third party encapsulated
pl sql code.
I dont remember the specifics but you can look at the docs for it.
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Yechiel Adar
[EMAIL PROTECTED]
Title: RE: Database Normalization-Outdated?
I Admin'ed a vendor app that was built similar to this (and the UI was in Designer - made me not think kindly of Oracle duh-velopment environments). Except that they had more tables to contain all the CODES. I always referred to this nightmare
Title: RE: Prod problem, please help!!! Any resolution?
Hi,
Just wondering if you made any progress?
Let us know.
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
ERWin's not much better. Has some better modeling capability as you might guess, but
has some VERY annoying quirks too. You also need to drill down endlessly when doing a
compare and I have seen it see two exact tables (even case being the same) and see
them as different. The DO have a
Title: RE: ERD generation tool
When I was in an NT shop, we used Visio (I know...I know), but given that I was not architecting at the time, I can't compare with the Erwin that I am using now.
I remember at the time though, the ERDs created using Visio were accurate for what we were doing
Title: RE: PATCH?
EPIDURAL..
advice from the recently hatched (eight month old little girl:)
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Koivu, Lisa [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Title: RE: Oracle ODBC On Windows95 (Don't ask) :)
Are you just trying to setup an ODBC conenction?
In Control Panel, you should see an icon for an ODBC manager where you can add dns entries . You STILL will need to install Oracle client. Use the db alias name for the Service name in the
Title: RE: 9i new features, the saga continues?
Please refresh me, wasn't this Oracle's answer to Quest's market share?
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of JOE TESTA [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 9:14 AM
To: Multiple recipients of
All sarcasism aside, I'm interested too :
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
Hi,
We have an ETL script that logs onto the db. The scripts usually runs without
error. During pre-production testing, we rec'd a logon denied error message. We
re-ran the scripts and all was fine.
I did not see anything in the alert log, only message for today was a redo
81 matches
Mail list logo