THIS WILL WORK and shud be more efficient than instr() or 'select from dual'
SELECT * FROM shipment WHERE ship_name like '%' || ship_id || '%';
Regards
Naveen
-Original Message-
Sent: Tuesday, December 17, 2002 6:44 PM
To: Multiple recipients of list ORACLE-L
Another way to perform
You can recreate the password file, you can recreate the instance with a
different password, and you can also connect from the server machine by
simple 'connect internal' in sqlplus. just check the value of ORACLE_SID, it
should be pointing to the DB
Regards
Naveen
-Original Message-
Dear Sony,
Make your REMOTE_LOGIN_PASSWORD_FILE in INIT as Exclusive,restart the instance
and then change the password of SYS.
The password of INTERNAL will also be changed and will be
the same as SYS.
Best Regards
Jai
Sony kristanto [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/18/02
by the way, don't you use post-it
;-)
-Original Message-
Sent: Wednesday, December 18, 2002 12:44 PM
To: Multiple recipients of list ORACLE-L
Dear everyone,
I already installed oracle 8i database on my server, to make my
system secured I changed my 'INTERNAL' password but I
No.
You could probably simulate something close with a lot
of hard work
hth
connor
--- VIVEK_SHARMA [EMAIL PROTECTED] wrote:
Does the Feature Online Redefinition for
RE-Organizign Objects , Adding Fields , Converting
to Partitioned Table Exist in Oracle 8i ?
--
Please see the
Hi
Is it possible you FTP'd the export file across to the new machine in ASCII
mode (the default on win systems)? Always ensure you use BINARY mode - the
stray LF's get substituted by CRLF's inside the export file and it really
messes up the internals and can sometimes the imp utility to skip to
And that is what it *should* be used for :)
-Original Message-
[EMAIL PROTECTED]
Sent: 17 December 2002 19:35
To: Multiple recipients of list ORACLE-L
Yes, it's a dictionary based cracker.
Could be useful for checking for weak passwords.
For $4, I'm going to see what it does. :)
Thanx guys for all your guidance.
Thanx Kirti.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to
Thanx guys for all your guidance.
Dale,
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to ORACLE
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to
Jared's answer still stands
you can't
--- faisal ahmad [EMAIL PROTECTED] wrote:
HR
htmldiv style='background-color:'DIV
Pquistion is this that how can dba see a user,s password in readable
outputt. i mean if password is tiger it should be seen as
tigerBRBR/P/DIV
DIV/DIV
DIV/DIVgt;From: [EMAIL
Why are you sending it repeatedy? or is there a virus?
Regards
Naveen
-Original Message-
Sent: Wednesday, December 18, 2002 3:49 PM
To: Multiple recipients of list ORACLE-L
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a
I have a 4.0.8.1 Oracle Application Server implementation on a Solaris 2 .6
box
that I am trying to move to a new, presumably identical, box. We are moving
it
by simply copying all of the datafiles from one box to the other. We can
not
get it to start! If any one can offer a suggestion, it
http://gppl.terminal.ru/
JP
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Chicken feed.
Only 100,000,000$
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 5:13 PM
http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.h
tml
Enjoy :)
- Kirti
--
Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed, parallel query and Spatial Data options
PL/SQL Release 2.3.4.5.0 - Production
SQL create user test identified by test;
User created.
SQL select password from dba_users where username = 'TEST';
PASSWORD
Oracle
produced some .NET items, mostly connectivity-related.
http://otn.oracle.com/tech/windows/content.html
Regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Exploit. des systèmes Technology
Services | Services
technologiques
Joan,
Can't this be done as a series of ors instead of the union alls as this
would presumably reduce it to one full table scan of each table.
e.g.
SELECT T11.TRUNK TRUNK_FOUND
,T21.IDTARGET_ID
,T21.SSN TARGET_SSN
,T21.FULLNAME
Thanks Jesse
I am going to start it with 9.2.0 so hopefully it will be better.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 8:44 PM
Yechiel,
We weren't able to get OID replication to be stable
oraora - I doubt that Import did insert that record. The message says it
skipped that record. Check the table to see whether it was inserted. What
did you set for the parameter IGNORE?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
Not all that hard - but I don't like the bit that starts
update obj$ set
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )
Next Seminar dates:
(see
Jared,
I installed the development tools and that worked!!
Thanks
Sumathy
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Panicker, Thankam S.
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Which version of Oracle ? 8.1 or 9.2 ?
It could make a difference because of
the 'free split' change in code that appeared
in 9.2.
I don't recall the error I got - but some time
back I was working on a partition exchange
strategy and testing the effects of tablespace
corruption in
SETORACLE-L DIGEST EDOUARD DORMIDONTOV
Yes, reality check:
If you're making less than US$50,000 per day, you're not a member of the
upper class.
So save your pennies.
; )
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Wednesday, December 18, 2002 7:14 AM
To: Multiple recipients of list
Joan - Just a random thought inspired by your explanation. Is this query a
part of cleaning data for a data warehouse? Or worse yet, is the developer
attempting to use this query in an attempt to avoid creating a data
warehouse? Normally the best solution for the situation you describe is to
I think there are too many generic arguments
available for picking the 'right' block size for
your indexes.
The one that is most appropriate is likely to
depend on the nature of the activity (load
vs. query), nature of the index (unique,
nearly unique, far from unique), data clustering,
order of
Title: RE: db block Size for Indexes Tablespaces in 9.2 ?
We use 8k for data and 8k for indexes in our OLTP system ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
There is a good paper on .NET at www.arstechnica.com, right-hand column.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Do they have to pay licensing fees to Microsoft for win-os/2 I wonder.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Title: RE: slow query help
Joan,
Here is a suggestion ...
if this is going to be your most used part, I'd look into Intermedia ... you'll have a lot more options to work with and they will work good.
Until then, I'd recommend replacing instr() with appropriate LIKE clause because at-least
EDOUARD, EDOUARD, EDOUARD
HELP!
-Original Message-From: Edouard Dormidontov
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 18, 2002 7:24
AMTo: Multiple recipients of list ORACLE-LSubject:
SETORACLE-L DIGEST EDOUARD DORMIDONTOV
oraora,
Did the original export come from a database that you have access to?
Check the description on the table that had failed to insert some rows.
The original source table has different sizes on the columns than the
tables you are importing into, That is why some records are getting
rejected
Connect as the DBA and change the SYS and SYSTEM passwords.
Recreate the ORAPWD file.
Just a few suggestions.
Ron
[EMAIL PROTECTED] 12/18/02 02:13AM
Dear everyone,
I already installed oracle 8i database on my server, to make my
system secured I changed my 'INTERNAL' password but I
Just remember, I you don't have the database shutdown while you back them up
the backups will be unusable.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 1:29 AM
Well for this you can use cpio command in Unix for
Happy digesting :-)
sorry, Jared, - couldn't resist
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Edouard Dormidontov
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 18, 2002 8:23
AM
SETORACLE-L DIGEST EDOUARD
I will add a vote for cpio. I have found it to be so reliable that I used
cpio, instead of a dump utility, to back up Unix boxes. It never failed.
In the past, I found that tar had filename length limitation that was
shorter than what the OS permitted (80 characters iirc -- that's filename,
not
One thing I don't think I've seen mentioned is the issue of storage
configuration and uptime requirements impact on capacity planning. Is the
planned system 7x24 or will there be maintenance windows to add storage?
Can storage be added hot or is downtime required. These issues will require
the
Kurt,
If the ip address/hostname are not identical on the new box it won't
run, you have to re-install it from cd. All of the network configs are
hard coded during install and there is no way to change them. I went
through this a couple of years ago when the SA changed the ip address to
a 10
Ok, I'll ask the obligatory 'Are you stupid?'
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 9:19 AM
EDOUARD, EDOUARD, EDOUARD
HELP!
-Original Message-
Sent: Wednesday, December 18, 2002 7:24 AM
To:
Hi!!
Check for the -K option of the TAR command...
is for supporting files 2 Gb...
if you do not have that option, you could use CPIO
HTH
JL
--- Ashraf Salaymeh [EMAIL PROTECTED] wrote:
Dear List,
We have UnixWare 7.1 and I want to take backup of
Database files (Physical files) to my
Ruth,
Does this mean hot backups don't work for UnixWare 7.1? Otherwise, cp,
cpio, ufsdump or any other method of copying the disk file from location a
to location b should be ok, shouldn't it?
John
-Original Message-
Sent: Wednesday, December 18, 2002 8:44 AM
To: Multiple recipients
We've just started experiencing a problem where a client-server Forms
4.5 application hangs and then produces this error:
ORA-00600: internal error code, arguments: [kksscl-inf-inl-loop],
[1500], [0], [1], [41], [41], [], []
Our database is version 9.2 and we found reference to a bug on
Jared,
Can you send me the script you use. I can't even figure out the syntax for
DBMS_SPACE from the docs. I would be very grateful
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 17, 2002 3:58 PM
I use DBMS_SPACE to
DUAL
Yechiel AdarMehish
- Original Message -
From:
Farnsworth, Dave
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 18, 2002 4:19
PM
Subject: RE:
EDOUARD, EDOUARD, EDOUARD
HELP!
-Original Message-From: Edouard Dormidontov
Bob;
I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate
DDL for objects in the database.
So, you can write your own. All the neccessary information is in the
catalog.
-Original Message-
Sent: Wednesday, December 18, 2002 9:16 AM
To: Multiple recipients of list
if you use perl on your site, I can send you my perl scripts, which I copied from from
9i DBMS_REDEF.
hth
-Original Message-
Sent: Wednesday, December 18, 2002 3:49 AM
To: Multiple recipients of list ORACLE-L
No.
You could probably simulate something close with a lot
of hard work
There are scripts out there that will do the job, though most of them start
to fall down if the indexes are at all unusual.
I bought a book a couple of years ago with a whole selection of scripts to
create ddl for database objects - It should still be available on Amazon.
Cheers
Simon Anderson
Again, why NO Oracle version specified?
If on 9i DB, then use DBMS_METADATA
HTH YMMV
HAND!
Bob Metelsky
Patrice,
I really don't know much about it. I just remembered a feeling of
shock and wonderment when I was reading a webpage where someone was
installing eComStation. I just wanted to pass that same wonderment
along :-)
-rje
BPJ Do they have to pay licensing fees to Microsoft for
Eekk!
Sorry - 8.17 on win2k
Again, why NO Oracle version specified?
If on 9i DB, then use DBMS_METADATA
HTH YMMV
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
I finally have a bit of time and was wondering what are different
methods to get DDL other than
Export rows=n
Using Quest SQL navigator
Using The Databee tool
Ideally Id like to get it from a sql plus command but Im pretty sure
that's not available. DDL dosnt seem to be available from DBA studio
The SysAdmin is backing up the filesystems/raw partitions where the informix db
resides w/out putting the db in hot backup mode. He was told by a consultant, all you
have to do is backup the informix logs and db files for full recovery. As an Oracle
DBA and not familiar w/ informix, is this
Title: RE: Oracle bug 2316137
You could always install oracle in another oracle home, Patch that home
Then all you need is 1 min down time to shutdown the db and bring it up with the other patched oracle.
-Original Message-
From: Glenn Stauffer [mailto:[EMAIL PROTECTED]]
Sent:
I thought, it was:
ARE YOU AN IDIOT? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 10:04 AM
Ok, I'll ask the obligatory 'Are you stupid?'
Ruth
- Original
Anyone know who that hacker is??
Reply Separator
Author: Mark Leith [EMAIL PROTECTED]
Date: 12/17/2002 6:23 AM
Yes, you can do this, but it still doesn't tell you the users *current*
password does it?
Has anyone tried:
Try this sql script:
/*
* DBA Skeleton Key
*
* This script will allow one to crash into any Oracle account.
* The only restriction is that the invoker must have the
* 'alter any user' system priviledge.
*/
accept usrname char prompt 'Enter account name to crack: '
set verify off
break
Title: Itanium 2
Has anybody out there tried and Itanium 2 system?
I read that oracle is supposed to certify 9i on it at the end of the month.
But I was wondering if anybody had installed one of the Developer Release's.
If so what kind of performance did it give you? Anywhere close to what
Venu,
Another issue to be concerned about is the possibility of
encountering an ORA-1555 error. This error may be triggered by a condition
called 'Fetch Across Commits'. The cursor must maintain read consistency
while it is open. If you are updating the source data and the undo entries
are
Oracle Enterprise Manager 9.2 version has it. Right click on the object and
choose Show Object DDL
If you use 9.2, you can use dbms_metadata.get_ddl procedure.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 10:15 AM
I have a rule - don'thand out advise with
limited information - it may be "factually challenged". and sometimes I break my
own rules - as in this case. But then again, this is not "advise"; merely my
opinion based on the very limited background information I had.
I agree - the panacea to an
Raj,
I thought it would only do the union all if it was able to use an index and
all the instr's look as though they'd stop that. Even then I thought it was
generally just rule that would do that unless you used the use_concat hint.
I can't see why a full table scan of each wouldn't be
Title: RE: Oracle bug 2316137
If you have cursor_sharing=force ... can you use cursor_sharing=exact and see if the error reproduces? I think (and I could be wrong) that this setting will at-least buy you some time.
Search for 'kksscl-inf-inl-loop' including bug database, you'll find many
I have gone the consulting route three times in my
career. Here are some observations in no particular
order of importance.
Solo is a tough way to go. You have to find the
business and do the work. Either, done right is a
full time job.
In spite of the fact that as professionals we place a
I know this is probably hopeless, but has anyone managed to let the Oracle
Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect
to a 9i database?
It wants to connect as SYS, and of course 9i only wants sys to connect as
sysdba.
This if for my home sandbox PC, I don't have
Thanks, Dave! I just started looking into using DBMS_SPACE.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 11:14 AM
Ruth, have you seen this doc on metastink? It might be helpful.
Note:116923.1
Dave
Title: RE: Informix backups
by all means Gene, test it... and watch out for that boogeyman named Rman.
Lisa Koivu
Oracle Database Something.
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Original Message-
From: Gene Sais [mailto:[EMAIL
Any non-totally-up-to-date tool will typically
struggle to get *all* of the ddl. A good example
would be in 9i where the table compression flag has
unfortunately been left off the dba_tables view. The
info is of course there (tucked away in seg$) but
you're setting yourself up for a lot of work
You're right of course, sorry, Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 10:30 AM
I thought, it was:
ARE YOU AN IDIOT? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
ðÏÍÏÝØ!
-Original Message-
Sent: Wednesday, December 18, 2002 10:30 AM
To: Multiple recipients of list ORACLE-L
I thought, it was:
ARE YOU AN IDIOT? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L
Ruth, have you seen this doc on metastink? It might be helpful.
Note:116923.1
Dave
-Original Message-
Sent: Wednesday, December 18, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
Jared,
Can you send me the script you use. I can't even figure out the syntax for
DBMS_SPACE from
Create Your own script or find one in internet that uses data dictionary.
Gints Plivna
-Original Message-
Sent: trediena, 2002. gada 18. decembr 17:16
To: Multiple recipients of list ORACLE-L
I finally have a bit of time and was wondering what are different
methods to get DDL other than
Title: RE: Methods to get DDL
Bob, TOAD (freeware version) will do it for you also. However, as far as scheduling something to run regularly, exp rows=n is the easiest.
Lisa Koivu
Oracle Datablackeye Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA
Hi,
Beginning january , I'll be on a team to implement
Sungard Compass product which run on Oracle 817.
Any comment on that product ?
TIA
=
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
[EMAIL PROTECTED]
Title: RE: Methods to get DDL
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Im wondering what methods people are using?
I'd like a quick way to get the ddl for say... One index
TOAD
I was thinking of simply copying the datafiles using the OS facilities.
If you are putting hot backups to tape directly I am not sure that they will
be usable for recovery. RMAN requires a third party media manager to handle
backups to tape. If rman can't do it, I am not sure that homegrown
Title: RE: Stored procedure memory problem
As long as you are committing transactions, you shouldn't worry. Beware of leaking Oracle processes though ... they might harm you.
On 9012 we have two packages that run ALL the time basically they de-queue from a multiple of AQs and perform
Title: RE: Methods to get DDL
The only problem with TOAD I have is I soon forgot where information is stored to write the script by hand. It is a nice tool, I have been using it since late 96, but that's a problem with all GUIs ...
Raj
__
Nigel,
Finally, as this is my first post to the list, perhaps I should
introduce
myself as a lurker(!):
Congratulations on your change in status!
RE the mount points: I'm still fairly OS illiterate with many
features of NT/Win2k. Do you have a good URL that
would explain the use of
Downloaded and installed the tool.
Not terribly sophistcated.
If the word is not in the dictionary, it won't find it.
For instance, a password of 'SHOE' will be discovered,
but changing the O to a zero so that it reads 'SH0E', and
the password cracker will not find it.
If this were to be used
I can forward a script that shows how to use DBMS_SPACE.
The other stuff I mentioned is not exactly in packagable form.
Just use:
exec show_space('SCOTT','EMP')
Jared
create or replace procedure show_space (
p_segname in varchar2
, p_owner in varchar2 default user
,
Small amounts: sqlplus and the data dictionary.
Lot's o' DDL: Perl, DBI, DBD::Oracle and DDL::Oracle.
If that's unavailable, I use exp, then grep, sed and maybe vi to
extract and cleanup the exp DDL.
If unix bin utilities are unavailable, I install cygwin on a Windoze
machine to make them
No, this was the middle of the afternoon. Each of those runaway processes
were at one time associated with various users in the database doing
various tasks, mostly selects. No user complained, so I assume they got
detached from their shadow and maybe thought they were logged out? I was
wow, that was unusual...
ôÙ ÉÄÉÏÔ? :-)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 11:59 AM
ðÏÍÏÝØ!
-Original Message-
Sent: Wednesday, December 18,
You need to set O7_DICTIONARY_ACCESSIBILITY=TRUE in the database.
--
Paul
-Original Message-
Patrice J
Sent: Wednesday, December 18, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L
I know this is probably hopeless, but has anyone managed to let the
Oracle Portal Configuration
Simon,
thanks for the plug, although it helps if you tell them the name of the
book :)
caveat: the scripts were written for 7.3.4, and should work mostly on
8i but have NOT been updated for 9i so if you are using any of the 8i
or 9i new features they may not work.
Rachel
--- [EMAIL PROTECTED]
On Wed, 2002-12-18 at 11:49, Jamadagni, Rajendra wrote:
If you have cursor_sharing=force ... can you use cursor_sharing=exact
and see if the error reproduces? I think (and I could be wrong) that
this setting will at-least buy you some time.
I'll have to try that idea.
Search for
Thanks a million! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 12:50 PM
I can forward a script that shows how to use DBMS_SPACE.
The other stuff I mentioned is not exactly in packagable form.
Just use:
exec
Yay! Finally! A question I can actually answer.
http://support.microsoft.com/default.aspx?scid=KB;en-us;205524; describes the
tools you can use to manipulate mount points in W2K, while
http://support.microsoft.com/support/kb/articles/323/4/24.asp is the
equivalent for Windows .NET Server.
I do not get it.
If you put the tablespace in backup mode and then use the os utilities to
copy the datafiles to tape why you can not use then for recover. Just
restore the datafiles and the archive logs and do recover?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of
Damn. Can't get the Russian-to-English translator working with any browser
on Babelfish...
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Igor Neyman
What's the easiest way to do regular expressions in an SQL query?
If the answer is creating a function, does anyone have one they wouldn't mind
sharing?
Thanks,
Chris
Christopher Beckley
OCPDBA, MCDBA, MCSD, EIEIO
ThirdParadigm LLC
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
I want to have the services necessary for Enterprise Manager and Oracle
Internet Directory to start when I boot my machine. I understand where to put
the scripts that start the processes; I just don't know which processes to
start, apart from dbsnmp (which doesn't seem sufficient by itself). Any
Rich, do you need a translation?
ðÏÍÏÝØ! - HELP!
ôÙ ÉÄÉÏÔ? - Are you an idiot?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 1:55 PM
Damn. Can't get the Russian-to-English
I am using home grown scripts and they work. I have Legato use savepnpc (pre/post
proc) command call this script:
//begin snippet comment section
#!/bin/ksh
###
# $ORABIN/db_hot_backup.ksh
Hello DBAs,
I am currently involved in improving the search performance for a tool
which queries a table having a million records (and the table is growing at
a rate of 3000 records per day).
Thought of introducing Intermedia search for 4 columns in the search table.
Created CONTEXT indexes
The key is putting the tablespace in backup mode. It then doesn't matter
whether you write the file to disk or tape. Homegrown scripts will work
just fine in writing directly to tape, although it should be quite a bit
slower than writing to disk and then letting the system backup process
simply
Having been independent for over 20 years, and now a permanent employee (if
anything is permanent) for the past three years, one idea might be to
broker your services through placement or consulting firms where you have
a better idea of the companies background and what you are getting in to.
For
Try:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1745425::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:2200894550208,%7Bregular%7D%20and%20%7Bexpressions%7D
Ask Tom has whole write up on it.
Greg
-Original Message-
Sent: Wednesday, December 18, 2002 2:04 PM
To: Multiple recipients of list
What do you mean by regular expressions is SQL... inquiring minds want to
know
Regards,
Bill Burke
The Kinder and Gentler DBA
www.OracleGuru.com
www.KBMotorsports.biz
-Original Message-
Sent: Wednesday, December 18, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
What's the
1 - 100 of 142 matches
Mail list logo