Ave !
If it's so, that user_a
like to use customer table and user_b customer_b
table with same
application, why You can't use synonyms? User_a synonyms
points to customer table
and user_b synonyms points customer_b table etc.
Or is there some decision
making before start using
Hi,
The java_pool_size can also be edited through sqlplus just use
'scope=spfile' (You'll need to bounce though). No need to open pfile edit
and create spfile.
Quite frankly I like to think that using SQL*Plus to edit the spfile
directly gives me added benefit of a syntax check (Ran a very very
Thanks all. Looks like I'll have to go with the add-an-extra-parameter
method for now as a workaround.
I don't know yet wether we're going to raise a TAR right away. The manual is
a little bit unclear about overriding the default constructor. So I might
contact a friend at Oracle first. I'll post
Which database version are you using? as long as I know, at
least on Oracle 8.0.6 you can not specify which rollback segment a particular
transaction should use. We disable all rollback segments and only enable those
which we know won't make big updates / deletes crash.
-Mensaje
set
transaction use rollback segment only works if it's the first statement in
your transaction, an easy way to make sure this is the case is to issue a commit
directly before issuing this statement.
I
believe this has been a feature of Oracle since way back in version 7 (Correct
me
Hi Group
Where I can get the details about BANN.
TIA
Senthil.
-Original Message-
Stefan Jahnke
Sent: Wednesday, July 16, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Thanks all. Looks like I'll have to go with the add-an-extra-parameter
method for now as a workaround.
I
Remember this one well it seems the publisher may have had some impact
No books now with some bullshit apology about bandwidth issues HAHAHAHA
Cheers
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW:
Check (in Control Panel) if your OMS service is running.
Gudmundur
hi
i run ora8 on w2000 server.
my problem is i can ping my database mydb without problems
i can login with sqlplus as sys and it works fine
but if i start the enterprise manager console and try to login as sys
a error
Yes you are right, sorry but I made a mistake, since we are
using Baan IVc4 which works against Oracle we have no means to interfere with
its transactions when they are commited to Oracle and we can not modify them so
that it uses a specific rollback segment, so the only way for us to do it
Hi All,
I have inherited a couple of databases on one of the servers here. The
server was taken down for hardware repairs during the week and when it came
back up the databases did not start. (They are set to start automatically
via the services)
I have done some research via the internet and I
Daniel, List
Can you give more detail with an EXAMPLE please ?
Thanks
-Original Message-
Sent: Friday, June 06, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
I have used an inline view to reduce network traffic when retrieiving
data from a remote db. Instead of using a nested
Group,
I try to only use spfile if I HAVE TO, avoid it if possible.
conservatism ? maybe.
I agree with all arguments against spfile posted so far.
RAC : use a CFS and keep a single, central db.ini somewhere,
link your ORACLE_HOME/dbs/initINST.ora to it.
If you have to use spfiles (RAC on
i know you can get the IP in a client-server mode and i think its with sys_context.
Ill have to look it up. in web mode you have to use a client side script. I know there
is a javabean you can write to do it(its actually in the forms 9i demo). dont know how
to do it in .net(which is what we are
- Original Message -
We actually don't use Object Types that much (who does anyway ;). But I have
to say, that I'm a little bit disappointed by Oracle's implementation (Ever
I do. Only way to use some of the DMBS_* library items
and one of the best ways of speeding up Java/JDBC
how does the object features improve performance of the jdbc? its fairly common now to
have a java or .net(which we are using) and an Oracle backend.
your comments would be much appreciated.
From: Nuno Souto [EMAIL PROTECTED]
Date: 2003/07/16 Wed AM 07:54:32 EDT
To: Multiple recipients of
you can get the same performance improvements by passing a REF Cursor out to the
client also.
basically he is saying that if you are over a network particularly in a web
application where you cant always control the speed of the internet access that the
client is using and you do:
select
Blind shot: I guess what's meant here is speed up the development because
you safe your usual OR mapping problems.
???
Prost,
Stefan
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 16. Juli 2003 14:20
An: Multiple recipients of list
I
think that's probably the case with most third party applications, if developers
haven't coded their apps to use a large rollback segment for certain
transactions (which I find is the case with most developers ;-) ) then the only
option is to turn off all but the large rollback seg.
http://www.pro-dba.com/oracle_10i.html
http://www.dbasupport.com/oracle/news/unixcluster.shtml
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
Hi,
Reading your mail, your registry setting for ora_wms_pfile is set to
c:\oracle\ora8\database\initwms.ora, but your oracle home is
c:\oracle\ora81, not sure if this is just a typo, but it may help you.
Cheers
Lee
-Original Message-
Sent: 16 July 2003 12:24
To: Multiple recipients of
Hi Pete, Garry and Stephan,
Thanx a lot for the solution. It is working for me.
Thanx once again,
Regards,
~Dilip
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com
Bid for for Air Tickets @ Re.1 on
Hello All,
OS: Solaris 2.8
I have to run a backup script in every alternate
Sunday.
I cant find a way to submit it in cron.
Can somebody help me how to setup a job to run
alternate Sundays in unix cron .
Thanks and Regards,
Srinivas
__
Do you
Well, the other option is to start developing apps and test them using
larger data sets then available in EMP and DEPT tables. Even with full
table scans, everything seems to work miraculously on those tables.
On 2003.07.16 08:59, Lee Cullip wrote:
I think that's probably the case with most third
Yes, but that just re-installs the prior, 2.2.0.12.0, installer. The
directions say to extract the zip to some file. How do you tell the
install where some is?
I'm not a Unix expert, but one thing you could do is schedule the script to run every
Sunday, then within the script add some logic so that the script completes every other
Sunday. For example, in ksh:
# Check to see if this script ran last Sunday.
if [[ -a ran_last_week.dat ]]; then
rm
Sorry Lee - it's a typo!!
Thanks though for pointing it out to me.
N.
:--Original Message-
:-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
:-Behalf Of
:-Lee Cullip
:-Sent: 16 July 2003 14:10
:-To: Multiple recipients of list ORACLE-L
:-Subject: RE: Oracle Instances not starting up
Hi dear list members,
we run a database 8.1.6.2
I've run into a problem. I've got a table that
contains a LONG column (I know, I know).
I have to insert a string into it that has a length 8500 Byte.
Whenever I issue the insert statement SQL/PLUS throws
the error 'ORA-01704: string literal too
Is it an 8.0.x or 8i database? What version of OEM are you running? We need
more info to be able to help you.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 6:19 AM
hi
i run ora8 on w2000 server.
my problem is i
Check the registry entry ORA_SID_PFILE. Try hardcoding
the entire path rather than use variables.
ie. ORA_WMS_PFILE would be set to c:\oracle\ora81\database\initwms.ora.
Be sure ORA_WMS_AUTOSTART is set to TRUE.
Jared
On Wednesday 16 July 2003 04:24, Nuala Cullen wrote:
Hi All,
I have
In one case, the statement's execution plan used a nested loop, where it read the
local table then probed the index on the remote table. This caused several million
trips across the network to retrieve less than 10,000 records (IIRC).
select local.cola, local.colb, remote.colc, remote.cold
from
Check:
drive:\ORACLE_HOME\sysman\log
review the oms.log file... and send the details...
HTH
JL
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
Is it an 8.0.x or 8i database? What version of OEM
are you running? We need
more info to be able to help you.
Ruth
- Original Message -
It's been a month or two since I did this, but I did verify that the
version was ...18.0, and I could swear that was the jar file I used.
I'm going to install it on another machine and note my steps, then I'll
post another reply.
--- Thomas Day [EMAIL PROTECTED] wrote:
Yes, but that just
Any Oracle/DB2 dual DBAs out there that can comment on the Rauch report (no
doubt financed by Oracle Corp)?
http://www.oracle.com/ip/deploy/database/theme_pages/index.html?ma_04252003.
html
Not that I'm particularly impressed on the ease of generating stats in
Oracle vs. DB2, but I'm just
Minneapolis, Minnesota company has a great opportunity available for a Sr. level
Oracle DBA to join their IT staff.
The selected candidate must be highly skilled in solving extremely complex
and very
critical customer issues. With preferably over 10 years experience in a
large-scale
Title: Message
We have been using
SQL Backtrack for backup and recovery forabout 6 years now. We are
being pressured to start using RMAN because it is free. Makes sense but I
am wondering about reliability, complexity, learning curve,
etc...
Has anyone had
experience with both products or
You can also supply a filename to the dump_tnsnames command.
ie. dump_tnsnames /tmp/tnsnames.tmp
Jared
On Tuesday 15 July 2003 11:14, John Kanagaraj wrote:
Jesse,
You could always get around this problem by obtaining an upto date
TNSNAMES.ORA on any Names-aware client using the 'namesctl
Jared,
can we get orastaff banned from the list? I know people need jobs but Orastaff is a
notorious spammer. I get spammed
from these guys through my home email.
From: OraStaff [EMAIL PROTECTED]
Date: 2003/07/16 Wed AM 10:54:27 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Try using sql*loader. Put the input data string in a single file as the
input file.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 9:54 AM
Hi dear list members,
we run a database 8.1.6.2
I've run into a problem. I've
Title: Message
Ron:
I don't know SQL Backtrack, but two things popped into my
head
as I read your message. One,RMAN does
not have a media interface
layer. It depends on a utility
such as Legato (also currently
included with Oracle) or Netbackup or
OmniBack. Two,EMC just
bought Legato.
Title: Message
HI,
We are
a backtrack shop also and we are happy with it.
We
have not yet pressure to go to rman.
If you
switch to rman, I'm interested in knowing the migration
effort.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
If you go on DB2 site,
http://www-3.ibm.com/software/data/pubs/pdfs/dhbrown.pdf , you'll find a
similar document that concludes that TCO of DB2 is below Oracle's one.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999
Thanks for the answer, but this no way for me.
Ain't got sqlldr on my client pc and no telnet
to the server 8-((
[EMAIL PROTECTED] 16.07.2003 16.59 Uhr
Try using sql*loader. Put the input data string in a single file as the
input file.
- Original Message -
To: Multiple recipients of
Having seen the report previously I can say that IMHO it's an apples vs. oranges
report. Given an experienced DBA on both systems I still believe that can do the same
basic task in a similar amount of time effort. Why, because they 1) understand the
process for their RDBMS, and 2) they've
Some of us like seeing the possibilities. The delete key is just to the
right of the backslash.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 11:04 AM
Jared,
can we get orastaff banned from the list? I know people
and they had NO H-1B candidates please. What a discrimination...
-Original Message-
Sent: Wednesday, July 16, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L
Jared,
can we get orastaff banned from the list? I know people need jobs but
Orastaff is a notorious spammer. I get
That, or use Block Sender.
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:14 AM
Some of us like seeing the possibilities. The delete key is just to the
right of the backslash.
Ruth
Hi Jared,
Thanks for the advice,
I checked out the registry settings
ORA_WMS_PFILE is set to c:\oracle\ora81\database\initwms.ora.
ORA_WMS_AUTOSTART is set to TRUE.
I'm a bit confused what you mean by using variables.
I think you mean not to use %oracle_home% etc but the error message:
Guido,
Can you use utl_file for this within a PL/SQL block?
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L
Hi dear list members,
we run a database 8.1.6.2
Hi
You can get the ip address as follows:
oracle:jupiter sqlplus system/[EMAIL PROTECTED]
SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
depends on the keyboard... I have one where it is right next to the enter key and backslash is next to the back space key.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path
Title: Message
I
don't haveany experience with SQL*Backtrack and I do have some
experience
with
RMAN. Here are my comments:
a)
RMAN is reliable. Once you write the backup scripts, they are executed by
operations
and there no surprises. In order to
rely on those scripts, one needs to test
Here's what I did:
1. Started up Disk1\install\win32\setup.exe.
2. Chose Disk1\stage\products.jar in Path: field as location of
product list.
3. Accepted defaults for installation.
4. After installation completed, returned to Next install screen and
chose About; version showed as 2.2.0.18.0.
List...
OS: SunOS 5.8
Oracle: 8.1.6.1.0
I'm getting the above error in the alert file...
my db is up and running, and the trace file says that
the error was generated without user session.
I looked at metalink and it says that it can be a pga
problem or virtual memory problem...
but... my
Guido...
change the datatype! :-)
Of course, you can't.
Well, have you tried with a Pl-Sql anonymous block?
or...
Oracle says that using BIND variables you can get more
than 4000 chars...
have you tried with bind vars?
HTH
JL
--- Guido Konsolke
Hi dear list members,
we run a
Regis,
that's not discrimination as it is defined in the US. it is a business
decision not to spend money to hire someone to work for you.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, July 16, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
Intersting... I get spammed at work, but never at home.
I always access this list from work.
Could be just a coincidence though.
Patrice.
-Original Message-
Sent: Wednesday, July 16, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Jared,
can we get orastaff banned from the
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Of the
total SPAM I get each day, OraStaff is so far down in the noise to be
unnoticeable. Heck I'll tolerate any spammer who only bothers me once or
twice a month. Dammed those who bother me twice an
hour!
Dick GouletSenior
While the statement itself strikes me as blunt, I don't think it is discriminatory in
this case. Because of the availability of a large number of qualified DBAs, companies
don't want to go through the hassle of providing sponsorship these days. The 'No
H-1B' clause is to filter out candidates
I find the opening from OraStaff to be very helpfull in the job search
arena. The function that Bill offers has been helpfull in the past.
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services--
Is it the key with a funny upper arrow marked Shift?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 16, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
Some of us like seeing the possibilities. The delete key is
Why would the H1-B cost the employer money?
Usually if you want to travel and get a visa you can pay a small fee at the
local embassy or consultate and that's it. Work visas may be different, I
don't know
Do U.S. employers pay H1-B visa employees' health benefits?
Just curious, I have never
Thanks. The problem was with my inattention. Having unzipped the zip
file, I failed to note that I had to unzip the jar file. Old age and
assuming that zipped files would be .ZIP files were my problem.
On a related note:
We recently installed an app from a vendor and I noticed that the
installer stored the indexes in the same tablespace as the data (even
though I had a separate tablespace just for indexes).
Should I take the time now to separate the two? My gut says yes. Sorry
if this is
what about ora_wms_autostart ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 4:24 AM
Hi All,
I have inherited a couple of databases on one of the servers here. The
server was taken down for hardware repairs
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Does
TX have special keyboard layout? I know that everything is big in
TX,
but I
didn't realize that was the case with the keyboards?
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original
Hello all,
We have setup a Microsoft Cluster Server (MSCS) cluster, with two nodes, using W2K,
and now are in the process of deploying Oracle 9i on it. For the purpose of high
availability (HA), we are deliberating on setting up either RAC or Oracle Fail Safe.
The confusion is over the fact
Tom,
I see that...and I wish only if things were different...
-Original Message-
Sent: Wednesday, July 16, 2003 4:55 PM
To: Multiple recipients of list ORACLE-L
Regis,
that's not discrimination as it is defined in the US. it is a business
decision not to spend money to hire someone to
Pete,
I follow your steps to enable audit_trail = db in init.ora located in
ORACLE_HOME/dbs
and restart my Oracle database on solaris. After my database is up, I do the exact
query in your paper and results as followings:
SQL
Nice try but it is set to TRUE already. :-(
N.
:--Original Message-
:-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
:-Behalf Of
:-AK
:-Sent: 16 July 2003 16:54
:-To: Multiple recipients of list ORACLE-L
:-Subject: Re: Oracle Instances not starting up via services
:-
:-
:-what
Title: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Especially if he always uses his own, real address.
I've put him in my "kill file" and
I
don't even have to pres "Delete" key or whatever it is they have in
TX.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL
what country is 'ie'? is that india?
its the same thing if Americans started flooding to your country on the Indian
equivalent of an H1-B. If its easier and less expensive to hire Indians, why hire the
Americans?
US immigration laws are FAR less stringent than Europes btw. I tried getting a
the problem is you're trying to use enterprise mangler
:P
-Original Message-
Sent: Wednesday, July 16, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Check:
drive:\ORACLE_HOME\sysman\log
review the oms.log file... and send the details...
HTH
JL
--- Ruth Gramolini [EMAIL
Hi Tom,
thanks for trying to help. Unfortunately I have no chance
because I've no account with write permissions. So it
seems impossible to put the data on the server through ftp.
Oh: and (of course!) no UTL_FILE_DIR defined in the init...ora.
Any other suggestions?
tia,
Guido
[EMAIL
What is your database version? 9i? If so you are probably using the SPFILE;
changing the init.ora file wouldn't help.
Shutdown trhe database and startup with the pfile option
startup pfile=init.ora
being in the same directory. You will be able to see the parameter being
set.
HTH.
Arup Nanda
List,
Oracle 8.1.7.4
OpenVMS 7.3-1
I have to drop the current PK constraint on a partitioned table and
recreate it with additional columns. The table and partitions are quite
large 3GIG + and I was wondering if anyone has found a method if
creation the PK constraint one partition at a time.
-Original Message-
you forgot to list the answers :)
Waleed
Having been a past sys admin, it was difficult to resist the temptation to
respond to the initial post. But, since at least one person appears to have
taken it as an indication of what kind of sys admin a candidate
If you use Outlook try SpamBayes. I recently implemented it and it works
exceptionally well
It uses derivatives of Bayesian algorithms and is extremely accurate
considering the nature of spam-crap. If you have an existing spam folder
it analyzes that and starts getting smart about what you
Title: RE: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
ie is probably Ireland ... IN is for India.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
I've been working with Materialized Views and fast refreshes lately. I
finally stopped to think about what is going on. Amazing what happens when I
stop to think. When I think of fast refreshes, I assume the materialized
view is refreshed from the MLOG$ tables associated with the base tables
noones hiring H1-Bs. there are so many DBAs out there who were H1-Bs in the past and
are now permanent residents or US citizens that they dont need to anymore.
there are typical multiple qualified applicants for every job these days. Many of
which are over-qualified.
From: Meng, Dennis
Yeah, wellummm...yeah, okay - that was dumb of me. Here they are:
1) What is an inode?
Answer: An inode is an on-disk data structure that contains information
about a file. Useful things it includes are size, modification time,
and number of links that point to it (among other things)
Boivin, Patrice J wrote:
Why would the H1-B cost the employer money?
Usually if you want to travel and get a visa you can pay a small fee at the
local embassy or consultate and that's it. Work visas may be different, I
don't know
Do U.S. employers pay H1-B visa employees' health benefits?
Just
Hi!
RAC - One database, two (or more) instances servicing it concurrently. If
one node crashes, second one starts recovering, your uncommitted
transactions and session state variables (package variables) on failed
instance are lost.
FailSafe - One database, one instance servicing it at any time,
you have to spend money to hire someone with an H1-B visa, as you are
basically sponsoring them for citizenship. You have to prove that you
cannot find an American citizen who can fill that job etc etc.
--- Boivin, Patrice J [EMAIL PROTECTED] wrote:
Why would the H1-B cost the employer money?
Title: Message
Wow! Heady!!
It's mighty nice of you to include my name in this
illustrious list, Mladen; but I don't considermyself tobe in the
same league :)Better yet, count yourselfin there.
Talking about the business at hand - you are
absolutely right; one of the "myths" (of the
Does anyone here have the original Dilber comic page that introduced
the term damagment? I'd appreciate if someone sent it to me.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
Not true.. Rachel with due respect..
-Original Message-
Rachel Carmichael
Sent: Wednesday, July 16, 2003 12:15 PM
To: Multiple recipients of list ORACLE-L
you have to spend money to hire someone with an H1-B visa, as you are
basically sponsoring them for citizenship. You have to
Title: RE: are fast refreshes really fast?
vw_nso_1 is probably an inline view look for statements in the trace file ... something that has inline views ..
Thanks for this analysis ...
Raj
Rajendra dot
Martin,
I am wondering if the OMS is running at all...
oemctl status oms on UNIX or check the services applet if you are in
Windows.
Patrice.
-Original Message-
Sent: Wednesday, July 16, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
the problem is you're trying to use
Title: Message
If you have to work on the cheap, you can put the
backups to tape and then copy them to tape using the OS backup software.
It isn't elegant, but it works!
Ruth
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent:
Well, the purpose of the original post was to list a set of questions
that, while admittedly academic in that they involve facts, cross 1) a
broad cross-section of what a sysadmin might be asked to do and 2) range
from easy to difficult.
The point is not to know the answer to every question,
I'll second what Ruth says about backup to disk then use the OS tape
routine to archive off of the diaks. I would keep at least 2 disk
backups available on disk. It is faster to perform a restore from a disk
based backup than from a sequential tape.
Restore on datafile from RMAN - 20 min. mount
Sounds rigid as a system.
Thanks for the answer Glenn.
Patrice.
-Original Message-
Sent: Wednesday, July 16, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
needed..)
Boivin, Patrice J wrote:
Why would the H1-B cost the employer money?
Usually if you want to travel and get a
Title: Message
why not backup to disk and then transfer to tape
.
-ak
- Original Message -
From:
Arup Nanda
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003 10:24
AM
Subject: Re: RMAN SQL
Backtrack
Wow! Heady!!
It's mighty
Like most laws there is always a different way to look at it
http://www.h1bvisalaw.com/
From: Anjan Thakuria [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience
needed..)
Guido,
Where are getting the data from - other database tables? Because, you could
build a PL/SQL block that contains PL/SQL variables that can hold up to 32k
of data. You could build the string in the variable and insert it into the
LONG column.
Something like:
declare
str_var
Based on Cary's paper regarding when to use an index, would there not be value
in having index tablespaces with a smaller block size vs tables using a larger
block size?
American Express made the following
annotations on 07/16/2003 10:11:40 AM
Title: Message
Hi All
At first I thought it is easy to find those tables to use
sequences but I failed. dba_sequence don't give too
much info. Is there any idea?
Thanks in advance
Mitchell
Nope, but this one's pretty good:
http://www.ftlcomm.com/ensign/img/DILBERT.gif
And there's some here, too...
http://www.cps.unizar.es/~spd/dilbert/
Or, try and find it at http://www.dilbert.com
Exactly what you didn't ask for. I could be a s/w developer! :)
Rich
Rich Jesse
no table uses a sequence. And there is no reason (other than sanity
checks) to have one sequence per table.
SQL code will use the sequence, usually to retrieve a value from the
sequence to then insert into or update a column in a table.
--- Mitchell [EMAIL PROTECTED] wrote:
Hi All
At
1 - 100 of 152 matches
Mail list logo