Hi Steve, Waleed
on 8.1.6.0 Solaris I've got the same results as Waleed has.
Shared pool is huge, about 250M and user activity is low at the moment
(users haven't woken up yet :)
Is it NT-specific?
Regards,
Ed
Hi Waleed,
I ran the test below under 8.1.6.0 on NT using SQL*Plus and
I have to say that the newsgroup comp.oracle.databases.server is much
more NT Friendly.
(IOUG: Did anything happen from IOUG concerning the ORACLE-NT-L mailing
list?)
Not just Jonathan Lewis, but Sybrand Baker, Howard Rodgers, Ricky
Sanchez put out some pretty good stuff.
I'd post to the
Just testing, not understanding why I was bounced ;)
--
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
My first rule for commit placement is the respect of
the transaction (hey what do you expect from someone
who likes to normalize before denormalizing ;-) ) then
I looked to improve in terms of performance,
modularity,... so if a transaction is done inside a
loop so be it.
--- Jared Still
(The stats are a little off because I ran it through a
few times, but version count remains at 1)
mcdonac@EDEV create table t as select * from dual;
Table created.
mcdonac@EDEV analyze table t compute statistics;
Table analyzed.
mcdonac@EDEV select count(*) from t;
COUNT(*)
--
Steve,
In terms of the difference between 8.1.6.0 and
8.1.6.3, I can't remember the version vs bug cross-ref
but is it possible you've got timed stats or tracing
turned on ? It was around 8.1.6.x-ish that Oracle got
this sorted out wasn't it ?
Cheers
Connor
--- Steve Adams [EMAIL PROTECTED]
You don't indicate which version of Oracle you're
running, but the most common reason is that the
services have gotten corrupted. Usually recreating
the services will resolve this (see Note: 61621.1 on
metalink).
There were also some bugs in older versions where tabs
in the init.ora file would
Though it's not a Terminal Emulator, have a look at
http://www.uk.research.att.com/vnc/. It's VNC, made by ATT. Totally free,
source code available too, stable, with a small footprint and works even
through a very low band width 56 kbaud modem.
Tamas Szecsy
--
Please see the official ORACLE-L
Linda,
If you are on an 8.x version, then try this statement:
select distinct
b.sid,b.serial#,substr(b.username,1,8)USERNAME,b.process,
substr(c.segment_name,1,8)SEGMENT_NAME,bytes
BYTES,substr(b.osuser,1,7)OS_USER,substr(b.
machine,1,6)M_NAME,
substr(b.program,1,12)PROGRAM
from v$access a,
And I'd like to point out that for a pork-and-cheese
fella to have his mail bounced from Portuguese to
spanish in the same message is equivalent to
declaring Scotland an intrinsic part of england,
or Ireland a subsidiary of UK, or Wales a suburb
west of windsor...
g,dr
Cheers
Nuno Souto
[EMAIL
SAS=2M, CACHING=50, ADJ=10.
My HASH was 10M, then dropped it down
all the way to 260K, at which stage it
threw out the MERGE JOIN CARTESIAN and went back
to HASH JOIN only. So I threw it out completely
(default 0), which would have made it 2M given
that SAS dependency. But the MERGE JOIN
50 for INDEX_CACHING
and 10 for ADJ.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
So what was the final combination that fixed things? That info
might make
it easier for one of the list gurus to tell you why it worked...
--
Please
Hi,
thanks for the help, it actually was the DBMS_OUTPUT. I put it in for
debugging purposes, but of course I forgot to take it out again ;).
--
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
Hi,
Paul Drake schrieb:
I have to say that the newsgroup comp.oracle.databases.server is much
more NT Friendly.
(IOUG: Did anything happen from IOUG concerning the ORACLE-NT-L mailing
list?)
Not just Jonathan Lewis, but Sybrand Baker, Howard Rodgers, Ricky
Sanchez put out some pretty
Hi,
more a philosophical question:
I'm wondering about the advantages/disadvantages of running Oracle UNIX
like (many processes / shared memory / ipc ) or NT like (one process
/ multithreaded).
AFAIK, UNIX is better at handling large numbers of processes and NT is
better (is it ?) at
Steve,
I got the same results as Waleed on 8.1.6.0.0 on
Win2K, 8.1.6.3 32-bit on Solaris, and 8.1.6.1 64-bit
on Solaris.
Might you be running into bug 1210242 (fixed in
8.1.6.2) or one of the similar bugs in 8i where
cursors aren't shared when timed_statistics are
enabled?
The workaround for
Hallo,
I have a procedur, and when i compile it I get the erro rmessage
Invalid number of arguments in call...
It stops at the line:
vDELIVERY_STOP_DATE:= lpad(nvl(recCursor.DELIVERY_STOP_DATE,0),8,'0');
The datatype declaration in pl/sql is varchar2 for the field but in the database it is
- Original Message -
have you tried to disable hash joins explicitly via
hash_join_enabled = false ?
No. I want to have hash joins. They are
darn useful for some of the SQL. But they
are contemptuous when they become too familiar. g
Could you forward Anjo's explanation?
Surely you meant idyllic symbol? :-)
BTW, the buildings are really giant disk drives...
[EMAIL PROTECTED] 05/09/01 05:06PM
SATIRE, SARCASMS ON (just got our 2002 price quote)
Does any person know of a statue / figure/ object that stands outside the Oracle
Corporate Headquarters that
On Wed, 9 May 2001,Jared Still scribbled on the wall in glitter crayon:
-
-yeah? Well how do you like this?
-
-while :
-do
- mkdir ./t
- cd ./t
-done
-
-;)
-
-Jared
You sir are evil.;-) And we LIKE it.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.
Hi,
please attach trace, and results of:
- debug process by oradebug of oracle,
- trace process in OS level by conterpart of truss in unix,
- attache core.log if generated
Sonja ehovi wrote:
Hi all!
Oracle 8.1.7. EE on WinNT.
Oracle trace is generated during the database startup (something
Has anybody seen the following error on logon to sqlplus
sqlplus dbu/dbu
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-06553: PLS-707: unsupported construct or internal error [2603]
Error
Tim Sawmiller schrieb:
Not as pissed off as the time he trusted me with the root password, and I absent
mindedly ran this command from the root partition:
chown me *
[EMAIL PROTECTED] 05/09/01 03:16PM
On Wed, 9 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
-make
Ah but is there as much humor there? Not really quibbling, I was on
comp.oracle.databases.server for a long time and will be going back (can you
say she won't be doing ANY work at all now?)
but how else can I LEARN??
Rachel
From: Paul Drake [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
I go back to the newsgroup once every 2 to 6 months, just to see what the
topics tend to be there.
I don't follow it, because this listserv during the day is enough I think.
On the newsgroup the volume is such that I spend over an hour just deleting
pieces of threads... that's another problem,
This problem is probably related to trying to do something from within a
stored procedure that can't be done, however I can't find anything in the
docs that say that. I've opened an iTar but the response has been
WORTHLESS, and that goofy person keeps asking me in six different ways what
grants
Nuno, thanks for your response
- Original Message -
have you tried to disable hash joins explicitly via
hash_join_enabled = false ?
No. I want to have hash joins. They are
darn useful for some of the SQL. But they
are contemptuous when they become too
If it's an idolic symbol it's probably a statue of Larry that everyone
is supposed to bow to. ;-)
Rodd
Original Message
On 5/10/01, 7:51:05 AM, Tim Sawmiller [EMAIL PROTECTED] wrote
regarding Re: Question of the day:
Surely you meant idyllic symbol? :-)
BTW, the buildings are really
If I have multiple database built on the same database server and want to
have a separate password file for each, how do I create the association or
make Oracle aware that this password file goes with this database. Is there
a parameter file entry that I need to set? I've looked and I'm still
As in more holes than:
Microsoft warns of another Win 2k security hole
Just a week after urging users to install a software patch meant to fix a
potentially serious vulnerability in Windows 2000, Microsoft said a new flaw
could be used to launch denial-of-service attacks against servers running
Thanks very much, I found a much more limited list on another part of the
Oracle web sites, but this was the one I needed. Anyway, all you have to
do is drop the 'l' at the end of 'html' and you are there.
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server
I have been told in the past that ODBC connections to
the database are slow and very resource intensive, but
unfortunately this was not explained. Fortunately, I
haven't really had to deal with ODBC connections much.
However, in my new job, several users are using MS
Access as their query tool
** Love Might Be Forever, But What About MS Licenses?
Microsoft is expected to announce changes to the way it licenses
its software to large companies today, including the possibility
of more emphasis on agreements that expire after a few years.
In a research note issued earlier this week,
Stefan
I've recently inherited this database and the developers who have used the
database in the past say that it worked fine and they have had no problems.
My first reaction was the same as yours but i'm assured by the developers
that this database has worked fine before.
The problem is
Hi all,
Is there anyone on this list working in Broadcast media that uses Broadcast
Clock (0600 to 0559 next day) for data processing? If so I'd like to hear
from you.
Thanks
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
When you create the password file it should be named orapwsid. Then it
goes only with that sid. I have 13 databases on one server that have
different password files created in this way.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
I downloaded VNC sometime ago. Works very nicely, especially on NT servers
instead of PC Anywhere. Haven't tried the Unix variants though. One irratating
habit it has is on screen refresh for windows not in the foreground/active.
Dick Goulet
Reply
Did you grant the privileges directly or through a role?
You need to grant them directly in order to have access to them in PL/SQL.
Jay Miller
x48355
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
This
The Init.ora parameter is 'remote_login_passwordfile = exclusive'
then the password file is '$ORACLE_HOME/dbs/orapwsid'.
At least on HP-UX and Linux
Dick Goulet
Reply Separator
Author: Richard Huntley [EMAIL PROTECTED]
Date: 5/10/2001 5:41 AM
If I
It works great, actually better, on UNIX. I use it at work when I kick
off a long running interactive process. It allows me to start it up,
close out my vnc session at work, and then monitor it in a vnc session at
home without ever losing the process. Works fairly well over dial-up
zabair ahmed schrieb:
Has anybody seen the following error on logon to sqlplus
sqlplus dbu/dbu
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-06553: PLS-707: unsupported construct or
Oracle details self-tuning pieces of 9i database -
http://www.infoworld.com/articles/hn/xml/01/05/03/010503hndatabase.xml?p=br;
s=2
Oracle Moves Back 9i Launch, Dribbles Out More Product Detail -
http://www.crn.com/Sections/BreakingNews/BreakingNews.asp?ArticleID=26312
--
Please see the
Somehow I doubt that this list is difficult to find. Recently I saw a lot of
people asking questions on this list something like where can I find Oracle
docs.
Alex Hillman
-Original Message-
Sent: Thursday, May 10, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
I go back to
All,
I have recently ran
an analysis on a table and when calculating the table size using
num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that,
however the amount of space this table is taking up is about 4.6Gb
!
Instant case for a
reorg I thought, however, I
Could you explain please how somebody with DBA provileges on another node
can shutdown listener on another node without logging as user of the node
where listener is running.
Akex Hillman
-Original Message-
Sent: Wednesday, May 09, 2001 9:50 PM
To: Multiple recipients of list ORACLE-L
The only time I saw this, the db create had gone awry. We needed to re-run
catalog.sql and catproc.sql (as sys).
Terry
zabair ahmed wrote:
Has anybody seen the following error on logon to sqlplus
sqlplus dbu/dbu
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001
(c)
Sorry. Read my reply to Eduard. You
should have got it? If not, let me know
and I'll send.
Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -
and that is??? c'mon Nuno, we need to know!
--
Please see the official ORACLE-L FAQ:
Does Oracle capture a last updated date whenever a table update occurs? Or
do I need to create a trigger to handle this?
Thanks...
D. James Stein
Senior Developer/Database Engineer
[EMAIL PROTECTED]
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434 x165
Cell:
DBAs,
I have two of my tables and index in nologging mode as I am loading data
using SQL*Loader direct path mode.
I have scheduled RMAN hot backup everday. When I issue REPORT UNRECOVERABLE,
I am getting both the Data and Index datafiles are unrecoverable.
I know that I wont be able to recover
Title: RE: Export question.
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
I have recently ran an analysis on a table and when calculating the table size using
num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that, however the
[EMAIL PROTECTED] wrote:
I have two schemas: schema1 and schema2. I need to analyze
schema1.mytable from a stored procedure owned by schema2. Schema1 has
granted ALL on mytable to Schema2.
From the Administrator's Guide: To analyze a table, cluster, or index, you
must own the table,
Thanks to all of you who responded to my question.
Best Regards,
Prasad
Jesse, Rich [EMAIL PROTECTED] on 05/08/2001 03:56:49 PM
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Prasad,
If you are on v7+ of OpenVMS (or is it v7.1+?), you can use
When you export it do not! use compress=Y.
When you import the table be sure to prebuild the table with the initial and
next extent sizes to be appropriate for this table.
This will reorg it unstead of putting it back the way it was.
Ruth
- Original Message -
To: Multiple recipients
Trigger, Oracle doesn't maintain last update date for a table. I would put a last
modify column in the table with a trigger to maintain it. then you could see when each
row was inserted or modified and could tell when the table was last modified by using
the following selectSELECT
Funny. The article says Oracle details. and there is not a
single detail in the article.
Bad Journalism, or Great Marketeering?
|| -Original Message-
|| From: Glenn Travis [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 12:21 PM
|| To: Multiple recipients of list
VNC works great with Linux and Solaris. All available all the time... gotta
love it.
Scott Hayes
I downloaded VNC sometime ago. Works very nicely, especially on NT servers
instead of PC Anywhere. Haven't tried the Unix variants though. One
irratating
habit it has is on screen refresh for
Title: RE: Invalid number of arguments
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a procedur, and when i compile it I get the erro rmessage
Invalid number of arguments in call...
It stops at the line:
vDELIVERY_STOP_DATE:=
Chew up the inodes! Excellent. (Monty Burns excellent with the fingers
twitching as opposed to the Bill and Ted excellent with the air guitar.)
echo 'mkdir $$; cd $$' /tmp/t.sh
echo '/tmp/t.sh ' /tmp/t.sh
echo '/tmp/t.sh ' /tmp/t.sh
chmod 777 /tmp/t.sh
/tmp/t.sh
Your technological
rsh, I'd guess.
|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 11:42 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: LSNRCTL Password
||
||
|| Could you explain please how somebody with DBA provileges on
||
Nuno Souto wrote:
Sorry. Read my reply to Eduard. You
should have got it? If not, let me know
and I'll send.
well i missed it. if you could forward it to me off list please?
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
Sometimes I really love the developers at Oracle.. This should be good
fodder for Eric P.
Does anyone have experience with infamous pickler Fetch which shows up in
this explain plan the select is on index organized nested tables (Nested
objects)? It's obvious that someone in internals has
Hi DBAs
I have a lof of file name like IDP2000.z for tuxedo servers. I need to
changed name to idp2000.Z.
I write a following script but never change.
Some suggestion
Mitchell
# init_idp.ksh
# 2001-05-09 /Mitchell
#
ls -la IDP* | awk ' { print $9 } ' tobechanged
#
while read i
do
Title: RE: Pl/sql loop assistance
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
I'll have to disagree with not using commit within a loop.
If you identify what a transaction is within your code, and
write it accordingly, using commit where appropriate, you
My manager is thinking of moving us up to Gold support. Does anyone out
there have it and if so could you give me you general impression on having
that over Silver. She says that at sites she used to work at it means
having a dedicated resource on site. Their phone support for SEV1 calls is
Paul,
I haven't look at newsgroup c.o.d.s. for a long time, basically
because I got out of the habit of looking at newsgroups, the
messaging formatting and software needed seems a little unnatural
(convoluted) compared to email. But, I'll admit to laziness. I have
enough on my hands just
Hi!
Is there a data dictionary view that gives me all the columns in a primary
key of a table?
I can query user_constraints to find out about all constraints on a table:
select * from user_constraints where table_name='TBACCOUNTS'
OWNER CONSTRAINT_NAME C TABLE_NAME
They promised the same thing in Oracle 8. I just hope they fix the major
bugs and try to get the major product functionality working!
-Original Message-
Sent: Thursday, May 10, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
Oracle details self-tuning pieces of 9i database -
But usually all this remote staff is disabled by SA because it is a security
breach.
Alex Hillman
-Original Message-
Sent: Thursday, May 10, 2001 1:04 PM
To: Multiple recipients of list ORACLE-L
rsh, I'd guess.
|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL
When they are not in the archive log destination they are seen as missing by
backup, at least by rman. Maybe that is why is seemed like there was such a
high % of missing files. But I would still ask for an explanation from the
DBA who did the analysis.
HTH,
Ruth
- Original Message -
whine: ON
So, I filed a bug on 8.0.5.0.1 on OpenVMS on 04/13/2000. This is the latest
MetaClink update:
I have not been able to test on 817, and really not sure I will be able to
do this. This bug was logged against 80501, not even a supported product
any longer. It may be I should just
Hi DBAs
I have a lof of file name like IDP2000.z for tuxedo servers. I need to
changed name to idp2000.Z.
Mitchell
I rewrite the script and failed again. Any idea how to user typeset -l and
tr command.
Mitchell
#!/usr/bin/ksh
# init_idp.ksh
# 2001-05-09 /Mitchell
#
ls -la IDP* |
you can select from user_cons_columns to find columns.
lucy
On Thu, 10 May 2001, Helmut Daiminger wrote:
Hi!
Is there a data dictionary view that gives me all the columns in a primary
key of a table?
I can query user_constraints to find out about all constraints on a table:
select *
Regards,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To ALL,
I've been given a project to find a way to make data easily available to end
users, preferably via a thin client (read that as browser based). We're looking
at Discoverer 3000 and 9iAS, but the boss wants to know what other options are
out there. The general idea would be to have a
Kim,
I have not seen a reason to get GOLD support from Oracle. Unless you've got
a boss who doubts your capabilities. Sounds like time to brush off the resume!!
Dick Goulet
Reply Separator
Author: Kimberly Smith [EMAIL PROTECTED]
Date:
I don't want anyone grabbing my content, thank you very much.
Bunch a rat bastard, mind-maggoting sh*tballs.
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 1:56 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re:
We are looking at new servers for our Oracle8i OLTP back-end. An IBM
sales guy claimed that an RS/6000 is 'twice as fast' per processor
running Oracle8i in an OLTP environment - a 6 processor RS/6000 is just
as fast as a 12 processor SPARC.
What do y'all think about this?
Chris
--
Please see
user_cons_columns
-Original Message-
Sent: Thursday, May 10, 2001 1:23 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is there a data dictionary view that gives me all the columns in a primary
key of a table?
I can query user_constraints to find out about all constraints on a table:
Helmut
ALL_CONS_COLUMNS contains columns and position for each constraint.
Similarly ALL_IND_COLUMNS contains columns for each index.
If you need to find the columns through SQL, use the views or join to them. If
you don't need the SQL, get a tool like TOAD (free version,
Title: Locked Oracle dll's
I am trying to remove the Oracle bin directory from an NT 4 server however the Oracle dll's are in use.
The reason they are in use is because they are open to the Windows NT winlogon.exe process as a result of remote performance monitoring.
When you use
Scott,
Now that's a new one on me. Please let us know if the pickles come out
sweet or sour! :-)
Dick Goulet
Reply Separator
Author: Scott Crabtree [EMAIL PROTECTED]
Date: 5/10/2001 9:11 AM
Sometimes I really love the developers at
Yea, SAs disable all security threats.
Sure
Uh-huh
Fine
Whatever
wink
|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 1:23 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: LSNRCTL Password
||
||
|| But usually
Waleed,
Are you talking about something for a beginer? There is always the Oracle
for Beginners, Oracle for Dummies, and Beginers guid to Oracle books. They're
available from BarnesNobel, Borders, and Amazon.com.
Dick Goulet
Reply Separator
Author:
Waleed,
IMHO shortcut and replication are mutually
exclusive ;)
For configuring replication I think the manuals are
pretty good, for general replication principles I'm
rather fond of
Oracle Distributed Systems, by Charles Dye
http://www.oreilly.com/catalog/ordistsys/
I'm also forwarding you
Title: RE: What columns are in the Primary Key
-Original Message-
From: Helmut Daiminger [mailto:[EMAIL PROTECTED]]
Is there a data dictionary view that gives me all the columns
in a primary
key of a table?
Try user_cons_columns.
It would probably be of interest to you to
I have been told in the past that ODBC connections to
the database are slow and very resource intensive, but
unfortunately this was not explained. Fortunately, I
haven't really had to deal with ODBC connections much.
However, in my new job, several users are using MS
Access as their query tool
Hi Dick:
I have a similar project on my plate. I like Business Objects. Actually, we do not
want users to have to know table/column names and need a product where we can build a
data
repository. I am not sure if we need a complete end-to-end solution as many BI
companies seem ready to
Making this call on processor alone is not a good thing. A lot of
factors go into Oracle performance. What is the I/O comparison between
the machines, amount of RAM, backplane configuration, etc.? A sales
drone just spouting off on processor speed (true or not) doesn't give you
a complete
Hi!
How can I find out what the order of columns in a table is?
If I do a select * from tablename, the columns appear in a specific order.
The same order than they appear when I do a describe tablename.
I can even do an insert without specifying the columns in my VALUES
(.,) when they
Could also try
select * from user_ind_columns where index_name = 'PK_ACCOUNTS'
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 10 May 2001 19:16
To: Multiple recipients of list ORACLE-L
use user_cons_columns:
SQL desc user_cons_columns
NameNull?
I haven't used them, but I know that WebFocus is supposed to do that sort of
thing, and Cognos has a couple of tools for it.
Dan
-Original Message-
Sent: Thursday, May 10, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L
To ALL,
I've been given a project to find a way to
I really don't think that is the issue. I believe my management has more
then enough confidence in me. However, they have very little confidence
in Oracle support. She was going from past experience. Right now we are
having an Oracle issue that Oracle is trying to push off to us.
We still have Bronze support which you can no longer get but we would not
even consider upgrading to
Gold because their phone support is not very good at all. There are too many
resources available where
you can actually get a correct answer much sooner.
Rick
-Original Message-
Sent:
Ross,
You're so shy and reserved today... what gives? ;)
--- Mohan, Ross [EMAIL PROTECTED] wrote:
I don't want anyone grabbing my content, thank you
very much.
Bunch a rat bastard, mind-maggoting sh*tballs.
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL
Title: RE: Data Reporting tools
Dick,
I'd support Jacques and vote for BusinessObjects.
Release 5ilooks really cool. BusinessObjects is less scalable compared to
Cognus, but, I believe, less expensive also. I personally used BO 5, nice
and robust product, but, it was not possible to
We have lots of clients who use odbc for ad hoc tools - access,excel,
foxpro,vb ...
While not quite as quick as a native tool they are ok for these
applications, however they can be really bad, like any application, with
poorly written queries (and what other kind do they ever write?).
Thanks Rodd! It's good to be back. Looks like we're doing things right here...
sounds like it's time to make the old phone call to customer support. Thanks for
doing the MetaDrink footwork for me... the good folks here haven't given me the CSI
number yet and I don't have an existing
Hi,
As you know, drop user ... cascade drops all the
schema's object and the user, anybody knows a handy
way to drop only the objects but keep the user?
Also, when I export a schema from db1 and try to
import into db2. Since the schema does NOT exist on
db2, I got error user not exist, so I
Select column_name, column_id
From user_tab_columns
Where table_name = 'YOUR TABLE NAME';
Rao
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, May 10, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Hi!
How can I find out what the order of columns in a table is?
If
Walter,
I wouldn't go so far as to say that ODBC is bad in all cases, but it does
leave something to be desired also. In the past I have noticed that ODBC
connections stay connected to the database until the application is
closed. To clarify this, suppose a user opens Access and opens an
1 - 100 of 142 matches
Mail list logo
