Prod. DBA tends to be more responsible.
App. DBA tends to be more creative.
But could be both 8=) and the best are.
--
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Junior DBA's job is a learning.
Mid DBA's job is a science.
Sr. DBA's job is the Art.
Srs feel database, users, developers and everything else.
They feel what, where, how, when and why should by done.
Their intuition is of high degree.
... and everybody is sure - the Sr DBA knows everything. (so
Title: RE: Jr.DBA, Mid level DBA, Sr.DBA
We
Since I live in Israel I do not know the salaries
ranges.
Senior DBA lives in Spain
Junior DAB lives in England
Midlevel DAB lived 200 years ago in Europe.
Yechiel AdarMehish
- Original Message -
From:
Richard Huntley
To:
wow, so turf
-Original Message-
Sent: 30 May 2002 17:23
To: Multiple recipients of list ORACLE-L
Hello Gurus
I got this link through SAG-L. Have a try.
www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html
Yechiel Adar
Mehish
--
Please see the official ORACLE-L
Lee,
I am always reluctant to post something which may look even remotely commercial but
Oriole markets this kind of tool. It's, we believe, reasonably priced and you can try
it for free, so perhaps it's worth for you to have a look before going into a
full-blown development.
As far as
Dear All,
I am gettying the follwoing error on our alert_log
file,though no porblem in the activity of database.
Has any one faced this problem, It is AIX, Oracle
8.1.7 Database and non archived mode. We never gave
like recover any thing, why it is trying to recover
from error message as
Hi List,
I am new to oracle,
Archive Log has filledup the entire hard disk.
(No error thrown by the Oracle)
Can I move those(zip) files safely to other location.
(win2k,Oracle 8.1.6)
(I did went thru the manual)
thx
Sam
__
Do You Yahoo!?
Yahoo! -
Danny,
Many RMAN errors will show a hit when searching Metalink. I found the
following related document on Metalink when I searched with the RMAN-10031
error:
fact: Oracle Enterprise Edtion 8.1.7
fact: Recovery Manager (RMAN)
symptom: Unable to register a database
For what it's worth I'll add my .02 cents worth to this. I've been
in IT now for 14 years, started with Informix for my first 3 or 4 years,
the rest with Oracle. I've seen my share of duhvelopers but get the
best giggles from the fights that happen between DBA's and System
Admins. You know
Hand, Michael T
Harvinder,
My experience has been that Oracle applies rownum first, then order by. So,
first it retrieves records that pass the 'where' clause, then sorts them.
The results of your examples may be explained by the use of an index - try
running explain plan against them to see if an index was
Without having better information (i.e. I assume you are running Oracle between 8.1.6and 8.1.7.2), I would say that you are running into bug 1467871 fixed in 9i and patched in 8.1.7.3 and 4. The work around is to recreate your control file, thus loosing all your backup information stored in the
Title: RE: Archive log full
Do a backup that includes deleteing the archive logs.
-Original Message-
From: sam d [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 2:23 PM
To: Multiple recipients of list ORACLE-L
Subject: Archive log full
Hi List,
I am new to oracle,
Archive
BigP,
You'll have to rebuild the table from scratch as a partitioned table. Yes
you can expect a performance gain, based on the fact that you partition it
appropriately Also, if you haven't already licensed the partitioning option
from Oracle, or installed it, you will have to.
One
Hi
If no error now you'll get one soon (read the alert logs)
you can safely move all the archive logs that are finished writing. I
assume you have more than a day worth of archives so if you move anything
older than a day for now you should be fine.
after that it's time to write your
Thanks Cherie I saw that one too...I was hoping that there was another fix rather than
having to shut our production database down, but after many hours on the phone with
oracle and getting nowhere, I just recrreated the control file and it did solve my
problem.
[EMAIL PROTECTED] 05/31/02
Sam,
Yes, you may move and delete the files and copy them to tape for
safekeeping.
Note: If you are using Rman, you should run an Rman archivelog backup -
otherwise, it will complain about needing to back the files up.
Tom Mercadante
Oracle Certified Professional
-Original Message-
This is an error that occurred while recovering from a rolled back
transaction. Not a database recovery.
This could be caused by doing a control-c while trying to truncate a
large table (Bug 1400739 fixed in 8.1.7.1). Could also be from an undo
operation on a leaf key of a bitmap index. You
You absolutely need to keep the log archive destination disk space free
to create new logs. You NEED to keep these archives for at least the
time of the last beginning of a hot backup, or, if you're doing cold
backups (with the database service stopped) then you need the archives
from at least
One item I've learned about Oracle from our recent audit is that
if you have not licensed an option, but installed it they don't
really get bent out of shape so long as your not using it.
I've had Oracle Support tell me to install EVERYTHING and just use what
I'm licensed for. The logic
Wow Joe, how very like-minded we are.
I'm not in the least swayed in this opinion by my programmer/system
administrator/oracle DBA career path.
3 years PL/1,DL/1 and Assembler programming for those of you with good
memories.
3 years mainframe system admin (VSE? VM?). Actually still programming
Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.
PLEASE Do Not send your resume for this position UNLESS you are fully
certified and
have the skills outlined below for this position.
Please Do Not send your
You can use insert select , export/import, create as
select to move data from a non-partitionned to a
partitionned table.
Partitionning helps in the management of large tables
more than in speeding the queries.
Will you delete data from that table one day ?
Choose the partition key carefully.
Anyone on the list done a comparison(or worked with both) MySQL and
Oracle and can give me the good/bad points of My SQL?
Doing interviewer thing and someone has My SQL who would like to move
into the oracle world and i know nothing about mySQL and am wondering if
the transition from one to
BigP - I agree with Dick that you will need to create your new partitioned
table and copy the rows from your current table into it. Given your
questions, before you charge into partitioning, carefully study the ways
partitioning can increase your performance. It isn't just some magic pixie
dust
see, this is why I always bribe my SAs. chocolate seems to work well,
beers after work as necessary :)
--- Joe LaCascio [EMAIL PROTECTED] wrote:
For what it's worth I'll add my .02 cents worth to this. I've been
in IT now for 14 years, started with Informix for my first 3 or 4
years,
the
-- paquette stephane [EMAIL PROTECTED]
You can use insert select , export/import, create as
select to move data from a non-partitionned to a
partitionned table.
Partitionning helps in the management of large tables
more than in speeding the queries.
Will you delete data from that table
Amen to that. Keep on the good side of the sys admins!
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, May 31, 2002 9:19 AM
To: Multiple recipients of list ORACLE-L
see, this is why I always bribe my SAs. chocolate seems to work well,
beers after
no aliens either the foreigner or outer space kind,
this response follows the same as the HELP command.
I just feel the need.
joe
OraStaff wrote:
Great Company located in Greater Dallas, Texas area (Richardson) needs 2
CERTIFIED (OCP)
Oracle DBAs for full time staff positions.
PLEASE Do
Joe,
I would say that depends on the needs of the job. If the guy/girl is trying
to get a development slot, yeah not too hard. If a DBA slot, the difference is
kind of night day. As a junior DBA I'd be inclined to say yes, then pack the
person off to an Oracle DBA class pretty quick.
Big (or should we just call you P?),
I have become somewhat experienced at manipulating
large partition tables since I have had to do it so
often (can you say poor initial design?). Export /
import is not the fastest way to go.
Here are some tips from the trenches:
1) You mention that each
(UPI) WASHINGTON, DC Police warn all male clubbers, party-goers and
unsuspecting pub regulars to keep alert and stay cautious when offered a
drink from any woman. A new date rape drug on the market, called beer, is
being used by females to target unsuspecting men.
The drug is
BigP,
You stated that you would like to limit the number of rows in a
partition. The partitioning option uses a range function on a column
to determine what partition to place to data into. If you do not have a
column that is used in your where clause, you are going to have a
difficult time
We use both here, use'em as back-end databases for our hosted web sites.
MySQL is fast, easy to set up and maintain, and free. Works great for our
small and medium-sized web sites. But, it doesn't scale as well as Oracle
and we've had better luck using Oracle with our large, active sites. MySQL
I can confirm that this is true and a good idea. Testing is also done in
this fasion. Besides that, an Oracle salesperson would gladly have you
pay more without having to do anything on their part or yours. ;)
Regards,
Michael Sale
Author: Oracle9i for Windows(R) 2000 Tips Techniques
I like:
REQUIRED: Oracle OCP certification, 3+ yrs. OCP DBA experience, Oracle
Database 8.x, 8I
uh-8.x has not been out for 3 years, has it?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 31, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
We have a designer that is adding a FK on two columns from one table to
another. These two columns are not in the parent table's primary key.
So we are kind of scratching our heads wondering if you can, from a proper
design point of view, create such a FK? It appears that if you update one
of
Title: rebuilding indexes
Under what conditions would an 'alter index .. rebuild'
actually case the size of the index to increase
by about 12 percent?
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix is user friendly.
It's just particular about who
I've seen MySQL truncate data on insert without warning.
MySQL also does not have foreign keys. It accepts the syntax of
create foreign key, but nothing is created, nothing is enforced.
I recently did a migration from MySQL to Oracle, and these were the
two major issues I faced.
Let me know if
Title: RE: * Certified Oracle DBAs Needed in the Dallas area..
I have a stable work history! As a teenager I worked at a race track cleaning out stables. Some of those skills and the working environment translated well into being a DBA.
Jerry Whittle
ACIFICS DBA
NCI Information Systems
Stable Financial Services Company in Memphis, Tennessee needs a
Peoplesoft/EPM Administrator
for a full time staff position.
PLEASE Do Not send your resume UNLESS you have the skills outlined below for
this position.
* Please do not send your resume unless you have a stable work history.
The transition to oracle from mysql is a great deal
more complicated than the inverse. I am hoping that is
what you meant :}
--- Weaver, Walt [EMAIL PROTECTED] wrote:
We use both here, use'em as back-end databases for
our hosted web sites.
MySQL is fast, easy to set up and maintain, and
Greetings,
Here is the scenario.
I have 2 users(owner1, owner2) in an oracle database.
owner1 owns 150 tables.
owner2 needs select,insert,update,delete privilege on all the tables owned by owner1.
One option is : login as owner1 and
grant select,insert,update,delete on owner1.table1 to
Yes, that's exactly what I meant.
-Original Message-
Sent: Friday, May 31, 2002 9:59 AM
To: Multiple recipients of list ORACLE-L
The transition to oracle from mysql is a great deal
more complicated than the inverse. I am hoping that is
what you meant :}
--- Weaver, Walt [EMAIL
Hi,
I have a table with 1 field and 2 dates: field1, date1, date2. I need to find the
max value of date2 for all the field1, date1 combinations. Then I want to join the
table to itself on field1 and find all the rows where field1 matches, date1 date1,
and max(date2) max(date2). I did
I'm trying to collect some links of resources that compares various
databases
Here is the result until today
http://www.itsystems.lv/gints/compare_db.htm
You all are welcomed to send more!
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Ashoke,
Run the following script from the owner1 account:
set head off
set lines 120
set pages 200
spool grant.sql
select 'grant select,insert,update,delete on ' || table_name || ' to
owner2;'
from user_tables
/
spool off
@grant.sql
good luck!
Tom Mercadante
Oracle Certified Professional
Chris,
The column in the parent table needs to be the PK or be unique.
Should be no problem.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, May 31, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L
We have a designer that is adding a FK on two
Title: RE: Design question.
Chris,
Is there a unique constraint based on the two fields in the parent table? If so it might work OK. Still there are the problems of referential integrity, orphan records, etc. If there isn't a unique constraint in the parent table, you can also add in
try something like this:
set serveroutput on size 100;
declare
v_sql varchar2(4000);
cursor c_cur is select table_name from user_tables;
begin
begin
for v_cur in c_cur loop
v_sql = 'grant select,insert,update,delete on
'||v_cur.table_name||' to owner2';
dbms_output.put_line('did
Most of our Oracle databases are not that busy. I decided a week ago to start
capturing individual SQL statements. I run
a korn shell script every minute to do so. The script invokes the following SQL
insert into oracle.statement_info (SID, USERNAME, STATUS,
OSUSER, MACHINE, RUNTIME,
Try this
select a.f1, a.d1, a.d2
from
(select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
a,
(select field1 f1,date1 d1,max(date2) d2 from temp group by field1,date1)
b
where a.f1 = b.f1
and a.d1 b.d1
and a.d2 b.d2
-Original Message-
Sent: Friday, May 31,
Title: RE: Design question.
I
agree that "Not Good" might characterize this - what it points out is "not good"
table design. the parent table now will have a row with two unique items -
the existing primary kay, and a combination of two other
columns.
I
would review the tabl3e designand
8.x has been out for some time. I was using 8.0.4 back in '96 or so...
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author: Oracle9i New Features
Mastering Oracle8i
Clark Griswold
This depends on what the interview is for. MySQL, Oracle, Access,
PostgresSQL, and SQLServer are all databases and can be accessed with SQL.
Other than that, they are all completely different.
On Fri, 31 May 2002, Joe Testa wrote:
Anyone on the list done a comparison(or worked with both)
Hello all. I am seeking opinions of experienced database folks on this
issue:
I am implementing a replication environment between IBM DB2 and UNIX Oracle
using DataMirror's Transformation Server (TS) product. TS replicates and
transforms data between disparate databases. (Right now I am
I read few articles in Linux magazine and had it installed on
my box for a while and here are my impressions:
a) It's blindingly fast as a single user database, faster then oracle.
b) It uses more or less standard SQL minus all the unnecessary functions
like substr, decode, nvl and alike
| Joan Miro, Man and Woman in Front of a Pile of Excrement
| (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8,
| Joan Miro Foundation, Barcelona
http://www.complit.fju.edu.tw/project/project3/miro3-a.htm
(
Jack,
Thanks for these great hints. I have not seen lots of these before and
they have given me lots of ideas.
Here's a question that you've induced: How do you determine what a good
value is for INITRANS?
What are the downsides of setting it too high?
Thanks,
Cherie Machler
Oracle DBA
FK can be on unique columns, not just PK columns and you would not
be allowed to add a row in the child table with a value not in the
parent table unless the child row had a null in it
--- Grabowy, Chris [EMAIL PROTECTED] wrote:
We have a designer that is adding a FK on two columns from
storage parameter difference? are you moving from one tablespace to
another without specifying parameters?
pctfree/pctused influence?
--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
Under what conditions would an 'alter index .. rebuild'
actually case the size of the index
Well, I was a VAX/VMS system administrator, and we were
a spoiled lot who was used to things like the source code
(on microfish, can you believe it?) and very good internal books.
I once knew precisely at what IPL a page fault occurs (IPL 2),
at which IPL is the clock running (IPL_SYNCH=8) and
since '98 I've changed jobs about once a year. Of course from '78 to
'98 I worked at the same company... wonder which of those they'd look
at to determine if I had a stable work history
--- Whittle Jerome Contr NCI [EMAIL PROTECTED] wrote:
I have a stable work history! As a teenager I worked
It's pretty funny what some people have bookmarked!
:D JoJo
-Original Message-
| Joan Miro, Man and Woman in Front of a Pile of Excrement
| (Homme et femme devant un tas d'excrements), 1935 97/8 x 125/8,
| Joan Miro Foundation, Barcelona
Bill :
I have currently been wrestling with the same issues as you are : How best
to configure RMAN.
I have put together an 'RMAN Configuration Doc' with 'PROs and CONs' from
information that I have scrapped together from this list, papers and books.
Like anything in Oracle - no one
Title: RE: rebuilding indexes
storage parameter difference? None
are you moving from one tablespace to
another without specifying parameters? No
pctfree/pctused influence? none
I should have put this in the original message.
Indexes stayed in original tablespace with identical
Matt,
1) Storage parameter changes? Do you specify storage
at the index or tablespace (or top partition)
level?pctfree go up? initrans go up? bigger INITIAL or
NEXT?
2) did you build it the first time using parallelism
and rebuild using single thread? When a PQ processes
is used to build an
But when you rebuild, it will reestablish the pctfree in all of the index
blocks. If you had a lot of activity this free space would have been used
in the original index and is now reclaimed.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th
Hi List,
I have decided to Upgrade the database from 8.1.7.0 to 8.1.7.4 this
afternoon on sun solaris.
Please give me any advise before I go for upgrade.
Thanks allot and have a good weekend
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality
I agree, the Jr. DBA must focus on learning.
Mid DBA...is still learning. Many Mid still view tuning/troubleshooting as
an art (with a little magic thrown in)
Sr. DBA...is still learning. Realizes that database management is a science,
requiring research, expirementation and a very healthy dose
Well then, that's not an FK.
That's just two columns that the 'duhsigner' is copying to some
other table, presenting a nice little update anomaly.
You can soon expect different programs to return different answers
from the database, depending on which table the data is
queried from.
Jared
Joe,
If the interviewee's experience is all MySql, then he/she will not know
about:
* stored procedures
* foreign keys
* triggers ( I think )
* probably never heard of an ERD
* no check constraints
That's about the extent of my MySql knowledge. Depends a lot on the
indivual,
whether or not
Attends sessions at IOUG
Junior - Assumes that all speakers know exactly what they are talking
about and all vendor tools work as advertised.
Mid - Listens to and believes Tim, Cary, Craig, Rich, Rachel, Gaja and
all other High Holy Oracle Gurus preach
Senior - Listens to, questions and tests
don't do it this afternoon... read the release notes, check for any
known bugs on Metalink and PLAN what you are going to do, including
backout of the upgrade if necessary.
upgrades are not not something you do on the spur of the moment.
of course if you decide to do this anyway and it breaks,
I'm sure it's #6 :)
--- Jack Silvey [EMAIL PROTECTED] wrote:
Matt,
1) Storage parameter changes? Do you specify storage
at the index or tablespace (or top partition)
level?pctfree go up? initrans go up? bigger INITIAL or
NEXT?
2) did you build it the first time using parallelism
and
The jr thinks that she knows.
The mid knows that she knows.
The sr knows that she knows not.
Awareness of ignorance is the mark of true knowledge.
I like cake.
jack silvey
--- Fink, Dan [EMAIL PROTECTED] wrote:
I agree, the Jr. DBA must focus on learning.
Mid DBA...is still learning. Many
Pat - I think you've pretty well covered the pros/cons from what I
understand. I haven't implemented in production, so hopefully some people
with some experience of living with RMAN will respond. How about it guys?
One point bothered me. You didn't explicitly say that you were
keeping
then the only thing I can think of is that there was heavy activity on
the index prior to the rebuild and the blocks filled and the rebuild
evened it out.
--- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED]
wrote:
storage parameter difference? None
are you moving from one
A few thoughts...
Jr. DBA: Asks the Mid or Sr. DBA where to look.
Mid DBA: Kind of knows where the answer is, but takes a bit to find it.
Sr. DBA: Answer is dog eared in one or more of his office full of books.
Really Sr. DBA: Answer is dog eared in his own book or paper.
Jr. DBA: Feels a lot
Thanks John
John Kanagaraj [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/30/2002 03:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Oracle apps 10.7 client on Windows 2000
Jared,
We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps 11.5.6 on
8.1.7.2 database.
Right now we do not have the temp files converted to quick io and wonder if we should.
The guy who installed Quick IO didn't seen to think we could but he was a pretty
junior person.
Lose 20 blocks in 10 days! Load as much as you
normally do and still lose index width.
no segment size restrictions or tiring delete routines
that never seem to finish. easy-to-follow
substr(column,1,1) update routine that guarentees a
maximum of data loss and a minimum of storage!
email to
I second that emotion. Write your plan down and think
it through. Do some research about what problems you
will encounter. Decide how to backout in the event
that the data dictionary goes poof or all the datafile
headers become inconsistent. Script and test your
upgrade on another system if
On Fri, May 31, 2002 at 08:40:51AM -0800, Gogala, Mladen wrote:
I read few articles in Linux magazine and had it installed on
my box for a while and here are my impressions:
a) It's blindingly fast as a single user database, faster then oracle.
b) It uses more or less standard SQL minus all
Hi,
The following link has the procedure to convert temp files to qio files..
http://support.veritas.com/docs/233722
We have converted our temp files to qio files and I think from performance
point of they should be converted to qio.
Mohammed Ahsanuddin
Oracle DBA
-Original Message-
AIX? Come on all really senior DBAs work on SUN
(ducking and running broken field pattern :) )
--- Freeman, Robert [EMAIL PROTECTED] wrote:
A few thoughts...
Jr. DBA: Asks the Mid or Sr. DBA where to look.
Mid DBA: Kind of knows where the answer is, but takes a bit to find
it.
Sr.
it's definitely friday :)
--- Jack Silvey [EMAIL PROTECTED] wrote:
Lose 20 blocks in 10 days! Load as much as you
normally do and still lose index width.
no segment size restrictions or tiring delete routines
that never seem to finish. easy-to-follow
substr(column,1,1) update routine
Hi Kathy,
Here is an excerpt from the Veritas Admin Guide.
Chapter 3, Using VERITAS Quick I/O P69
Handling Oracle Temporary Tablespaces and Quick I/O
You cannot convert temporary tablespaces using regular files to Quick I/O
files. By
default, qio_getdbfiles skips any tablespaces marked
Better run like WIND!! All Real DBA's use HP.
Dick Goulet
Reply Separator
Author: Rachel Carmichael [EMAIL PROTECTED]
Date: 5/31/2002 11:01 AM
AIX? Come on all really senior DBAs work on SUN
(ducking and running broken field pattern :) )
---
At 10:11 AM 5/31/2002 -0800, DENNIS WILLIAMS wrote:
Pat - I think you've pretty well covered the pros/cons from what I
understand. I haven't implemented in production, so hopefully some people
with some experience of living with RMAN will respond. How about it guys?
I have been using RMAN in
(ducking and running broken field pattern :) )
Opens black looking suitcase with secret Nuclear launch codes,
chanting the mantra, there is always a solution.
Enjoying that new job?
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
Author:
it's fun so far. and one of these days I'll get to do DBA work too..
right now I'm trying to Teach yourself Data warehousing in 2 weeks
--- Freeman, Robert [EMAIL PROTECTED] wrote:
(ducking and running broken field pattern :) )
Opens black looking suitcase with secret Nuclear launch
Mathew,
There has to be something that changed in the index or the storage
parameters. The index storage is basically based on the database block
size, the pctfree, the average length of the index entry, and the number
of rows in the index. If you changed none of these the index should
remain
Well, it's time to call for the cavalry.
I have a table where the optimizer stubbornly insists on doing full table scans for
practically every operation in spite of the fact that full table scans have gruesome
performance. Every hint I have tried has either been ignored or doesn't help (and
REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief Tablets
as their hot standby
Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456
-Original Message-
Sent: Friday, May 31, 2002 1:01 PM
To: Multiple recipients of list ORACLE-L
AIX? Come on all really senior DBAs
You guys are rookies. The Gods all use Linux.
--Walt
-Original Message-
Sent: Friday, May 31, 2002 1:17 PM
To: Multiple recipients of list ORACLE-L
Better run like WIND!! All Real DBA's use HP.
Dick Goulet
Reply Separator
Author: Rachel
Is there a way to copy a table in 1 sqlserver db to another, similar to Oracle's
exp/imp, or create tablle as select.., etc. It appears the only way you can do it is
thru DTS packages.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL
you win :)
--- Fink, Dan [EMAIL PROTECTED] wrote:
REAL DBAs have 28 Etch-A-Sketches configured as RAC with Big Chief
Tablets
as their hot standby
Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456
-Original Message-
Sent: Friday, May 31, 2002 1:01 PM
To: Multiple
your first statement
SELECT Record_Type, Archive_Input_File
FROM MDMA_Input_File
GROUP BY Record_Type, Archive_Input_File
why GROUP BY and not ORDER BY? I mean, what are you grouping?
I *think*, vague recollections, of reading that group by will force a
full table scan. would be interesting
command line bcp
bcp out
bcp in
-Joe
--- Gene Sais [EMAIL PROTECTED] wrote:
Is there a way to copy a table in 1 sqlserver db to another,
similar to Oracle's exp/imp, or create tablle as select.., etc. It
appears the only way you can do it is thru DTS packages.
--
Please see the
1 - 100 of 140 matches
Mail list logo