I think I forgot to take my happy pills today.
Raymond,
What possible input could you be looking for here? Have you designed the
database? If not, start there. That requires some business process
analysis. When you've designed the DB, you'll know what data elements you
need to get out of
>From a table's pre insert trigger we are inserting to the same table (thru a
procedure). But the recursive effect is stopped by using some logic (i.e.
The second record is put only if the :NEW.status equals something. In the
second insert, the record is put with a different 'status'. ). Is this
Larry, that's brilliant. That solution hadn't occurred to
me.
On Sun, 24 Mar 2002 20:53:19 -0800, Larry Elkins wrote:
>
>The easy way around it is to use Native Dynamic SQL.
>
> 1 DECLARE
> 2 dual_message VARCHAR2(20);
> 3 BEGIN
> 4 Execute Immediate
> 5 'SELECT CASE
> 6
I heard of it some place. that is try to have three different
tablespaces. One for large table, one for medium size table and third
for small tables. Each of these tablespaces can have their own extent
sizes. Large having large extent size. Medium can have medium size
extents and same for small ta
First it seems like you want to understand the report. The report does
have some comments on the top of the page, what to expect. However, if
you can buy the book that Dennis suggested, you will get additional
information on how to interpret the report.
The book also provides many scripts that ge
Hi Friend
Currently I'm going to do a conversion for our client to convert their
system into our Oracle 8i Db..
I have prepare the package/function/procedure...
and some of those script for the system.
Did you all have any conversion checklist for the purpose ?? Should I do a
benchmarking first
Hi Gurus,
The problem has been resolved. Not enough disk space in the /var/tmp
directory.
Regds,
ChorLing
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Tuesday, March 26, 2002 10:23 PM
To: Multiple r
So Dave, was your question answered? ;)
Jared
"Farnsworth, Dave" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/26/02 09:30 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Customize my SQLP
Actually, when you think about this for a moment, it's not such a bad idea.
The format below would need some improvement but WTF. I bet it ends up
being an Oracle 9i release 'n' feature.
where use_nested{A.col1 = B.col1, taba_pk, tabb_pk}
where use_bitmap{A.sex = 'M', taba_bdx}
I'll
Hello ALL,
I have set up the statspack on Oracle 8.1.7 and just now I also got the
REPORT , but poor me unable to understand that . Can anybody help me out in
this ... Well I know www.oraperf.com will do it for me by sending a report ,
but I want to do it myself by writing some queries ... would a
One thing no-one seemed to have mentioned is that
login.sql is only processed once. A workaround to
this is to have some extra files:
connect.sql
===
conn &1
@login.sql
conn.sql (same as above)
Then you can use:
SQL> @conn system/manager
system@DEMO>
hth
connor
--- "Farnsworth, Da
You mean all this time my hints like the following:
select *
from table
where /*+ LET_ME_CHOOSE_THE_ORDER */
/*+ DO_ME_FIRST */ col1 = 12 and
/*+ NOT_ME_YET */ col2 = 13 and
/*+ WHEN_YOU_GET_A_MOMENT_TRY_ME */ col3 = 14
isn't going to work ?
:-)
--- Jonathan Lewis <[EMAIL PROTECTED]>
w
seems like You are loading data from one version of database to the other
version , try to use the version compatible tool like
sqlldr80, sqlldr73. sqlload.
I guess this may be your problem
-Original Message-
Sent: Tuesday, March 26, 2002 4:30 PM
To: Multiple recipients of list ORACLE-L
I am trying to load data from a 8.1.7 SQL Loader session to a 7.3.4
database.
I am getting a SQL*Loader-282: Unable to locate character set handle for
character set ID (0).
error message. Can anyone tell me how to get around this?
Thanks!
Ron Smith
DBA
Kerr-McGee Corp
--
Please see the officia
No you don't need a book as such it is a pretty neat schema. Read the
spreport.sql and sprepins.sql scripts, they will tell you a lot of things
that you need to know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamada
search for Star Query Execution Method
in this doc: http://www.dbatoolbox.com/WP2001/dssdw/star_query.pdf
-Original Message-
Sent: Tuesday, March 26, 2002 4:54 PM
To: Multiple recipients of list ORACLE-L
Read about star schema execution plan.
Regards,
Waleed
-Original Message
It's faster to only have one join to the large fact table.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 1:25 PM
> Hi.
>
> I am tuning a query that runs against a star schema
> and a few dimension tables. The plan show
Dennis,
I have got all the statistics in the STAT tables now and I would like to
query them to see the last info. regarding performance of the system. Seems
like I may need to purchase a book .
Thanks for the mail.
Reddy
-Original Message-
Sent: Tuesday, March 26, 2002 3:44 PM
To: Multip
Read about star schema execution plan.
Regards,
Waleed
-Original Message-
Sent: Tuesday, March 26, 2002 4:26 PM
To: Multiple recipients of list ORACLE-L
Hi.
I am tuning a query that runs against a star schema
and a few dimension tables. The plan shows that the
first step is two join
Jay,
Two possibilities:
1. Before you add the constraint, issue a Select query with the Where clause
being the NOT version of your Check Constraint. This is the least hassle.
2. Use the Exceptions Into clause when you create the Check Constraint.
This will populate an Exceptions table with the
You could always do a select to see which rows will violate the check. If
you add a check like (X>5) then to see what rows would violate this do
something like:
select *
from table
where X<=5;
--
Paul
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
S
Hello:
Check the following web site to get statspack related whitepaper.
http://otn.oracle.com/deploy/performance/content.html
Thanks
>
> Hello ALL,
> I have set up the statspack on Oracle 8.1.7 and just now I also got
> the REPORT , but poor me unable to understand that . Can anybody
> he
Sorry, fat fingers varchar2s is a table of varchar2(256)
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any cl
At least you need the DBA to report bugs, open tars and apply patches!
Regards,
Waleed
Any views or opinions presented in this email are solely those of the author
and do not necessarily represent those of the company
-Original Message-
Sent: Tuesday, March 26, 2002 1:29 PM
To: Multiple
Reddy - I assume that you mean that you ran the statsrep.sql and printed the
report. Is your question about interpreting this report? There is a good
series of articles at
http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html
Or is your question how to write your own queries? If that
Gene, what's the next step in the explain plan? Can you post it?
Are the dimension tables small?
Lisa Koivu
Oracle Database Tank.
Fairfield Resorts, Inc.
954-935-4117
> -Original Message-
> From: Gene Gurevich [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 4:26 PM
> To:
Hey Dave...
I counted
- outsource
- trending
- managed service
- leveraging
- best practices
- continuous basis
- strategic
but I'm sure I missed some... does this mean I win? :-)
Cheers!
Paul
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesd
Jay,
Look into the EXCEPTIONS INTO exceptions syntax of ALTER TABLE.
The exceptions table is created by utlexcpt.sql or utlexpt1.sql
Lisa Koivu
Oracle Database Baby Oven.
Fairfield Resorts, Inc.
954-935-4117
> -Original Message-
> From: JJ [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, Mar
Reading descriptions of the effects of Autoallocate leads me to
think that Autoallocate is nothing more than PCTINCREASE redux--a
little less crude, but still no way to manage your space.
Paul Baumgartel
--- sundeep maini <[EMAIL PROTECTED]> wrote:
> Dennis,
>
> I mentioned Autoallocate and no
Sundeep
Oops, egg on my face. Reading too fast, seeing one word and thinking
another. My understanding from "Stop Defragmenting and Start Living" was
that uniform extents was the direction Oracle was heading. The problem with
autoallocate is that you can end up with fragmented tablespaces
John,
The accepted term for what you call "extended suburbia" is
"edge cities". In Sacramento, examples that violate your 100
mile rule would be Roseville/Rocklin & Folsom, although I
guess you could see them as "edge cities" of the larger Bay
Area in some sense.
OT, but perhaps interesting in t
There's a note on my website in the errata and addenda
to the book, chapter 8, about this. 64MB extents kick in
when the segment has grown to about 1GB.
However, oddities occur all over the place, particularly
when the tablespace has been exercised for a while.
It is possible for Oracle to be p
Looking at Raj's post I seem to have made at
least two errors in my original reply - the size of the
varchar2s in the dbms_sql array and the question
of whether a varchar2 can be 32K, 32,000 bytes,
or 4,000 bytes in pl/sql. Perhaps there are a couple
of version-dependent details that need to be
Hi.
I am tuning a query that runs against a star schema
and a few dimension tables. The plan shows that the
first step is two join two dimension tables via a
cartesian join. Why would Oracle does that instead of
joining the dimensions to the fact table one after
another? Can anyone offer an expla
This is a bit of what I do, for those who wonder...
I *AM* one of those persons we are discussing, and I work from home. I've
got clients in Texas, Oklahoma, Pennsylvania, New Jersey, Virginia,
Ohio, and others that are often just a phone number and passwords...
What I do is just a tad different
When a check constraint is added to a table, is there an option in Oracle
that will display or list the rows
in the table that violate the constraint ? TIA.
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: JJ
INET: [EMAIL PROTECTED]
Fat City Network Services
Uncle Larry (and his cohorts) issue such Earth-shaking,
'Future-direction-for-IT' type pronouncements as a way of assuring
themselves when they are in a hole. Hate to say it, but there are a lot of
Internal Oracle 'Consultants' without projects and Oracle would like to keep
them employed at $300/h
[EMAIL PROTECTED] wrote:
> you forgot DNA sample. Rachel's good, but come-on! not THAT good.
wanna bet?;-)
PS for those of you who remember and were following my job saga, we were
sold yesterday. well, partly sold anyway. the closing is 4/10 and
we're still not sure if there will be any
Dennis,
I mentioned Autoallocate and not autoextend. I have
been using LMTs for over a year now but only with
UNIFORM extent sizes. I am not sure if I am ready to
handover space management to Oracle (via Autoallocate
which is being foisted upon me as a panecea of all
ills) least I have evaluate
Sundeep,
Major differences between AUTOALLOCATE and UNIFORM is the fact that extent
sizes in AUTOALLOCATE tablespace are not uniformly-sized.
I've been working in v9.0.1 (not 8.1.7 -- don't have one of those!) and
noticed the following pattern in non-partitioned tables and
range-partitioned tabl
And how much time will my database take? The database size is 118Gb, the
disk transfer rate is 1 Mbps, the physical memory is 64Mb and two 486's ;-)
Anne
you forgot DNA sample. Rachel's good, but come-on! not THAT good.
-Original Message-
Sent: Tuesday, March 26, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Even though I am beyond lazy, I don't write any code, or RTFM (remind us of
someone??)...I did manage to steal some audi
And also Metalink doc 105120.1
"Reddy, Madhusudana" wrote:
>
> http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/tspaces.htm
>
> -Original Message-
> Sent: Tuesday, March 26, 2002 12:54 PM
> To: Multiple recipients of list ORACLE-L
>
> Can someone point me to good reading
"The fact that the industry is trending to a managed service model for
database administration is NOT A BAD thing for salaried DBAs out there. I
think the opposite is true."
So, let us all second the Oracle sales pitch about them managing our
databases for us, and hope to sneak into Oracle ;-)
Rafiq,
Yes, that's what I meant.
Cool!! We can discuss this off line.. as I have a few questions.
- Kirti
-Original Message-
Sent: Tuesday, March 26, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
By HDS's ShadowImage you mean Hitachi Data Storage ShadowImage.
Yes, we are in
Alter tablespace is a better option wherby you can do it while database is
up and only that particular tablespace is offline. OEM does the same thing.
You can use it for any tablespace except SYSTEM tablespace which you cannot
put offline.
For 'Alter database' you need down time as database ca
Seema Singh wrote:
>
> Hi
> one of export for 35GB database is taking 12 hours.How to reduce this export
> time.
> Thx
> Seema
>
Try direct=Y, and (if nobody is currently using the database, otherwise
you risk running into inconsistencies) try to export in parallel, by
exporting several owners
Create another temp1 tablespace not big. point your user temp tablespace to
temp1. Offline your temp tablespace and do whatever you want. Once done
point back the original temp tbs and drop temp1 tbs.
No system down time.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of lis
Yes, I know it's 32767.
My code:
PROCEDURE ...
sqlstr VARCHAR2(4000);
sqlstr := my_pack.GETSQL( sql_id ... ); -- function
OPEN my_cursor FOR sqlstr;
...
END;
If the length of sqlstr is > 4000,
I get an exception and the error is: sqlstr _IS_NULL_
Why?
I'm using 8.1.7.0.3 on Linux.
JP
Is there any need to create a standby database in this case? My procedure
for copying production to development is:
1. alter database backup controlfile to trace; (in production)
2. Restore a production backup (either hot or cold) to the development
server
3. Update database name and filenames in
> That looks like it works also. Many ways to skin a
> cat.
true..!! Thanks for not taking this the wrong way..:)
Cheers,
RS
__
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the off
Todd Carlson wrote:
>
> Solaris 5.8 Oracle 8.1.7.2
> Has anyone successfully renamed the Oracle user on a solaris box? At the
> moment I don't a test box and this is a rarely used development system.
> The current Oracle user and group are oracle2 and dba2. We have to
> change it to match our sta
Even though I am beyond lazy, I don't write any code, or RTFM (remind us of
someone??)...I did manage to steal some auditing triggers from Rachel C. and
place them on the new table. When Tom inserted those nasty pictures, the
trigger fired and emailed Tom's name, address, phone number, height, we
Depends how you are getting that 4,000 characters
to the procedure, of course, but a pl/sql varchar2()
can in principle be 32,000 bytes.
And if that isn't enough, you may have to fall back
to dbms_sql which exposes a packaged type which
is an array of varchar2(255) so that you can build,
pass,
Sundeep - Start by reading the classic paper "How to Stop Defragmenting and
Start Living" at this link:
http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm
Actually, autoallocate and uniform extents work very well together. But you
need to understand the concepts behind them first. And make sur
ROTFLMAO that *is* funny
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Tuesday, March 26, 2002
http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/tspaces.htm
-Original Message-
Sent: Tuesday, March 26, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L
Can someone point me to good reading material on this
subject. Is one better than the other for performance
and man
Sorry, I should have specified the backup was first. Thanks for the
sanity check Brian!
Todd
-Original Message-
Sent: Tuesday, March 26, 2002 12:06 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 & #
By HDS's ShadowImage you mean Hitachi Data Storage ShadowImage.
Yes, we are in process of setting up new HP hardware with Hitachi Storage
and planning to use their Shadow Imaging within couple of months for all our
production database backup. So far no practical experience but from demo it
see
Also look into the option BUFFER in export.
Srini
-Original Message-
Sent: Tuesday, March 26, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
I think you can use direct=y option.
Are you taking this export to a file (over disk) or directly to tape?
Greeting
Diego Cutrone
---
Well trained monkey is (I think) the phrase that I last heard for Apps
DBA... I think it has something to do with the fact (as I have seen it semi
first hand) that you need to be able to use your four extremities
productively, as well as your prehensile tail.
April
-Original Message-
Sen
Hmm this is a classic RTFM, but the answer is here ...
if you are using dbms_sql then use "procedure dbms_sql.parse(c in integer,
statement in varchar2s, lb in integer, ub in integer, lfflg in boolean,
language_flag in integer);" syntax. This requires you to declare a local
variable of type
FAST EXPORT:
1. High Buffer
2. Have export on a disk where you have less activity of i/o
3. Do Not Export to a NFS mounted file system/disk , which is very slow.
Hope this helps
---
Madhu
-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of li
Just don't know can i make off line TEPM tablespace or not? alot of users
using it ...
-Original Message-
Sent: Tuesday, March 26, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Tom,
if he is going to have the tablespace off line with
database up and running , shouldn't the comm
Put a blank line at the end of your script. I don't know why it does that
but that's the fix.
"Farnsworth,
Raj,
That looks like it works also. Many ways to skin a cat. I personally have
gotten used to using OEM and letting it issue the command.
I think they both would work.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, March 26, 2002 1:44 PM
To: Multiple
I did this for a while with the 7.3 client. Performance was abysmal.
My network admin also was on my case about network traffic. I don't
know if the Net8 client would be better or not. Pointing TNS_ADMIN to a
network drive is great, but unless there have been significant changes
in the client
JP,
No, but you can make multiple 4000 char strings and concat it all together:
sel1 varchar2(4000);
sel2 varchar2(4000);
where_clause varchar2(4000);
order_by_clause varchar2(4000);
begin
open my_cursor for sel1 || sel2 || where_clause || order_by_clause;
I do it all the time!
Hope this help
Do you have a favourite (or favorite) joke in the
Oracle manuals. I've been reading the Oracle 9
SQL reference manual - as one does from time
to time - and spotted this gem on p. 2-97:
/*+ ordered_predicates */
Use this hint in the WHERE clause of SELECT
statements.
Can I propose this one f
Make sure you didn't issue consustent=y and refer to
meta link for any problems with direct export on your
platform. Direct is the way to go.
Cheers,
RS
--- Diego Cutrone <[EMAIL PROTECTED]> wrote:
> I think you can use direct=y option.
>
> Are you taking this export to a file (over disk) or
> d
do this:
exp usr/pass buffer=4096 file=xx log=xx owner=xx. It takes 2 hours for
a 59GB's database.
-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
In a sociology course I took they explained that capitalism and publicly
traded companies naturally tend toward oligopolies, followed by monopolies.
Not sure if that is true - I was hoping the antitrust laws would prove
useful, but...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA
It used to be better, when we could just call them. We used to have silver
support.
Then, at first, Web TARs were answered promptly.
I don't know if there has been a change in policy, but as soon as it's past
regular hours I get little feedback from Metalink technicians.
They used to have a su
If you don't "@glogin.sql" before you truncate a table with millions of
rows then you deserve to be unemployed (IMAO).
Brian P. MacLean
Oracle DBA, OCP8i
Get out the BS bingo cards..
;o)
-Original Message-
Sent: Tuesday, March 26, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Rocheste
Hello everyone,
This is a very interesting thread. Speaking as a part-owner of one of the
companies John held up as an example o
Oracle Wants Users to Hand over Apps Management = Oracle Wants Users to Hand over
Money.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL PROTE
ok it's done. check your database. I also populated it with all the URL
links to child-porn. the FBI is knocking at your door right now. check the
BLOB columns. pretty nasty stuff stored there.
-Original Message-
Sent: Tuesday, March 26, 2002 1:29 PM
To: Multiple recipients of list
I think that this is a marketing ploy by Oracle, much like the DBO
(and frankly to a lesser degree the OCP) in an effort to deal with
the simple supply/demand problem with Oracle DBA's. Somehow, the tag
line on my emails seems to apply here... :-)
Robert G. Freeman - Oracle8i OCP
Oracle DBA Techn
And do you expect a link or a real example script???
On Tue 26. March 2002 19:29, you wrote:
> Can someone please create a table for me? Umm...I need last and first name
> columns. I don't want the DDL, I want you to connect to my database and
> create it for me. I need this done yesterday.
>
Hello
I'm using variable sqlstr VARCHAR2(4000) in procedure to create SELECT string.
But the length of my SELECT * FROM is bigger than 4000 chars.
Is there a way how to call OPEN my_cursor FOR sqlstr;
for sqlstr longer than 4000 signs?
JP
--
Please see the official ORACLE-L FAQ: http://w
Can someone point me to good reading material on this
subject. Is one better than the other for performance
and manageability?
Syntactically the autoallocate is shorter and seems to
be more hands off (does that mean worry free also?).
TIA
=
Sundeep Maini
Consultant
Currently on Assig
You don't. It's a habit you have to get into. And it only works if you
haven't changed your directory. Like I said you can have another script
that has login commands
(INV-SYSTEM)>@elvis
Enter password: *
Connected.
(INV-ELVIS)>
My @elvis script is simply this
connect elvis@inv
@login
I
Well,
being in health care industry myself I know too well
what do you mean. Apart from 100s of tousands of $
lost every hour we are down, we have to take some
safety also into account.
As to the question of advanced replication, having
implemented multi-master replication myself I know
what a nig
>From what I understand, the task is daunting keeping a release up to date.
They've really built a beast. When you hear people on this list talking
about "APPS DBA's", you get the feeling that it is something special.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent
How do you know you ran the login script?? Maybe you forgot? And your
really on production...when your about to truncate that table...that's
unrecoverable...that's billions of rowswith hundreds of recent Fairfield
customer reservations...that will be very upset...
BTW, any chance you can "s
I think you can use direct=y option.
Are you taking this export to a file (over disk) or directly to tape?
Greeting
Diego Cutrone
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 3:13 PM
> Hi
> one of export for 35GB da
>>1. Is the critical data would be updated in the sites..?
Yes...
>> 2. If yes , are you expecting the other sites to 'see' this update...?
Yes...
>> 3. If one site is down, then are you expecting the other sites to share
the >> load or you have the closest site in take in all the load...?
Yes
bu
Hello All,
Is anyone using HDS's ShadowImage for backing up large databases? Our Sys
Admin Dgmt is pursuing this technique and is suggesting that all large
databases be backed up using this software.
Good? Bad?
Any insights would be appreciated.
My Damager is already crying foul as HDS will cl
Tom,
if he is going to have the tablespace off line with
database up and running , shouldn't the command be
alter tablespace rename file '< >' to '< >' ;
Cheers,
RS
--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> Hamid,
>
> .dbf is prefectly valid on all machines, as far as I
> know.
>
Are they implying that Oracle Applications is proving too difficult to
administer for many sites?
; )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Tuesday, March 26, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject:
[EMAIL PROTECTED] wrote:
> check sqlplus\admin under ORACLE_HOME
yup, my bad.
--
--
Bill "Shrek" Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program like you don't need the money,
You g
Create yourself a script called "connect.sql" that looks like:
connect &1
@@glogin.sql
Keep it in your SQL_PATH just like your glogin.sql. Now when you connect
to something else just precede your "connect" statement with a "@" as in:
@connect un/pw@db02
Can't be much easier th
Oracle has been saying for years that you wil no longer need DBAs. I
suppose it's possible, although the database gets more and more
complicated each release, as more and more new features that can shoot
themselves in the foot are added.
On the other hand, SOMEONE will need those DBAs. Oracle? An
I have a custom-coded @connect.sql script that I run instead of the build-in
connect statement
HOST chmod 600 /tmp/xxx.sql >/dev/null 2>/dev/null
SAVE /tmp/xxx.sql REPLACE
CONNECT &1
@login.sql
/bin/rm -f /tmp/xxx.sql >/dev/null
UNDEFINE 1
-Original Message-
Sent: Tuesday, March 26, 200
In fact, here with Oracle 7.3 we had .dbf for data files, .ora for init.ora
file and other config files, and .trc for trace files, .log for log files,
etc.
With the GUI tools introduced with Oracle 8, the extensions were different
-- .ora for everything it seems to me, but I still prefer the diff
[EMAIL PROTECTED] wrote:
> and response time than a well trained DBA can? Fair enough with bug checking
> and alike, but how long does it take for a lot of you to get iTARS answered
> etc.?
maybe they aren't answering iTARs so they look better delivering it
themselves? "see we can do it fast
Can someone please create a table for me? Umm...I need last and first name
columns. I don't want the DDL, I want you to connect to my database and
create it for me. I need this done yesterday.
Thanks, really, thanks. Hurry up!!
-Original Message-
Sent: Tuesday, March 26, 2002 11:59 A
Hello everyone,
This is a very interesting thread. Speaking as a part-owner of one of the
companies John held up as an example of the successful outsourcers (thanks
for mentioning us John), I'd like to make some points that I think will be
of interest to all.
The first is that working in a shop
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 & #4 with "find / -user oracle2 -exec chown oracle:dba
{} \;" as long as oracle2 is the only member of the dba2 group and you're
not using the "oinstall" as oracle2's default group.
I think #4 should be "-grou
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
time.
Thx
Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.c
1 - 100 of 186 matches
Mail list logo