-- Hallas John <[EMAIL PROTECTED]>
> Top Man Rich.
>
> Works well and a satisfied user for the first time in my career!!
> Nice bit of coding, especially the line formatting bit
>
> DCL is a nice language to work in I always found. Once you know what
> lexicals are available it is amazing what
There is a good article in Select Magazine (IOUG) Q4 2001 on Oracle Apps
patching. Worth checking out.
Gerardo
-Original Message-
Sent: Tuesday, November 20, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L
After applying the c.drv portion of the patch,
I'm attempting to apply
If I understand you correctly, you are shutting down a
listener on your NT box, and then, from your NT box, you are
connecting to a remote database using SQL*Plus. Am I
understanding you correctly?
You shouldn't need to have a listener running on your NT box
to connect to a remote database, so th
Wednesday, November 21, 2001, 10:56:45 AM, you wrote:
DK> Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
DK> 85-86 in particular.
Yeah, but I don't have any experience with the GIOP
presentation. Like Srini pointed out earlier, it allows the
listener to handle the proto
Yes, Oracle actually calls it an upgrade.
I think the point everyone wanted to make though was
it's not a good idea to just start your database
with the 8.1 binaries.
Jared
On Wednesday 21 November 2001 16:40, Jeremiah Wilton wrote:
> Correct me if I am wrong, but you don't migrate from 8.0 to
Ed:
If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a
potential difficulty you need to know about.
If you're not aware of the dictionary corruption problem, be sure you read
the metalink alert (96117.1). This has something to do with block checking
enabled in 8.1.6 Essen
Try xwin32 from starnet
--
On Wed, 21 Nov 2001 10:15:25
Jared Still wrote:
>
>Yes, Xfree86.
>
>Just do a search on google. I use it to run Oracle
>installs, so it works well enough.
>
>Jared
>
>On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
>> Hi all!
>>
>> Is there any f
Correct me if I am wrong, but you don't migrate from 8.0 to 8.1. You
just start up on the new binaries and run u080005.sql or something.
The migration utility is for 7.x to 8.x. Read the manual.
Re-creating the database, then exporting and importing will take much
longer than just running a coup
Thanks all.
Ed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
At 02:10 PM 11/21/2001 -0800, you wrote:
>not free, but ipswitch's ftp is nice and cheap ~$400.
>very easy to admin.
>
>http://www.ipswitch.com/
www.cuteftp.com only $35
>gene
>
> >>> [EMAIL PROTECTED] 11/21/01 16:55 PM >>>
>Does anyone know a site where one can get a FREE gui ftp tool?
>
>Th
Ed:
If you track down the 8i migration manual, here's a comparison chart that
shows the benefits of export/import versus migration (using the u
scripts).
It depends on your database configuration, but yes, the main benefit in
using migration is speed. If your database is relatively small,
If you are using TOAD, there is one in there ...
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 clod can have f
Yes it will save time as well ..all the upgrade does
is mess the datafile headers so they are 816 format
also the upgrade script will simply re-initialze the
catalog to 816 is also quite fast and will complete in
a few minutes ..
if you have a 1TB db for e.g. upgrade would definitely
be a far m
When I did this, the migration assistant was much quicker than export/import.
Kent
>Yes, I agree 100%, but people here are concerned that upgrading will "break"
>the database, and we have to QUICKLY move everything over to 8.1.6. (Long
>story). What I was really after in my original question
not free, but ipswitch's ftp is nice and cheap ~$400.
very easy to admin.
http://www.ipswitch.com/
gene
>>> [EMAIL PROTECTED] 11/21/01 16:55 PM >>>
Does anyone know a site where one can get a FREE gui ftp tool?
Thanks,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
Hi all,
I have two 9i instances, one of them consistently produces following error,
whereas other doesn't.
SQLException:61000java.sql.SQLException: ORA-04031: unable to allocate
1028736 bytes of shared memory ("shared pool","unknown object","hash-join
subh","kllcqc:kllcqslt") ORA-06512: at "ESPN
Terry,
WS_FTP is a freeware
Check www.tucows.com
Regards
Suhen
Does anyone know a site where one can get a FREE gui ftp tool?
Thanks,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, T
Ed,
If your databases are more than a couple of gig,
upgrading is faster.
If over 10 gig, don't even think about importing it.
Jared
On Wednesday 21 November 2001 13:15, Ed wrote:
> Yes, I agree 100%, but people here are concerned that upgrading will
> "break" the database, and we have to Q
Terry, check out www.vandyke.com ..
Deepak
PS: more so check out google.com .. ;)
--- "Ball, Terry" <[EMAIL PROTECTED]> wrote:
> Does anyone know a site where one can get a FREE gui
> ftp tool?
>
> Thanks,
> Terry
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX: 816-300-1801
>
At 01:10 PM 11/21/2001 -0800, you wrote:
>Does anyone know a site where one can get a FREE gui ftp tool?
Sorry it is http://www.jgaa.com.
How about warftp i think that it is www.warftp.com.
>Thanks,
>Terry
>
>Terry Ball, DBA
>Birch Telecom
>Work: 816-300-1335
>FAX: 816-300-1801
>
>--
>Ple
At 01:10 PM 11/21/2001 -0800, you wrote:
>Does anyone know a site where one can get a FREE gui ftp tool?
How about warftp i think that it is www.warftp.com.
>Thanks,
>Terry
>
>Terry Ball, DBA
>Birch Telecom
>Work: 816-300-1335
>FAX: 816-300-1801
>
>--
>Please see the official ORACLE-L FAQ: h
Yes, I agree 100%, but people here are concerned that upgrading will "break"
the database, and we have to QUICKLY move everything over to 8.1.6. (Long
story). What I was really after in my original question was: why is the
upgrade script a better solution than just recreating the tablespaces in
8
Does anyone know a site where one can get a FREE gui ftp tool?
Thanks,
Terry
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1801
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services-- (85
The only problem with this technique is that you won't reclaim the space in
the first tablespace that used to be used by the indexes (since the high
water marke will be set). If this isn't an issue (either lots of storage
space or the data is expected to grow enough to use this space) then I agre
For those of us struggling with 9iAS and Discoverer If you've been
using the note (131662.1) to manually install Discoverer 3i or 4i this
note has been pulled from Metalink. Apparently, if you're lucky the
manual install works. If you're not lucky you end up with a mess. All
Discoverer ins
At 10:15 AM 11/21/2001 -0800, you wrote:
>Yes, Xfree86.
www.cygwin.com
>Just do a search on google. I use it to run Oracle
>installs, so it works well enough.
>
>Jared
>
>On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
> > Hi all!
> >
> > Is there any free (important: free)
Title: RE: Problem Running DDL SQL Script
The larger question is, why are you creating tables as system?
-Original Message-
From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Problem R
Title: RE: Oracle and MQ
The VB
programs have data validation and standard error trapping for exceptions
returned by the MQ API calls. As for your question about
accessing external procs, MQ provides the API to make calls from C which
you can certainly use to code the external routines. An
I agree with you Kevin. This is a recipe for disaster.
While the db may run ok, I can only imagine the recovery nightmare that
*will* occur when something is eventually lost. And try calling Oracle
Support with *this* scenario - we will be reading about it under "stupid
upgrade tricks" somepla
Ed,
the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out
Deepak
--- Ed <[EMAIL PROTECTED]> wrote:
> A DBA here is trying to upgrade several 8.0.5
> databases to
Try sumthin' like:
EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp
exp / file=${FILENAME} ...
Do a 'man date' to see the different formatting options.
HTH,
Scott Shafer
San Antonio, TX
Jared Still wrote:
>
> -- Forwarded Message --
> Date: Wed, 21 Nov 2001 15:34
In many a case on the list we don't have the information to fill in to all sql
statements, like in this case the name of the tablespace. The common way to
indicate that is to frame the variable with a set or '<>' brackets. What you
need to do is replace the '' with the rean tablespace name, in
y
Yes, Xfree86.
Just do a search on google. I use it to run Oracle
installs, so it works well enough.
Jared
On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
> Hi all!
>
> Is there any free (important: free) X client software for NT?
>
> Regards,
> Vladimir Barac
-
"For all this means to me I might as well post it on the OT list."
LOL!!! yeait makes sense, at least in terms of all of
the acronyms being internally self-consistent.
Yours in Inflating Acronyms,
Ross
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/21/2001
Matt,
I installed the whole HTML/PDF set of manuals that comes with the 11i CD Set
onto my laptop. This then provides an indexed version of the manuals in PDF
from a HTML page. FWIW, I am also one of those who recently (just about >1
year) 'migrated' from a normal DBA to doing Apps stuff, and th
Hi !
May be this will help you (I hope).
This solution is for Windows (X) but
with some work it will do also in UNIX.
A procedure called BackupOSC is created by
the DBA in his schema.
A job is created with at command, invoking
the batch command file backup_OSC.cmd wich
in turn calls SQLPLU
You need to move the database to 8.1.6 (upgrade, run catalog et al).
Compatible will just keep certain feature turned off.
Henry
-Original Message-
Sent: Wednesday, November 21, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
That's exactly what I was saying I think. ie. To qui
I have next problem , syntax its ok.
SQL> Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace including content;
ORACLE instance started.
Total System Global Area 178213024 bytes
Fixed Size73888 bytes
Variab
--THANKSGIVING_LOAD.SQL
--T. Day, SAI, 21-NOV-01
--Run on WORLD.UNIVERSE using schema with DEITY role
declare
cursor c_thanksgiving is
select
PERSON_ID /* NOT SSN -- generated by sequence generator
(Jared) */
,RELATION
,CONDITION
from YOUR.LIFE@WORLD where RELATION
That's precisely what I do..
I have *_user and _developer role with just what they need.
No more. No less. However, certain developers will have direct access to
tables for coding stored procedures, but those are very limited in number.
Standard ksh script to add these users to the database, ac
Hi,
There is a free monitoring/alerting system with escalation that is commonly
used and is called Netsaint.
We are to try this out.
Thanks to those who responded.
Kumanan
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: 21 November 2001 15:52
> To: K
Have you got all your instances defined in the oratab file?
If not, define the missing one and restart the agent and
see if that fixes your problem.
-Original Message-
Sent: Tuesday, November 20, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a problem with Enterprise
Title: close_cached_open_cursors "error"
Hello Guru's
I hope someone can shed light on this problem, more a nuisance really.
The below Alter Session statement has been appearing in the *alrt.log file.
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION
heck, I've occasionally logged in as system and forgotten to specify
the tablespace.
power is a dangerous thing
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Mark Leith wrote:
> >
> > Yeah but for a tightly controlled schema *owner* - what's the
> problem?
> > Wouldn't you *want* to hav
I have this script that will generate a DB with a number of create table and
create index statements. When I try to run it in SQL*Plus I get this error:
ORA-00959 tablespace SOS2_TBLSPC does not exist.
ORA-00942 table or view doesn't exist
Here is a sample of one of the create statements:
DR
"Malik, Fawzia" wrote:
>
> Hi,
>
> Can you tell me if its possible to write some sql to change some data.
> Basically I need to run a scritp to change data of column: id from 12345678
> to the last four digits. Is this possible to do in sql/plsql??
>
> Any advice/hints would be greatly apprecia
yeah that would work too :)
--- [EMAIL PROTECTED] wrote:
> Rachel,
>
> I create a role called 'developer' in each instance at create
> time. Make it
> look something like resource, but without the unlimited tablespace
> priv, and use
> it in place of resource. saves a step.
>
> Dick Goul
Fawzia,
You should be able to use mod(field,1) to get the remainder of the
number divided by 1, which should be the last four digits.
Cheers
Iain Nicoll
-Original Message-
Sent: Wednesday, November 21, 2001 4:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
Can you tell m
Marlene goes over it in the networking 101 book -- it's a new feature
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Anyone seen this fecality in their listener.ora? It's a new one on
> me,
> but then again, what with all the "newfangled" features in this here
> product, I am probably just lo
Or if id is number
update table
set column_name=TO_NUMBER(substr(TO_CHAR(column_name),-4,4))
JP
On Wed 21. November 2001 17:45, you wrote:
> Fawzia
>
> How about:
>
>
>
> update table
>set column_name=substr(column_name,-4,4)
>
>
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -
Fawzia
How about:
update table
set column_name=substr(column_name,-4,4)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, November 21, 2001 11:04 AM
To: Multiple recipients of list ORACLE-L
Hi,
Can you tell me if its possible to write some s
Title: parallize printing reports to different printers
You
need to give more information when asking a question like this .
1) What are you using for the
reports
2) Is this really a database issue ?? Is this some
report that is coming from an oracle database or something ?
Title: RE: SQL question
update set id = substr(id,-4);
eg:
[EMAIL PROTECTED]> select substr('48900322',-4) from dual;
SUBS
0322
1 row selected.
Nirmal.
-Original Message-
From: Malik, Fawzia [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 7:04 PM
To:
We are searching for an Oracle Financials DBA Team Leader for a client
located in downtown Chicago.
The individual will perform DBA and supervisory duties for Oracle Financials
Systems.
Only candidates who already live in the Greater Chicago area can be considered.
This is a full time staff po
I would not do that. Those migrate scripts change the catalog tables to
support the 8.1.6 engine and do other things. I would never consider
upgrading a system without doing that step.
-Original Message-
Sent: Wednesday, November 21, 2001 10:36 AM
To: Multiple recipients of list ORACL
Boston, MA, Financial services company is looking for an Oracle Database
Group Manager
who MUST be a senior ORACLE database professional. The selected candidate
will report
to the Manager of Enterprise Technologies/Global Operations.
*Candidates who are in the Greater Boston area only can be con
Opera is a browser that follows the W3C standards and is available on
multiple platforms, including MS Winders, Linux, Solaris, and Mac. Unlike
IE (say it like you've just jumped off a cliff), Opera can
render XHTML properly and according to standards. It's all on their
website.
I trialed it, I am not going to spend $$$ on a browser when there are free
alternatives out there, including IE.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, Nove
Title: parallize printing reports to different printers
Hi all,
A report producing multiple 1000 (say 5000) pages producing and we want to print it. However we don't want the
user to be idle until it completes. So we plan to reduce the printing time by distributing (say 1000 each) report pag
I think that COMPATIBLE must be associated with whole, big chunks of
functionality like
new features such as function indexes. I don't think that it works for
smaller revisions to
pre-existing functions.
For instance, we just did an upgrade to 8.1.7.2 and are having TEMP space
issues with
hash
-- Forwarded Message --
Date: Wed, 21 Nov 2001 15:34:27 +0100
I have created a job to export a user shema
How can I tell Oracle each time it make the export to use lets say
.dmp
I mean for example if today is 21.11.2001
the exported file whoud have name21112001.dmp or somethi
That's exactly what I was saying I think. ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script). You can run migration later if you need
new features of 8.1.6.
Reasonable statement?
Best,
Ed
-Original Me
Ross,
It's CORBA stuff. See note 69043.1 on Metalink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc
"Mohan, Ross" <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001 10:15:27 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT
huh?
Did you buy it, or just trial it?
there are no "ads" in the regular version, AFAIK
-Original Message-
Sent: Wednesday, November 21, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
The only thing I don't like about Opera is the ads.
Regards,
Patrice Boivin
Systems Analyst
Something to do with external procedure calls, Java support, GIOP support in
8.0.x versions ( < 8i)
Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
85-86 in particular.
Cheers!
- Kirti
> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sen
Hi,
Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??
Any advice/hints would be greatly appreciated
Rgds
Fawzia
**
Title: RE: Oracle and MQ
Tony -
Do you
have error handling built in to your VB program, or do you just load it into
Oracle and then cleanse/validate the data there?
Do you
think it would also be possible to access MQ via external stored
procedures?
-Original Message-From: Ap
Jaysus, note the date and time. It's a freaking miracle.
;-)
-Original Message-
Sent: Wednesday, November 21, 2001 10:54 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L
OOPS! sorry, your right
Reply Separator
Author: "Mohan; Ross" <[EM
Ross,
fecality? Is that the F in RTFM? Well, things are pretty slow here (who am I
kidding. They have been, no wait. It has been pretty slow here for months)
so I grabbed my Net8 book. Not that this makes a lot of sense, but this is
what it says.
PRESENTATIONIdentifies the presentation layer
Rachel,
I create a role called 'developer' in each instance at create time. Make it
look something like resource, but without the unlimited tablespace priv, and use
it in place of resource. saves a step.
Dick Goulet
Reply Separator
Author: Rachel Ca
Mark Leith wrote:
>
> Yeah but for a tightly controlled schema *owner* - what's the problem?
> Wouldn't you *want* to have unlimited tablespace for the schema owner -
> which the users *should not* have access to anyway?
>
> (no this is not rhetorical - I have no production experience)
>
> Than
OOPS! sorry, your right
Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date: 11/21/2001 7:40 AM
"cascade"? probably more abject ignorance on my part, but wasn't it
"including contents"?
-Original Message-
Sent: Wednesday, Novembe
standard create user script for a user who will own objects:
create user identifed by
default tablespace
temporary tablespace
quota unlimited on
/
grant connect, resource to
/
revoke unlimited tablespace from
/
I've gotten this drilled into my people's heads... and I check up
on it :
Never mind, this is an IIOP operability hook.
-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L
Anyone seen this fecality in their listener.ora? It's a new one on me,
but then again, what with all the "newfangled" features in thi
OEM does autodiscover based on what method of networking you
told it to used when you configured autodiscovery: Names Server,
tnsnames.ora, or directory server. We use tnsnames.ora and
OEM looks to see what the SID names are in tnsnames.ora for
sure. It may do this in conjunction with the o
Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new re
"cascade"? probably more abject ignorance on my part, but wasn't it
"including contents"?
-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L
Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter datab
YES, it is a standard browser...follows all the rules.
and so.
any special tweaks that IE has given you over Netscape or over the browser
standardare not supported..
Try it! My experience with it was very positive.
-Original Message-
Sent: Wednesday, November 21, 2001 1
It certainly does!!
I run IE6, Netscape 6 & Opera 5.12 on a Win2K box. Opera is pretty cool!
Though I sometimes have problems with things like DHTML in it.. Has anybody
else seen this problem?
Mark
-Original Message-
Gramolini
Sent: 21 November 2001 15:10
To: Multiple recipients of list
Patrice,
SqlPlus uses the Bequeath protocol to access local databases if the "@" is
omitted in the connect string. If the "@" is present (i.e. connect
scott/tiger@db) then it uses Net8. See Note 118381.1 on Metalink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc
"Boivin, Patrice J" <[EMAIL PROTECT
The only thing I don't like about Opera is the ads.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Jesse, Rich [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 10:40 AM
To: Multiple recipients of
That depends. And you are lucky( no production experience, you say)
If the production database has more than one 'production' schema owner, then
I would rather keep them restricted to certain tablespaces of their interest
(with unlimited quota). I have worked with many variations.
Currently work
Hi Kumanan,
We have a tool that I think will fit you requirements. It's called NORAD
Surveillance Module
(http://www.cool-tools.co.uk/Products/surveillance.html).
The key aspect of NORAD is to provide server based monitoring of the
instances, watching for issues such as space restrictions, blo
Anyone seen this fecality in their listener.ora? It's a new one on me,
but then again, what with all the "newfangled" features in this here
product, I am probably just losing track..
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
Does this run on NT?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 9:40 AM
> There's an easier fix:
>
> http://www.opera.com
>
> :)
>
> Rich Jesse System/Database Administrator
> [EMAI
Title: Blank
Henry,
I remember reading some reviews of it when
it came out and thinking I would like it. I presume it includes function based
indexes (indices?), more on partitioning etc.
I also recall the book being about £40 UK
whereas other comparable sized books such as Jonathan Lewis's
Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace cascade;
Dick Goulet
Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
Date: 11/21/2001 5:40 AM
Hel
Yeah but for a tightly controlled schema *owner* - what's the problem?
Wouldn't you *want* to have unlimited tablespace for the schema owner -
which the users *should not* have access to anyway?
(no this is not rhetorical - I have no production experience)
Thanks
Mark
-Original Message
I noticed that if I leave the TNS Listener service stopped on my NT
workstation, I can't access anything using the GUI tools.
But my script that runs command line can successfully login to the remote
databases to verify that they are accessible. It uses
c:\oracle\ora81\bin\sqlplus.exe.
Do the c
LOL!
*yes* !!
-Original Message-
Sent: Wednesday, November 21, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L
There's an easier fix:
http://www.opera.com
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inter
I have no problem accessing metalink in NYC. Could this be a local DNS, network
issues to certain locations?
>>> [EMAIL PROTECTED] 11/21/01 08:35AM >>>
This is strange..I could not log into Metalink using the
link metalink.oracle.com.
But I could log in using the link oracle.com/support/me
Sepi,
Just a guess - are all three instances listed in your /etc/oratab file? I'm
pretty sure OEM looks at that to determine what instances the Agent should
monitor. I could be wrong on this though - it's been a while since I've
looked at OEM.
JIm
_
When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6. What is the point of the "compatible" parameter then if you have
to run the conversion script on the database? Thanks for answering.
Best,
Ed
On Wed, 21 Nov
Sorry forgot the command in my earlier email
To recap, here are the steps
1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
alter index . rebuild online tablespace
;
>From: Ken Janusz <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple rec
Bing,
Please explain your reasoning for backing up the archivelogs when you backup the
readonly tablespaces. One reason you change a tablespace to read only is to reduce the
backup needed. After a tablespace is in read only mode no changes are made to the data
and you only need to back it up o
Try clicking "Technical Libraries", then "Applications Install & Upgrade"
under ERP Applications, then click "Documentation" link and viola !
HTH
Srini Chavali
Oracle DBA
Cummins Inc
"Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>@fatcity.com on
11/21/2001 08:30:24 AM
Please respond to [E
Ken,
I don't think you will need steps 2 thru 5. After step 1, just write sql
that will spool out "alter index rebuild tablespace "
& run the resulting sql.
Will that work ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc
Ken Janusz <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001 08:25:34 AM
Please
Title: RE: Index File Name
Alistair I think you'll find that packages don't get stored in a tablespace per se... like you are describing below. They are stored in the data dictionary. So you don't need to allocate specific storage for them (other than the system tablespace) and for the most
There's an easier fix:
http://www.opera.com
:)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Wednesday, November 21, 2001 06:25
To: Multiple recipients of list ORA
This is strange..I could not log into Metalink using the
link metalink.oracle.com.
But I could log in using the link oracle.com/support/metalink.
Whats happening here, guysn and gals ??
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROT
1 - 100 of 124 matches
Mail list logo