Hi
In case of Temporary Tablespace the Initital segemnt and next segment should
be
equal to the sort_area_size parameter.
bye
G.Subrahmanyam
-Original Message-
Sent: Thursday, August 16, 2001 8:28 PM
To: Multiple recipients of list ORACLE-L
Hello all,
I have a strage error.
'ORA-01
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
>> > Which view is required to check if any constraint has beed
>> > droped? means which Data dictionary table maintain
>> > constraint drop record?
>>
>>DBA_CONSTRAINTS
>>
>>Here is where you can find out about it and its friends.
>>
>>http://otn.ora
Hi,
I tried to view the TAR posted by you, But it said that I don't have sufficient
privileges to view the TAR.
Can u pl send me a copy of the TAR 1766421.999.
TIA
venkat
--
On Thu, 16 Aug 2001 05:10:58
Farnsworth, Dave wrote:
>I did this from svrmgrl. The database was shutdawn at the time
hi
DBA_CONSTRAINTS describes all constraint definitions in the database not
maintain droped constraint.
>From: Galen Boyer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Which view maintain droped constraint record?
hi
DBA_CONSTRAINTS describes all constraint definitions in the database not
maintain droped constraint.
>From: Galen Boyer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Which view maintain droped constraint record?
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> when I use svrmgrl to shutdown the instance and then try to
> start it up, it complains because the init file does not exist
> in %ORACLE_HOME%\pfile
use the "-pfile c:\mine\initMINE.ora" option when starting up
using svrmgrl.
> BUT the oradim DID
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> I do not remember how to define a procedure in a package
> definition so that it is executed every time the package is
> called.
I haven't created packages, but I thought you didn't call a
package. I thought you called a "method" of a package.
Babette,
I'm not sure if I have read this anywhere but I think that the registry
entry (as created by oradim) might be used when the service is started.
However, when using startup the Oracle executable looks in
%oracle_home%\database for the file initMINE.ora.
What I do is create a file called
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> 'ORA-01658: unable to create INITIAL extent for segment in
> tablespace TEMP'.
This is saying that Oracle is trying to use the TEMP tablespace
for some, temporary work, but it can't gain control of anymore
space.
[...]
> ORDER BY executions desc
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> But how does sqlnet comes into picture when we use OAS ? Also
> how does nls language in dad affect the application ?
Hm... Not sure. I guess there is no need for sqlnet if coming
through OAS? Hm... I guess my experience isn't really able to
hel
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
As everyone in this thread seems so
knowledgeable
about NT, I would like to digress and ask a related
question.
When I use oradim to create a service,
oradim -new -sid MINE -pfile c:\mine\initMINE.ora
The service is creat
Mercury is a component of thimerosal which was used to preserve vaccines. The
vaccines being manufactured today in the U.S. do not have thimerosal except for DTAP.
It seemed someone noticed we were injecting our children with more Mercury then the
EPA allows; thus the move to get the Mercury
well it looks like some good ones on the DBA track, heavily Oracle employees
though.
But there are some I'm definitely going to want to see.
>From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>S
Ahh but it does not have to sit there just waiting !!!
We had a DEC TruCluster, with the ASE failover software
(available software everywhere). This was NOT OPS
We still used our failover box but for less powerful
and less critical app. We decided that during failover,
we could tolerate sligh
ooh ooh, if I don't correct the quiz you write for Amazon this year, can I
get a ticket?
hey -- did they accept your abstract?
>From: Jeremiah Wilton <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Open World Enter
No, Not quite right.
Oracle WILL spawn a process if you are using
dedicate server processes. It will ONLY NOT
spawn the process if you are using MTS
(well technically it could, if it needed an
additional server process and
you were not yet at the max_servers value
but I digress..
not a clue as yet... they tend not to say anything about it. Last year it
was a performance by Lenny Kravitz
>From: "Smith, Ron L." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Open World Entertainment
>Date: Thu, 16 Au
I'm sure there are (but I'm betting that they are making it very difficult
to prove it)
>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT - Vaccines
>Date: Thu, 16 Aug 2001 14:09:05 -0800
>
>I bet
truncate resets the highwater mark delete does not, at least not until
you have done the count... at that point the highwater mark is reset
>From: Walter K <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Delete follow
Hi Again:
Boy...it's been a while since I did this kind of PL/SQL -
packages! I do not remember how to define a procedure in a
package definition so that it is executed every time the package
is called. Can someone point me to the doco for this? Or give me
a hint?
Thanx,
Mike
---
=
Hello all,
I have a strage error.
'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The
clients TEMP tablespace is 200M. The sql is:-
SELECT a.username, length(sql_text),
substr(sql_text,1,100) as "SQL TEXT",
substr(sql_text,101,250) as "Second TEXT",
substr(sql_t
Title: RE: OT - Vaccines
The NY laws allow for religious exemption from vaccinations in the school system: www.health.state.ny.us/nysdoh/immun/guide/immguid.pdf, page 16, "NYS Requirements for School and Post-Secondary Institution Attendance".
While the state school representatives may thin
Hi,
On NT / W2K to get a listener service I have found that you need 2 things:
1 - a (valid) listener.ora file (may be optional but certainly needed if you
want a correctly functioning listener)
2 - from a CMD prompt issue the "lsnrctl start" command and this will create
the service for the liste
Hi Jonathan,
Can you tell us a little bit more about delayed block
cleanouts .. if you can
Thx
Deepak
--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
> Apart from the comments other posters
> have made about truncate and the HWM,
> bear in mind that a scan after deleting 100,000
> rows would prob
Hi All:
We just upgraded our primary database from 8.0.5 to 8.1.7. I've
heard in 8i that packages and procedures can now be created which
can be executed as a user other than the one who owns the
procedure. I haven't messed with this capability yet, but I have
a question...
If I create a pack
Apart from the comments other posters
have made about truncate and the HWM,
bear in mind that a scan after deleting 100,000
rows would probably be doing a lot of
delayed block cleanout - resulting in plenty
of redo log, and possibly a lot of dbwr activity.
Jonathan Lewis
Seminars on getting the
Gimme a microphone, Ross' cleaned speedo, a feather boa, and 5-6 long
island iced teas...
--Hannibal Jr.
"Smith, Ron L." wrote:
>
> Does anyone know what the Wednesday night entertainment will be at Oracle
> Open World this year?
_
Do Yo
right...a kid near dirty water...poor hygiene...poor nutrition...
well, that kid might benefit from the vaccine for a malaria or what
have you that runs rampant in Mexico.
Now, in NYC, when was the last case of malaria?
And, if you saw it, it would likely be *far* less virulent.
(Read "Evo
On Thu, 16 Aug 2001, Smith, Ron L. wrote:
> Does anyone know what the Wednesday night entertainment will be at Oracle
> Open World this year?
Me. I'll be playing "Waltzing Matilda" on my accordion in the
Marriott sports bar. I hear there's already a thriving black market
for tickets.
--
Jeremi
Does anyone know what the Wednesday night entertainment will be at Oracle
Open World this year?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cal
lol..
I just get more interested in doing my own research
and forming my own beliefs the older i get.
Worked for me in DBA trenches...it's working for me
in life.
but.."doctor".naw...
lol
-Original Message-
Sent: Thursday, August 16, 2001 6:16 PM
To: Multiple recipi
Hey all,
One other slightly puzzling, erm, puzzle. The default column format seems
to have changed between 8.0.6 and 8.1.7 in SQL*Plus, but I can't seem to
figure out what it is or find any mention of it in any Oracle doc. We
aren't using any "login.sql" files.
It doesn't really bug me because
HACMP on AIX works the same way. It is more complex like I said to setup
and run. But the failover abilities are Great. But it was expensive. Lots
of dual hardware that just sat there waiting for a failover.
-Original Message-
Sent: Thursday, August 16, 2001 5:04 PM
To: Multiple recip
Yeah Dr. Ross... you get'em:)
KK
-Original Message-
Sent: Thursday, August 16, 2001 5:49 PM
To: Multiple recipients of list ORACLE-L
"...Children who have evidence of immunity as demonstrated by laboratory
confirmation of immunity or a reliable medical history of disease are exempt
from
But how does sqlnet comes into picture when we use OAS ? Also how does nls
language in dad affect the application ?
BigP
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 12:19 PM
> On Thu, 16 Aug 2001, [EMAIL PROTECTED
HWM, oracle will search up to the high water mark when doing a count, like
you proposed, so if you're gonna delete all of the rows anyways, save time(now
and later) by doing the truncate.
joe
>>> [EMAIL PROTECTED] 08/16/01 05:32PM
>>>I have a user that deleted all of the rows in a table(i.e
That's nothing, I've got 3 486's in my garage.
Stephen
If you have any questions, please feel free to call me or drop me a
note.
Stephen Andert480-445-2506>>> [EMAIL PROTECTED]
08/16/01 01:06PM >>>
i got a 75Mhz pentium sitting in my desk drawer :)
joe
>>> [EMAIL PROTECTED] 08/16/
Same here. Besides, this close to the border, I get to see the results
of no vaccinations with regularity. I'll give my kids the shots.
Scott Shafer
San Antonio, TX
Rachel Carmichael wrote:
>
> yes there are exceptions and you don't HAVE to give your child the vaccine.
>
> on the other hand
While stress testing a batch report created using a Java Servlet against
8.1.5 on Solaris 2.6,
initially a large report was taking 1 hour and 20 minutes. After performing
a trace on the application,
I discovered that no database activity was occurring at all, which was also
evident by the cpu be
I bet you a scotch there are religious exemptions in NYC, too, RC.
:)
-Original Message-
Sent: Thursday, August 16, 2001 5:48 PM
To: Multiple recipients of list ORACLE-L
yes there are exceptions and you don't HAVE to give your child the vaccine.
on the other hand, NYC will not allow
Truncate basically resets the table's highwater mark to 0. Deletes don't
do that. A 'select count(*)' does a full table scan, which much touch all
the blocks up to the HWM, and that's what's taking the time. The REUSE
STORAGE option keeps the extents allocated to the table, but the HWM is
stil
Yes,
It has been known if you delete all records, use a truncate and not delete.
Otherwise it will still behave like it is full as it has to touch all the
extents.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have th
MC/Serviceguard in HP. This offers availability for the database as well as
application. Standby is a good alternative. Risk with Standby is fail-over is
manual and user intervention required, also keeping the Standby in Sync is a
problem. MC/Serviceguard allows you to have multiple boxes in the c
Title: Openworld Abstracts
It looks like the abstracts for Openworld 2001 are
now online, for those of you who might be
attending (not me, I have enough trouble convincing
management to send me one conference).
http://www.oracle.com/openworld/us/conference
Matt Adams - GE Applianc
Tom,
Thank you for your answer - it has solved my problem.
At 05:11 2001.08.16. -0800, you wrote:
>Zsolt,
>
>The correct call for the function if the function exists within the package
>would be:
>
> Insert into A
> ( Select Col1 ,PackageName.MyFunction(Col1)
> from B );
>
>Tom
"...Children who have evidence of immunity as demonstrated by laboratory
confirmation of immunity or a reliable medical history of disease are exempt
from such requirement"
|| This says, basically, that is it really ambiguous.lol
"After July 1, 2001, all children who have not ye
Hi Walter,
The extents you refer to in ur thread is the allocated
space. Oracle by default scans upto the high
watermark. The reason truncate is fast is cause it
resets the high watermark so oracle did not scan
anything for u when it returned 0 rows .. however in
case of delete, it still scanned
yes there are exceptions and you don't HAVE to give your child the vaccine.
on the other hand, NYC will not allow you to register your child for school
if you cannot show proof of vaccination. And if you don't send your child to
either public school, private school or prove that you are homesch
at a command prompt, type
C:\> lsnrctl start
error 1060 - will create a service.
This assumes that you have a listener.ora in the folder
%ORACLE_HOME%\Network\Admin\
and that the listener name is "LISTENER".
This is a good thing to add to a db_create.bat that the dbca does not
include, as it
I have a user that deleted all of the rows in a table
(i.e. 100,000), waited for it to complete, and then
ran a SELECT COUNT(1) FROM . It took a few
minutes for '0 rows' to be returned to the prompt. The
table has ~60 extents (128k ea.). Granted, the number
of extents is excessive but it's a devel
ROFL
-Original Message-From: Kathy Duret
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 4:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Comment on 'Practical Oracle 8i'
Bet you say that to all the girls
;)
Kathy
-Original M
If you are going to drop all tables, the best
bet is to use a PL/SQL loop which does:
for r1 in (select table_name, tablespace_name from user_tables where
...)
dbms_utility.exec_ddl_statement('drop table ' || r1.table_name);
dbms_utility.exec_ddl_statement('alter tablespace ' ||
r1.table
yikes.the immune system is fabulously complexsecond in complexity
only to the brain itself...and it is still very very much in development
at early ages...this is why kids -- all kids -- get more colds, etc than
us older folks...the system is literally "learning" for the first few years
or
Hi,
I am running the follwoing query and it is running very slow:
select * from v_mci_com_leader_summary where accountid=1011 and
intervalid=1490
EXPLAIN PLAN looks like:
ID Query Plan
-- ---
0 SELECT STATEMENTC
Export and Import
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Schoen Volker
Okay,
I think we can both eat some words. It is legislated, but there are religious or
physical endangerment clauses (Title 32, Chapter 1, Section 46):
http://leg1.state.va.us/cgi-bin/legp504.exe?000+cod+32.1-46
http://www.elkokidsdoc.com/Pages/WellChild/W_Ex_ChickPox.html
This second site
Title: Message
I have 2 p133 pcs at home (one running win98
for kids games, the other running linux mandrake).
can you believe buy.com was selling 512MB
PC133 SDRAM for <$50 yesterday?! (it was their dealoftheday special and not
the cheap stuff either). wow! we've come along way since I
Thanks for the input. I am going to have a database but I did not want the
starter database I want to
create my own. A tnslistener service should get created regardless of
whether I opted for the starter
database or not.
Thanks
Rick
-Original Message-
Sent: Thursday, August 16, 2001 4:13
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> Which view is required to check if any constraint has beed
> droped? means which Data dictionary table maintain constraint
> drop record?
DBA_CONSTRAINTS
Here is where you can find out about it and its friends.
http://otn.oracle.com/docs/products
Bet you say that to all the girls
;)
Kathy
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 1:06
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Comment on 'Practical Oracle 8i'
i got a 75Mhz pentium sitting in my desk
ORACLE_SID is not listed in my Registry anywhere, but ORACLE_HOME is (816 on
NT).
As I said, ORACLE_SID does not get created automatically by any piece of
Oracle software that I know of. You may create it by hand in environmental
settings in Control Panel|System|Advanced.
ORADIM can create servi
Title: RE: Comment on 'Practical Oracle 8i'
I agree. I recently upgraded my Eye Doctor's
office server from a 386-25
with 4M of RAM and 300M of disk to an NT server.
I think she liked the
older system better, to no surprise. I ran 5
terminals from that machine
with the Pick O/S and it work
At 12:21 PM 8/16/01 -0800, you wrote:
>On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
>
> >> Does any one know of tools available for running Unix on NT
> >> besides MKS Unix. Preferably a shareware tool.
> > As far as tools for bash on NT/W2K - I like cygwin -
> > http://sources.redhat.com/cygwin
I still have my 486 / 33MHz PC with 220 MB SCSI drive for a few odd things
:)
- Kirti
> -Original Message-
> From: JOE TESTA [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 3:06 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Comment on 'Practical Oracle
Give the kid some baby motrin or baby tylenol prior to the shot. Works
wonders. I've got two who just got a round of vaccinations this week.
Scott Shafer
San Antonio, TX
Kathy Duret wrote:
>
> Thanks for the link. As a new parent of a 4 month old, I am always looking for
>things to read a
Anyone using this consistently, i've just started to use it to compare prod
<-> dev and its pretty kewl.
joe
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
>> Does any one know of tools available for running Unix on NT
>> besides MKS Unix. Preferably a shareware tool.
> As far as tools for bash on NT/W2K - I like cygwin -
> http://sources.redhat.com/cygwin
I second this choice. Unix and Windows togeth
Hey - Linux rocks on a 486DX2-66.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Gogala,
Thank you all who took the time to answer the above question.
Now, I am going to allow columns types as floating.
I copied all the replies to this question so that somebody could benefit
from this. Once again thanks to Dick Goulet, Kevin Lange, David A. Barbour,
Galen Boyer.
Replies to the abo
Hi DBAs,
I asking on behalf of another user so bear with me. They are running Oracle
7.3.x and they want to restrict certain ports for sql*net traffic.
Currently when a client makes a sql*net connect it spawns another process
another port for sql*net traffic. Is there some oracle configuration
Thanks for the link. As a new parent of a 4 month old, I am always looking for
things to read about newborns.
Some Health centers (Long Beach, CA) are now requiring children to have TB shots
before they can be entered into day care. My pediatrician refuses (thankfully) to do
it before 6 mon
Title: RE: Comment on 'Practical Oracle 8i'
What wrong with a 100MHz Pentium? I still
do a lot of LaTex work (and other stuff)
on a 386-25. As long as the machine serves your
needs and works, use it.
> >
> > For example. 100MHz Pentium is no where near 1/15 the speed
> > of the 1.5GHz
>
Title: Message
I just sold 5 166Mhz pentiums chips and heat
sinks for $18 at show 2 weeks ago :)
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence Oracle DBA Phone: (978) 322
I'll give this a whack though I suspect that there are people who could do
a better job.
The Windows registry is the conceptual equivalent of the UNIX environmental
variables.
ORACLE_SID, ORACLE_HOME, etc can be found under
HK_LOCAL_MACHINE\Software\Oracle.
You can change these using REGEDIT; h
Is there a method or utility to translate disk names
reported by sar from the sdXX format to the cXtXdX
format? I'm on a Sun platform.
Many thanks in advance.
-w
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messe
It's probably NOT "state law", but "mandated" by
the State Health Office, an unelected, non-academic
bureau w/in State Govt.
Of course, if you can provide the law (code and section)
from the Commonwealth Law that shows this, I'll eat
my words (virtually, of course!)
:-)
something like 40 stat
Hi
Which view is required to check if any constraint has beed droped? means
which Data dictionary table maintain constraint drop record?
Thanks in advance.
-Dinesh
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/
Title: RE: OT - Vaccines
Remember, there is always a medical exception to any vaccine.
If someone has said, 'It's required', remember the US is not a communist state. They cannot hold you down and give you a vaccine, nor can they force you to have your children vaccinated. They will also
i got a 75Mhz pentium sitting in my desk drawer :)
joe
>>> [EMAIL PROTECTED] 08/16/01 03:45PM
-Original Message-> From:
Christopher Spence [mailto:[EMAIL PROTECTED]]>
Sent: Thursday, August 16, 2001 1:52 PM> To: Multiple recipients of list
ORACLE-L> Subject: RE: Comment on 'Pr
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Rick,
I
think Networking services means TNSNAMES/SQLNET.ORA stuff (like a client
install).
You
could do a custom install (I think) and just install TNS Listener, and not the
starter database.
Tom Mercadante Oracle Certified
If you don't like the messages, killfile the sender.
Scott Shafer
San Antonio, TX
"Somebody needs to killfile somebody. I don't care who killfiles
whom, but someone needs to do it." - Bill Roberts
Ron Rogers wrote:
>
> I think that OraStaff is doing us a service by providing us as much infor
Title: Tuning an Oracle/Unix file system - Sun/OS 5.6 Oracle v8.1.7.2
Anybody play with tuning a UFS containing only Oracle datafiles?
I'm interested particularly in the "tunefs -m ..." and the "mount forcedirectio ..." command options, but if you have other suggestions please note them.
T
I was in a similiar situation. I was installing Oracle onto the D drive.
But installation software created C:\Program Files\Oracle on the C drive to
contain all the installation info/logs and current software installed list.
So I had to delete the Oracle directory on the D drive and C:\Program
Fi
Is the Schedule Service shown as Running in the services applet in control
panel?
Just a thought.
If yes, I agree with Bunyamin, what syntax are you using?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services
> -Original Message-
> From: Christopher Spence [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 16, 2001 1:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Comment on 'Practical Oracle 8i'
>
> For example. 100MHz Pentium is no where near 1/15 the speed
> of the 1.5G
Hi Denmark,
I really haven't been posting to the list at all lately. This one I can't
pass up.
Scott and myself here at PSS (now Encoda Systems) have prepared a set of
batch jobs/scripts for configuring arch/exp/hot/cold/scheduling backups for
NT/W2K (dictionary driven). They include the use of
As having a few chicken pox scars (luckily in areas that are not seen) I understand
this some.
The vaccine also prevents Shingles later in life. Shingles normally happens in older
people where your immune system is stressed/suppressed. It is quite painful. Even
though I am not very old, I
Delete the directory structure under C:\Program Files\Oracle, as well. That's where
Oracle keeps the inventory information (among other things).
Jon Walthour
>
> From: Christopher Spence <[EMAIL PROTECTED]>
> Date: 2001/08/16 Thu PM 01:28:15 EDT
> To: Multiple recipients of list ORACLE-L <[EMAI
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Ok, I
am getting a little closer to figuring out what is going on. I did mis-state
the type of install I did first. It was minimal installation without the starter
database. This did NOT create a listener service. However it clear
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> I ran into this as well. I figured I didn't need a listener on
> my w2k box because everything was going to be local.
>
> However I couldn't connect via sqlplus gui without a listener
> (no listener error - maybe because I am specifying the sid).
Whenever you say $sqlplus ,
Oracle spawns a dedicated server process to connect to database using Bequeath protocol (in this case) which bypasses the listener ,I guess.
When you use the connect string(sqlplus@), Oracle connects thru the listener process/port(whatever), so probably, it does not requ
Yup. VM/CMS on IBM mainframes would do the same.
Scott Canaan
<[EMAIL PROTECTED]To:
I have experienced the same problem on NT 4 next week.
When you do it from scheduler (not at command) , it is ok .
The problem is AT command. not your script .
Test what I say and see that I am right.
bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote:
> Hi there , We have UTF-8 database. We are using OAS with UTF-8
> setting and java at front end connects to OAS socket to send
> data to be inserted into oracle Is it required to convert data
> send by Java to be converted to UTF8 ? OAS (OAS
> NLS_L
Don't we all ...
-Original Message-
Sent: Thursday, August 16, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L
)
>
>Rachel is 100% right (do we ever expect differently ??)
>
you shouldn't... I make mistakes all the time
__
Title: RE: Speed up Truncate tables - rebuild index
Yes,
the point of my message was simply a quick reminder to rebuild the indexes on a
table that has been ALTER TABLE...MOVE moved.
I
havent tested this, but I believe Lisa is right, in part, if the table is
truncated, then moved, then why
Comments in line
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 16 August 2001 18:38
|Jay,
|
I would love to take a nice train trip for 3 or 4 days, up to canada,
or across the desert and rocky mountains, and do some reading on the
train. take a laptop to run test database?
>
> --
>
> From: Hallas John <[EMAIL PROTECTED]>
> Date: Tue, 14 Aug 2001 14:54:0
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Lisa,
C:\> set
ORACLE_SID=SID_NAME
Then...
C:\> set ORACLE_SID
ORACLE_SID=SID_NAME
Ed
Haskins
Oracle
DBA
Verizon Wireless
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 20
Set the tablespace to some reasonable INITIAL and NEXT that accommodates
all the objects with less than 100 extents per object. Let all the objects
in the tablespace inherit their storage parameters from the tablespace.
You will never have any fragmentation of the tablespace and will not need
to
1 - 100 of 233 matches
Mail list logo