list, my appologies for asking question regarding ias (solaris), but i
could not find any info regarding this on the net..
i'm on solaris, running ias, i'm new to this environment, and have been
asked to audit the setup !! to start, i simply want to find out the version
of forms/reports
Advanced Server (developer's edition) seems to be much easier than the
standard edition simply in terms of getting OCFS to work so that's the way
I've gone. I've tried Suse 8.0 and RedHat 8.0 and I could load the OCFS
module but it wasn't stable and frankly I didn't trust it much. Also using
the
i found the solution shortly after i sent the mail.. runinstaller and it
will show all the installed product with verions ;-))
On Tue, 11 Feb 2003 00:33:36 -0800, rahul [EMAIL PROTECTED] wrote :
list, my appologies for asking question regarding ias (solaris), but i
could not find any info
i found the solution shortly after i sent the mail.. runinstaller and it
will show all the installed product with verions ;-))
On Tue, 11 Feb 2003 00:33:36 -0800, rahul [EMAIL PROTECTED] wrote :
list, my appologies for asking question regarding ias (solaris), but i
could not find any info
Hi DBA's
Can somebody give me sql query that can get me the
last backup time of my database (cold backup thru
RMAN) and its start_time, backup_endtime from rman
catalog.
donot require LIST commands, as I have to produce a
report of backuptime for several databases.
a single database is hosting
Hi Guys,
One simple ODBC question. Our management wants a set-up where user from remote
location will access oracle database through ODBC connection, execute some sql
scripts, download data into excel files and then do whatever reporting on that excel
data. Now management wants all these sql
RMAN reports its progress provinding such information as
channel c1: starting piece 1 at 11-FEB-03
channel c1: finished piece 1 at 11-FEB-03
piece handle=df_485669402_63_1 comment=API Version 2.0,MMS Version 2.2.1.0
channel c1: starting piece 2 at 11-FEB-03
channel c1: finished piece 2 at
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database server. Not
suitable for large amounts of data, more the way to go if you're looking for
an SQL database to embed into your Java app.
Regards,
Stefan
-Ursprüngliche Nachricht-
Von: Lyndon Tiu [mailto:[EMAIL
How do randomly inmserted keys result in an unbalanced B-TREE index? Please define
your use of the term unbalanced. Perhaps I understand the term differently.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED],edu
-Original Message-
Sent: Sunday, February 09, 2003
CASE - If Size of 1 INSERT/UPDATE Statement = 1K Stripe Unit Size is 128 K ?
How will 1 COMMIT issued after 300 1K INSERT/UPDATE Statements DIFFER from 1 COMMIT
issued after EACH 1K INSERT/UPDATE Statement with respect to Writing to the
datafiles on the Underlying Striped Volume ?
If 1
Srinivas,
First look in the RC_DATABASE view to get the DB_KEY value for your
database.
Then look at the RC_BACKUP_SET and RC_BACKUP_PIECE views within the Rman
catalog. Sort by COMPLETION_TIME desc. You will see your backups listed
there. The RC_BACKUP_SET is the parent record, while the
Set the OS environment variable NLS_DATE_FORMAT to the date/time
format-string you wish...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 5:18 AM
RMAN reports its progress provinding such information as
channel c1:
Sony - I
suggest you take the Oracle Backup/Recovery course.
[EMAIL PROTECTED] 02/10/03 08:28PM Hi Ruth,In my
company we run export for our daily backup. Why is it not best way todo
backup ? and about RMAN, is it third party program on oracle or it isalready
include in oracle, or if it is a
Hello,
Can anyone tell me the reason, why I get an error because of the Order By in Oracle 8.1.5.
It works fine in 8.1.7 and 9.2.
declare
v_t number(8);
begin
SELECT tagesdatum into v_t
FROM (SELECT rownum n, tagesdatum
FROM (SELECT tagesdatum
FROM kalender
Try setting:
export NLS_DATE_FORMAT='Mon DD HH24:MI:SS'
-Original Message-
Sent: Tuesday, February 11, 2003 6:19 AM
To: Multiple recipients of list ORACLE-L
RMAN reports its progress provinding such information as
channel c1: starting piece 1 at 11-FEB-03
channel c1: finished
Is their any way of identifying which user/process is holding onto a temporary segment. I've got a 50Mb temporary tablespace and there is a temporary segment which is 47Mb which is not being freed up by SMON.
And, if i can't identify who is holding onto this TEMP segment, is their a way in whichI
Thanks.
I'm running 8i and it worked fine with that statement.
Rivaldi
-Original Message-
Sent: Monday, February 10, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L
Hi.
You would need to wrap the ALTER SESSION into an Execute Immediate
statement:
EXECUTE IMMEDIATE 'ALTER
Maria,
Here's something you may want to consider with this licensing. If it comes to blow$ with Oracle, and you do have to pay, go for the standard edition not the enterprise edition. It is much cheaper on a named user basis. Cost is in hundreds per user vs. thousands per user. You could
Dilip
Sounds as if your management is deciding to get things under control. You
can move your SQL into PL/SQL stored procedures and use ODBC to execute the
stored procedure.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, February 11,
Lyndon,
pg_dump equals export in Oracle. Actually pg_dump all = export full=y.
It's just a syntax difference. And if you have a full export all you need to to
recreate the database is create the system tablespace. And yes it is easy with
Oracle, if you keep it simple.
Dick Goulet
Listers,
I have a table of 125M rows (not partitioned) which I am
exporting. I want to break the export into 4 dmp
files using the query command on the pk column.
I am looking at how the best way of finding the values of
the PK (number) which are at 25%, 50% and 75% ish for
the table
My knee-jerk would be to check the file dates on the 8.1.7.4's ORACLE_HOME
to make sure that nothing changed accidentally. Perhaps a rogue libary or
some such?
GL!
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex,
Ian,
I'm not aware of any way to change the date format mask from within RMAN.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/11/2003 6:18 AM
RMAN reports its progress provinding such information as
channel c1: starting piece 1 at 11-FEB-03
channel c1:
Michael,
What version or Rman are you looking at? I really did not appreciate Rman
before 8.1.7 and it's predecessor in version 7. Rman for Oracle 9i is damn
nice. Instead of those messy scripts and a recovery catalog you now have the
ability to store all that stuff in the control file.
Interesting I wondered if that would work. I'll have to try it and
see... :-)
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/11/2003 7:28 AM
Set the OS environment variable NLS_DATE_FORMAT to the date/time
format-string you wish...
- Original Message
Sony
I'm not Ruth, but perhaps I can provide some helpful information.
Export is a logical backup. It is useful for recovering from some types
of failures, but not for others. For example, if I have a small codes table
that doesn't change much, and a developer makes some changes to the table
Title: RE: Oracle TEMPORARY SEGMENT
Hi,
This is what I use to clean up a temp tablespace. The tablespace is named 'temp' and it is normally set to PCTINCREASE of 10. You will need to insert the correct values for your temp tablespace. Altering the tablespace a little wakes us SMON which
I was doing some research on firewire disks when saw this article:
http://technet.oracle.com/oramag/webcolumns/2002/opinion/coekaerts_linux01.h
tml
Regards,
Waleed
-Original Message-
Sent: Tuesday, February 11, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L
Advanced Server
John,
Look
at the FILESIZE parm of export.
Lisa Koivu OracleMonkey
Administrator Fairfield Resorts,
Inc. 5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459
-Original Message-From: John Hallas
TMTOWTDI ... It's everywhere.
All these choices. Why do they have to make life so complicated?
I'm just curious: How do you turn if off?
level(0)?
-Original Message-
Hi, in 8i etc, you can use
dbms_system.set_ev(sid,serial#,10046,level(1-12),'') too.
--
Please see
Title: RE: Version Controlling in Oracle database - Ideas ?
Have you checked out Mark Stock's Presentation
at the 2002 SEOUC conference entitled:
TAG! Whose Code is it? Code Management Data Encryption
Should be available at www.seouc.org.
Matt Adams - GE Appliances - [EMAIL
It seems so..
Thanks.
Regards
M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]
- Forwarded by Emre M. Hancioglu/VSN/Effem on 11.02.2003 16:10 -
Stephane Faroult [EMAIL PROTECTED]
Whittle Jerome Contr NCI,
I think your sql should not work on a really TEMPORARY tablespace, and
temporary tablespace do not need to be cleaned either.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-11 06:49:00
John,
Have
you looked at using the FILE and FILESIZE params that are provided via the
Export utility?
According to the docs, you can provide multiple FILE
names, and specify a FILESIZE. Once Export has created a file that is
FILESIZE in size, it creates the next export file you designated
That mandates proper initrans and pctfree setting, don't
you think?
-Original Message-
From: Arup Nanda [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 10, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L
Subject:
Raj,
Another consideration is a potential for a
John,
Why bother with the query; why don't you use the FILESIZE parameter of the
export to break down the export files into manageable chunks?
Arup
From: John Hallas [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Breaking
Quoting [EMAIL PROTECTED]:
pg_dump equals export in Oracle. Actually pg_dump all =
export full=y.
It's just a syntax difference. And if you have a full export all
you need to to
recreate the database is create the system tablespace. And yes it
is easy with
Oracle, if you keep it
yep I must know this by heart now.
Also see Metalink Tech notes, 183408.1 and 220178.1 and
http://www.dbasupport.com/oracle/ora9i/RacLinuxFirewire1.shtml
regards,
Mike
-Original Message-
Sent: 11 February 2003 14:40
To: Multiple recipients of list ORACLE-L
I was doing some research
This sounds like Oracle is pricing/licensing itself out of the market.
This is not good because I see a lot of new student with MS SQL skills
and no Oracle skills. Guess what, they will want to work with MS SQL
when they finally start working. Some of these grads will become
bosses one day and
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi Lyndon
hsql == HypersonicSQL. It's a pure Java, lightweight database
server. Not
suitable for large amounts of data, more the way to go if you're
looking for
an SQL database to embed into your Java app.
I thought we were talking about Oracle
The purpose of this feature, I believe, is to accomodate transportable
tablespace restores, so that it is possible to say,transport a tablespace
from a 2K block size database, to a 4k block database.
Raj
Hi Jerry, I tried your suggestion of altering the pctincrease to a non-zero value, although the original temp segment has disappeared from the dba_segments. I now have a different temp segment which is lingering around in dba_segments.
Zabair
Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
Hi,
Hi
Maybe
I miss the point, but I don't really see the need for an order by here ? Can't
you just dismiss it ?
Regards,
Stefan
Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via
Hello Zabair,
Tuesday, February 11, 2003, 6:03:42 AM, you wrote:
ZA Is their any way of identifying which user/process is holding onto a temporary
segment.
Try this: http://www.geocities.com/oraperf/tempseg/
--
Best regards,
Sergeymailto:[EMAIL PROTECTED]
--
Hi
I just posted that as reply to your question about hsql (what is it ?).
But you're right here, it is not very scalable and also not meant to compete
with Oracle or PostgreSQL.
Enjoy your day,
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
Title: Message
Hi
list,
I issue a select
count(*) from mytable and last 30 seconds.
The table has
1,466,196 records and were loaded witha batch process, so they are in a
countinous space.
I consider that
time exagerated.
The TBS is LMT
with a Uniform size of 128 MB.
The block size is
This is all cool technology, and fun stuff to play with.
It all begs the questions,
How many of us work for a business that actually need this?
Are they willing to pay $400/user $20k/CPU above the cost
of Oracle 9i EE to use it?
Are they willing to pay the extra overhead required to maintain
Title: RE: RE: Oracle TEMPORARY SEGMENT
Hi,
It does work on temporary (that are truly temporary and not permanent) tablespaces in 7.3.4 and 8.1.7. I use it when I don't want to wait for SMON to clean things up. Just yesterday one our 'power users' ran SQL that selected from two tables with
Hi John,
the FILESIZE parameter would certainly work but if you don't know how big
your export file will be then it won't help you to split it accurately into
4.
This query should get you the 25%, 50% and 75% marks. The 100% is easy.
select * from
(select rownum rnum,a.*
from (select
Well no. Since you are comparing Postgresql with Oracle, why
can't I compare it with HSql or any other database for that matter.
And is postgresql scalable compare to Oracle? Can it handle my
Terabyte database?
-Original Message-
Sent: Tuesday, February 11, 2003 10:54 AM
To: Multiple
We are test ORACLE on LINUX system (RedHat 7 and 8) wirh ORACLE databases
(8i and 9i). Their has one problem happen when we open sql/plus on
console termineral or telnet session. If sql/plus have long list and we
press ctl-C, the termineral session hang. If outside sql/plus and press
ctl-C,
Ramon - Start by adding an index? :-)
Do you have any indexes on this table? My first guess is that it is doing a
full table scan. This does seem to be a bit long for a full table scan. Do
you expect to do a lot of full table scans on this table? If so, then you
may want to look at how to tune
Title: Message
well,
have you traced the statement yet? That's where to start, with
autotrace.
My
count(*) which executesa FTS (in a load to mitigate any ORA-1555 error)
takes 15 minutes to count 50 million rows.
Lisa
KoivuTired, Tired, Tired.
Fairfield Resorts, Inc. 5259
Coconut
I don't know anyone who needs it but Oracle is behind it and that means that
sooner or later they'll start to shift licenses. I'd be foolish to ignore
the chance to experiment with RAC at home for £150 (I had a lot of the kit
already) rather than pay Oracle £1158 for a 3 day RAC course (plus the
Stefan,
The original query returns the 6th highest value so the ORDER BY is crucial.
At least if I read it correctly.
Cheers,
Mike
-Original Message-
Sent: 11 February 2003 16:24
To: Multiple recipients of list ORACLE-L
Hi
Maybe I miss the point, but I don't really see the need
In this statement, I'm trying to get (last working day - 6 days) from a specific table. If I remove the ORDER BY, I can never retrieve the correct rownum and of course the date.
Regards
M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162
I totally agree. I alway thought Oracle should just give it
away to class rooms. The more people knows Oracle, they will
want to use it at their work. At a small, mid size company is
often the tech guy who will have a big saying over what technology
to use.
-Original Message-
Sent:
alter session set events '10046 trace name context off'
or
exec sys.dbms_system.set_ev(sid, serial#, 10046, 0, '')
Richard Ji
-Original Message-
Sent: Tuesday, February 11, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L
TMTOWTDI ... It's everywhere.
All these choices. Why do
Quoting Stefan Jahnke [EMAIL PROTECTED]:
Hi
I just posted that as reply to your question about hsql (what is it
?).
I misunderstood your previous answer. I thought you were talking about
an Oracle command that can export a plain text sql script like pg_dump
that's why I asked.
Thank you.
I agree that HSql is not meant to compete with Oracle or Postgresql.
But then is Postgresql meant to compete with Oracle? I don't think so.
My point of bring HSql in is to show that you aren't comparing the
samething.
It would make more sense say to compare the diffculty of backup/recovery
Tom, Lisa, Stephane
I did consider that but I was originally exporting using direct export
and I could get the whole table out in 4 hours (compressed via a pipe).
However the import takes 24 hours.
I was looking at using a normal (via the buffer ) export with a query in
so that I could import
And what is the point of sending text messages
to someone elses phone when you could just call them?
Sending SMS is not meant to replace phone calls, but
there are situations when sending a SMS is more desirable.
Such as you need to get a message to a person who is in a
meeting and can't take
Quoting Richard Ji [EMAIL PROTECTED]:
Well no. Since you are comparing Postgresql with Oracle, why
can't I compare it with HSql or any other database for that
matter.
You can compare anything here.
I misunderstood hsql as an Oracle command/script/package (new?,
hidden?, secret??) that I
Tim,
Besides it is available on Metalink, accessable to those users who are
holding valid support licence and Jared is just pointing to that direction.
There is nothing wrong in it as far as copyright is concerned. There is no
theft involved of any sort as Jared did not claim ownership of that
Hi,
1. create unique index or primary key AND update statistics of the table
2. use count(1) instead of count(*)
JP
On Tuesday 11 February 2003 17:19, you wrote:
Hi list,
I issue a select count(*) from mytable and last 30 seconds.
The table has 1,466,196 records and were
I'm with Mike on this one, except I was just told earlier this morning
that the current client I'm at wants to move the 11i apps to RAC. DO
they need it, nope, do they want it, yep(and have basically already cut
the check for the cost of RAC(since its on sale till end of month) :)
So the
Jerry,
Your sql will never run on Temp tablespace 'that are truly temporary' in
8.1.7
Just see the results
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
SQL alter tablespace temp default
Quoting dist cash [EMAIL PROTECTED]:
We are test ORACLE on LINUX system (RedHat 7 and 8) wirh ORACLE
databases
(8i and 9i). Their has one problem happen when we open sql/plus
on
console termineral or telnet session. If sql/plus have long list
and we
press ctl-C, the termineral session
Quoting Richard Ji [EMAIL PROTECTED]:
I totally agree. I alway thought Oracle should just give it
away to class rooms. The more people knows Oracle, they will
want to use it at their work. At a small, mid size company is
often the tech guy who will have a big saying over what
technology
Quoting Richard Ji [EMAIL PROTECTED]:
I wonder how scalable PostGreSQL is by default using default configs?
I know Oracle in it's default configuration ain't scalable. Funny
cause I know certain companies use Oracle thinking this is the
solution to their database scalability problem. Only to be
e have ORACLE 8.1.7 on SUN erver. My question are:
1. how to check which object or role are grant to public (from DBA)?
(e.g. grant select on tax to public)
2. How to check which object or role are grant to which users?
Thanks.
Richard - How do you think the Oracle Education division would react to this
proposal? ;-)
Never underestimate the power of corporate politics. But seriously a
large organization succeeds to the extent that it can look at the long-term
good of the organization. Overall I think Oracle Corp. has
Interestingly enough, I haven't seen an official statement on count(*) being
slower than count(column name).
Sunil Nookala
DBA
Dell Corp.
-Original Message-
Sent: Tuesday, February 11, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Hi,
1. create unique index or
It does sound like a database command, doesn't it?
There are a quite a few open source database out there,
depends on what you need, they might just do the job as good
as any others.
-Original Message-
Sent: Tuesday, February 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
I am trying to run rootpre.sh. My admin just upgrade the kernel to 64-bit.
We were running 32-bit on this box and everything was fine. No Oracle
software is running. I am going to install 64-bit 8.1.7 Ent Ed for AIX 5.1L
when I got this trying to run rootpre.sh.
This is what I get when I run:
Why use count(1) instead of count(*)? They all does the same thing.
So does count(primary key).
Richard Ji
-Original Message-
Sent: Tuesday, February 11, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi,
1. create unique index or primary key AND update statistics of
I attempt to update a record and receive following error. How do I fix it?
update trunkgroup
set originating_carrier = 0110,trunkgroup_id2 = 606,'
where trunkgroup_id = '0TWPAAEDS0' and gateway_id = 'GAAA0';
ERROR at line 1:
ORA-02291: integrity constraint (DBIMPL.CARRIER_FK9) violated -
I have to manage MySQL and ORACLE for the web likewise.
There seems to be a strong tendency towards MySQL if people newly enter the area of
webpresence, students or profs doesn't make a difference.
PLEASE spare me the pain: I *DO* know the differences between ORACLE and MySQL. (...
at least
Lyndon,
True, an export file is peculiar to Oracle. The difference between a
commercial database and an open source one. IBM and MicroSludge do the same.
The functional purpose though is the same.
Dick Goulet
Reply Separator
Author: Lyndon Tiu
Welcome to Corporate America, where damagers who have never written a code in the last
decade (if ever) and have been promoted beyond their competence level make decisions
about what is best for their systems and applications. DBA's and the like are little
peeon grunts that do the work. Who
Why should the default be scalable? Please tell me, how does Oracle know
how many CPU, Memory, the type of IO system, transaction volume and whether
it's OLTP or DSS, on and on... Every database application is different.
Scalability means different things to different database environments.
And
you really want to go there? compare MS SQL's backup recovery training to
Oracle's.
MS: 1 day of the 5 day intro admin class
Oracle: more than a day of the 5 day 9i Admin II class - and you have 5 days
in Admin I before that
used to be worse - was a separate 3 day course in Oracle land.
of
This asks for two parameters, the userid and the db_link. If you leave the
db_link blank then it looks for the userid on the present database. To
check for public give auserid of public. Slice and dice to fit your needs.
-- Posted by Jacques Kilchoer [EMAIL PROTECTED] on ORACLE-L
set linesize
I want to set up a glogin.sql and a login.sql. I am reading the manual and I find
this. Oh yea. I'm on 8.1.7 on NT.
When you install SQL*Plus, LOGIN.SQL is copied to the DBS subdirectory, and GLOGIN.SQL
is copied to the SQLPLUS\ADMIN subdirectory of your Oracle home directory.
If you modify
Richard,
In theory, yes it can. Would I want to push a postgresql database that
hard, maybe not. But I will agree with Lyndon, it is a very nice open source
db.
Dick Goulet
Reply Separator
Author: Richard Ji [EMAIL PROTECTED]
Date: 2/11/2003
dba_tab_privs
dba_role_privs
dba_sys_privs
dist cash wrote:
e have ORACLE 8.1.7 on SUN erver. My question are:
1. how to check which object or role are grant to public (from DBA)?
(e.g. grant select on tax to public)
2. How to check which object or role are grant to which
Joe,
Moving a 11i environment to RAC to 'fix' performance issues will only worsen
it IMHO. Apps 11i is a complex beast, with a lot of cross-functional queries
as well as a hard-hit central set of tables belong to the AOL. You can bet
that there will be a ton of cross-instance pinging - albeit
David:
I would say that there is a foreign key on the originating_carrier column
and the value 0110 does not exist in the parent table.
Rick Weiss
-Original Message-
Sent: Tuesday, February 11, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
I attempt to update a record and
Hi, I have the following code. it compiles fine and
runs successfully. But when I checked email in
[EMAIL PROTECTED], I didn't get any mail. I'm testing on
the same machine (win2000, 817). Anybody knows why?
Thank you in advance.
create or replace PROCEDURE send_test_message
IS
mailhost
look at dba_tab_privs for object grants (this will include stored
procedures)
look at dba_role_privs for roles
and read the manuals, you'd be amazed at how many questions can be
answered by doing that
--- dist cash [EMAIL PROTECTED] wrote:
e have ORACLE 8.1.7 on SUN erver. My question are:
I just found out from Oracle support that you can't run Oracle 8.1.7 64-bit
on AIX 64-bit. Is this true and has anyone ever done it?
Thanks.
David Ehresmann.
-Original Message-
Sent: Tuesday, February 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
I am trying to run
Quoting [EMAIL PROTECTED]:
Lyndon,
True, an export file is peculiar to Oracle. The difference
between a
commercial database and an open source one. IBM and MicroSludge do
the same.
The functional purpose though is the same.
Question:
Why a binary file? More efficient? I find the
John,
use the 'volsize' parameter.
Look at 'exp help=y'
Jared
John Hallas [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/11/2003 06:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Breaking
Unfortunately I don't have the reference in front of my right now, but I
believe the optimizer has a built in way to understand a count(*) and it is
just as fast or faster than count(column_name).
-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple recipients of list
sorry my script is a UNIX script!
Orysia Husak
Database Management Services
perotsystems - CHW Phoenix
(602) 307-2896
(602) 300-9752 (Cell)
-Original Message-
Sent: Thursday, February 06, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Could you post it to the list?
Igor
If I remember correctly, there was a discussion here a while ago (like
a few years) on which was faster and I believe (caffeine levels are
low, so memory could be faulty) that it was determined that it made no
difference which you used.
This was pre 9i so things could have changed.
--- [EMAIL
I fixed it. I decided if the DBS directory was not created by the Oracle install than
I will go and create the directory for Oracle. I then dropped my login.sql into the
directory, fired up SQLPlus and my login.sql worked. Maybe I should of just sent a
HELP instead. ;o)
Dave
-Original
Quoting Markus Reger [EMAIL PROTECTED]:
I have to manage MySQL and ORACLE for the web likewise.
There seems to be a strong tendency towards MySQL if people newly
enter the area of webpresence, students or profs doesn't make a
difference.
For web work. MySQL is very popular (Together with
With Oracle 6 and sometimes in Oracle 7 one count was faster than the other.
With Oracle 8.0+ you'll see that count(1) == count(*) == count(unique
column) == count(not null column)
Don't believe me? Try it.
-Original Message-
Sent: Tuesday, February 11, 2003 12:55 PM
To: Multiple
Hi,
You want to check the views:
DBA_ROLE_PRIVS, DBA_SYS_PRIVS, DBA_TAB_PRIVS, ROLE_SYS_PRIVS,
ROLE_ROLE_PRIVS.
You can refer the 'Oracle 8i reference' for description of these.
Regards,
Charu.
-Original Message-
Sent: Tuesday, February 11, 2003 6:26 PM
To: Multiple recipients of list
1 - 100 of 160 matches
Mail list logo