-- Chuan Zhang <[EMAIL PROTECTED]>
>
> Thanks Jared for your invaluable information.
>
> One more question,
> To my very little knowledge about these tools(DataStage, Informatica),
You left out Ab Initio. Probably the best thing going for
heavy-duty processing.
> do these tools generate Oracl
Oracle said, optimal value will automatically shrink your rbs (with
continuous extents off course).
Since this is the case do you think is good to add the value of optimal.
Sinardy
-Original Message-
Tim
Sent: 01 February 2002 12:30
To: Multiple recipients of list ORACLE-L
Can what ca
rtfm
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 25, 2002 10:20 PM
> Hallo all you gurus,
>
> How can I write in the pl/sql code if I want to insert in a table the
number of rows that are inserted in the select statement in t
Can what cause a ORA-1555? A shrink? If that is the question... The
answer is yes...
Tim
-Original Message-
Sent: Thursday, January 31, 2002 11:00 PM
To: Multiple recipients of list ORACLE-L
Will this cause ora 1555 ?
-Original Message-
Tim
Sent: 31 January 2002 03:31
To: M
Thanks Jared for your invaluable information.
One more question,
To my very little knowledge about these tools(DataStage, Informatica),
do these tools generate Oracle executable scripts for ETL process? To my
knowledge, OWBuilder(Oracle Warehouse Builder) is a good one for me at
this moment in t
Will this cause ora 1555 ?
-Original Message-
Tim
Sent: 31 January 2002 03:31
To: Multiple recipients of list ORACLE-L
Um... Must be version differences... Here is a test case I ran on my
8.1.7.3 machine...
SQL> create public rollback segment tim tablespace rbs storage ( initial 1M
n
Ah!! But 5 years down the road, Larry's Oracle database may not need any
administration at all. You may just buy the pre-fabricated "OraLintel"
gadget from him that runs your apps... :-))
Seriously, he me getting in position to fight the IBM Linux Mainframe
running DB2(IBM announced the Linux MF
List,
I am trying to send email from Oracle when a table is updated.
The message must be a dynamic one, so hard coded message will not be
allowed.
I have created a trigger when the table is updated - that works
I am using UTL_SMTP to send emails. - that works
However this proced
Today I've seen two white papers on a technique called SQL Injection
for exploiting databases via web pages. One of the papers was pretty
much a step by step tutorial on how to reverse engineer data
structures and have your way with a SQL Server database via ASP pages.
Both papers were ASP/SQL S
The difference between a Contents of TEMPORARY and one of PERMANENT is
that you can create permanent objects (like tables or indexes) in a
tablespace that is considered PERMANENT and you cannot in one that is
considered TEMPORARY.
you need to do the following:
select segment_name, segment_type f
Interesting news. Makes me wonder though. Remember when
Oracle moved to support client-server computing? Now Larry
derides client-server and distributed computing saying
that it's cheaper to have just one big system. How many
times have you heard Larry talk about how Oracle's
consolidated their em
Sona,
Try this in your rman script
set until time "to_date('30-JAN-2002 12:00:00' ,'dd-mon- hh24:mi:ss')";
Make sure you have the NLS_DATE_FORMAT set too.
Sujatha
-Original Message-
Sent: Friday, 1 February 2002 11:45 AM
To: Multiple recipients of list ORACLE-L
Sujatha,
I tried
Sujatha,
I tried doing that but it failed
Set the NLS_DATE_FORMAT="DD-MON- HH24:MI:SS" at OS level.
RMAN script is
run
{
set until time '30-JAN-2002 14:53:56';
allocate clone channel c1 type disk;
allocate clone channel c2 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest
In the second half of 2000, I participated in an extensive evaluation
of ETL tools for a large data warehouse.
There were two main players at that time that we considered:
DataStage, owned by Informix, and now part of Ascential software
http://www.ascentialsoftware.com/products/datastage/
Info
Sona,
Try setting the NLS_DATE_FORMAT="DD-MON- 24HH:MI:SS" at the OS level.
Then in your RMAN script you should specify the point in time date as
follows:
set until time '31-JAN-2002 23:05:00';
It should work (I've tested it).
Regards,
Sujatha
-Original Message-
Sent: Friday, 1
Hello All,
Thanks for your responses. I am listing the query, if any one else wants to use the
query :-
SELECT t.tablespace_name, t.initial_extent,
t.next_extent, t.min_extents, t.max_extents,
t.pct_increase, status, contents, nvl(sum(extents),0)
FROMsys.dba_t
Hello All,
Thanks for your responses. I am listing the query, if any one else wants to use the
query :-
SELECT t.tablespace_name, t.initial_extent,
t.next_extent, t.min_extents, t.max_extents,
t.pct_increase, status, contents, nvl(sum(extents),0)
FROMsys.dba_t
you should set it as such :
export NLS_DATE_FORMAT="MON DD HH24:MI:SS"
you were missing the double quotes
regards
ReedK
-Original Message-
Sent: Thursday, January 31, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
What do i set the NLS_DATE_FORMAT as? I tried setting it
What do i set the NLS_DATE_FORMAT as? I tried setting it as
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
But got this error :
ksh: HH24:MI:SS: is not an identifier
Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i
still get the same error.
Sona
- Original Mes
Hi,
I am preparing questions for an Oracle DB Designer job interview. Two questions that I
would like you to give me some input. They are
1) What are the aspects of DB Design that you would consider to be important in J2EE
applications development?
2) Organisations usually have some standards
Hi, DBA gurus,
I am going to build our data warehousing project. In theory, I am
confident but in reality, At this moment, I only have Oracle Data
Warehousing Builder 3i in my hand. For those have built DW in Oracle,
could you share your experience on the tools to build the data
wareh
http://www.newscientist.com/hottopics/copyleft/copyleftart.jsp
Sam Bootsma, OCP
Technical Support Analyst
CPAS Systems Inc.
416-422-0563 x237
[EMAIL PROTECTED]
http://www.cpas.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Bootsma
INET: [EMAIL PROTECTED]
AShoke
Its oracle Bug which fixed in 8.1.7.During the time may be yours IOWAIT was
high.
Thx
-Seema
>From: "Ashoke Mandal" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: PMON CRASHED INSTANCE
>Date: Thu, 31 Jan 2002 1
Yes, Andy Duncan and I are collaborating on one.
Jared
"James McCann" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/31/02 12:50 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: OPS$ / defau
THX
-Original Message-
Sent: Thursday, January 31, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: LOCK!!!
Why dont u check it out from v$session_wait
>From what u have show below there is not locking issue
Check the v$session_wait,you should defnetly see
>I see a problem keeping the dump directories on the shared drives. For
some reason
> the drive is not available on either of thenodes, some thing happened,
then you
> can not even know what happened to Oracle, I mean your alertlog will
also be on
> the shared drive and so it is not avalabl
Why dont u check it out from v$session_wait
>From what u have show below there is not locking issue
Check the v$session_wait,you should defnetly see something out there
It is better always to come from v$session_Wait
If you see any issues there then u got a probs
-Original Message-
Sent:
Hi All,
I had almost the same situation. My production database crashed by itself with the
following errors:
PMON: terminating instance due to error 600
ORA-07445: exception encountered: core dump [kghispih()+56] [SIGSEGV] [Address not
mapped to object] [97812236] [] []
ORA-00600: internal err
Jared,
I'll have a go when I get the chance.
Did I hear someone on the list mention that you are bringing out an
Oracle/Perl book?
Jim
-Original Message-
[EMAIL PROTECTED]
Sent: 31 January 2002 18:39
To: Multiple recipients of list ORACLE-L
For those of you that use Perl and DBI,
Hello Mogens and others,
Yes,
You are right. But the current time based performance techniques still
include errors. Prior to 80's(when I was a child), yes, ratio based measurements
were the method. Then, wait-event based profiling appeared. In fact, this
was an adaptation of Response Time Perfor
You should still be able to go to the file menu bar and pick cancel from the
menu. Sometimes it takes a second when you click file to respond, but the
drop down does have a cancel action.
Kevin
-Original Message-
Sent: Thursday, January 31, 2002 2:08 PM
To: Multiple recipients of list O
Control C
or
Pulldown Menu... File / Cancel
-Original Message-
Sent: Thursday, January 31, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
we just migrate our ORACLE client on PC side from version 7.3 to 8i. some
programmers complain on 7.3 Sql/Plus when they run SQL statemen
Hi,
I have probably to beg you pardon for my question but I have a very short experince as
an Oracle dba and it is the first time I found a situation like the one I'm going to
describe to you.
Working on an existing Oracle database I found that all users had been defined with an
associated te
Hi, guys,
Trying to figure out what my best option is. Some users are unable to access
the system. Previously I had a trace file with " Deadlock detected ", but
that session was killed.
SELECT * FROM V$LOCK WHERE block<>0 or lmode=6
/
ADDR KADDR SID TYID1ID2
Tom & chris
thanks for the reply.
I see a problem keeping the dump directories on the shared drives. For some reason the
drive is not available on either of the
nodes, some thing happened, then you can not even know what happened to Oracle, I
mean your alertlog will also be on the shared
driv
we just migrate our ORACLE client on PC side from version 7.3 to 8i. some
programmers complain on 7.3 Sql/Plus when they run SQL statement, a small
window box will pop up and they can "cancel" the long running job. This
feature does NOT show up on 8i Sql/Plus. I checked "option" on sql/plus
and
Interesting information especially about the HP boxes not being
replaced. Could it be that the HP/Compaq merger go ahead is not the move
that Larry desired? After all the RAC is an Oracle and Compaq wedding.
Looks like the honeymoon is over and the new young kid won for a while.
Maybe now it will
Title: Linux taking over at Oracle
For anyone who missed it:
-
Ellison says Oracle's 'whole business' to run on Linux
The Oracle chairman and CEO said the company will replace three Unix servers
that run the bulk of its business applications with a cluster of Intel
Hello Oracle Friends,
I am trying to install Oracle 9i on SUN Sparc and this is what iam
getting while running runInstaller
Initializing Java Virtual Machine from
/tmp/OraInstall/jre/bin/jre. Please wait...
Exception java.lang.NullPointerException
occurred..java.lang.NullPointerException
Does anyone know why catrep.sql puts things in the SYSTEM schema, instead of
just placing them all inside SYS?
I found this in the catrep.sql script:
Rem **
Rem For SYS to be able to grant select on defcalldest and deftrandest
R
Hi,
We have 3 tables involved a query. If all the tables are permanent then we
have a
explain plan with very less cost and query runs very fast BUT
if we use 1 global temporary table..explain plan is different with high
cost...and it seems
it don't use index for other tables also...
Is
It only exists if the Oracle Agent is running.
In my case, it (the agent) is not running, so I don't have the file. (and
I'm on NT, so we all know, there is no protection required! :) )
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 31, 2002
They just did a drop package body package_body_name;
They suspect they lost the package header when they created a synonym
pointing to an identical package in someone else's schema.
Feedback from the developers:
HOW TO Guide for people who like the movie Night of the Living Dead:
Create a pac
Remco,
When you say you cannot drop, what do you mean? Does it wait forever? If
so, your table could be made up of thousands of extents. There are tips on
Metalink on how to drop a table with a large number of extents, and to make
it run faster? Look up.
And as for the dictionary table you are
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: RMAN error while
You should take a look at 'Scaling Oracle8i' by James Morle.
It's a mini computer systems architecture course. You go through
quite a bit of OS and HW before you ever get to Oracle.
Helps you very clearly see the relationship between Oracle, OS and HW.
Jared
"SARKAR, Samir" <[EMAIL PROTE
Big list.
Didn't think of searching the directories. That would have been easier and
better than searching the docs, as I did, Doh!
I'll have to write a procedure to rename/lock them if they exist,
Jim
-Original Message-
Faroult
Sent: 31 January 2002 17:41
To: Multiple recipients of lis
thanks - turns out I think that UDS needs the ORACLE_HOME environment
variable set, which conflicts with multiple ORACLE_HOME directories. When I
set it manaully it runs fine.
Need to follow up with application provider.
-Original Message-
Sent: Thu, January 31, 2002 12:53 PM
To: Mult
On Mon, 28 Jan 2002, Molina, Gerardo wrote:
> The status of the data file (on the standby database) shows
> "RECOVER" unless the standby control file is refreshed.
This status makes no difference in recovering/opening/using the
standby. I believe the assertion in the doc is incorrect.
--
Jerem
see my later post :)
but he had posted that he was going to do a database shutdown first
--- Joan Hsieh <[EMAIL PROTECTED]> wrote:
> offline. That's why.
>
> Rachel Carmichael wrote:
> >
> > you can certainly rename a file with the database open -- but was
> the
> > tablespace offline?
>
For those of you that use Perl and DBI, here's a script to check for
default
passwords. If you feel like extending the password list ( hint, hint ), I
wouldn't
mind a bit.
Jared
#!/export/home/oracle/perl/bin/perl
# odpc.pl
# oracle default password check
# Jared Still
# [EMAIL PROTECTED]
To add further, what I have read is, on Windows NT, being able to edit the
registry, could allow one to change the ORA_PWFILE value, and point to
their own password file. Hence, access to the registry should be resticted.
Raj
Commit; :-)
In my opinion, you shouldn't spend your money on buying the Niemich book.
It's full of errors (increase the buffer cache hit ratio, for instance) and
the wrong approach (no time-based measurement method, just checklist after
checklist).
Buy 101 by Gaja. Then buy Tom Kyte's One-On-O
scary
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> James McCann wrote:
> >
> > Speaking of default accounts with default passwords, here is my
> list that I
> > check for. Anyone want to compare notes :) i.e. have I missed any?
> >
> > Thanks,
> >
> > Jim
> >
> > perfstat/perfstat
> > T
change it in snmp.ora
which is in clear text on the Unix server.
protect that file!
--- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote:
> Hey All,
>
> Anyone remember how to change the DBSNMP password? I know I can
> change it
> in the db easily enough, but how does the server/DBSNMP l
SUN 9960 storage system comes with RAID-1 PLUS. Any ideas on what kind of
RAID this is. Not heard of RAID-1 plus.
Regards,
Murali Vallath
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/
It goes in snmp_rw.ora
snmp.connect..password = "dbsnmppwd"
snmp.connect..password = "dbsnmppwd"
-Original Message-
Sent: Thursday, January 31, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
Hey All,
Anyone remember how to change the DBSNMP password? I know I can change
it
offline. That's why.
Rachel Carmichael wrote:
>
> you can certainly rename a file with the database open -- but was the
> tablespace offline?
>
> --- Joan Hsieh <[EMAIL PROTECTED]> wrote:
> > hmmm. I renamed a file yesterday with open database. I didn't check
> > the
> > manual just did it on t
Patrice,
Did you try and re-create a package body that matches the header (even a
skeletal one) and then drop the package?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 31, 2002 12:41 PM
To: Multiple recipients of list ORACLE-L
We just migrat
Hi,
It would appear that I am going to be taking over suppport of a DB2 database
on AIX in the near future. Anyone done this before and is aware of
similarities and gotchas etc.
Any useful mailing lists/links/white papers/book recommendations etc. would
be great.
Lee
The information containe
Hey All,
Anyone remember how to change the DBSNMP password? I know I can change it
in the db easily enough, but how does the server/DBSNMP listener process
know what the new password is? Must be stored in an OS file someplace.
I was just poking around trying to figure it out. The docs have th
Hmmm ... I think someone just ran the script that has package body and no
header... I have seen this in my development database.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed h
Hello Bill
I had similar problem with Magic.
We upgraded (a laptop in this case) from oracle 7.3.4 to 8.1.6.
It seems that Magic has a specific drive that depends on the oracle version.
We got the new driver for 816 and then it started to work again.
I think that you should check with the supplie
We just migrated a database, and as part of our validation we noticed that
we had a package body in one schema with no package header.
This is the case both in the old db and in the new one, exp / imp faithfully
recreated the decapitated package body in the new db.
Change Manager did not report
James McCann wrote:
>
> Speaking of default accounts with default passwords, here is my list that I
> check for. Anyone want to compare notes :) i.e. have I missed any?
>
> Thanks,
>
> Jim
>
> perfstat/perfstat
> TRACESVR ??? is only used with 7.x Databases
> REPADMIN ???
> CTXSYS/CTXSYS
I just remembered why remote_os_authent was so insecure
in v7 sqlnet v2: you could become SYSTEM just by setting
USER_ID=SYSTEM in Oracle.ini, but the SYSTEM user
did *not* need to be identified externally.
That's what was so insecure. I've just been trying to see if
any similar insecurities
Gday All,
I have a db delivered for the application Atlys.
CVG have Solaris 2.8 64bit Oracle 8172 32 bit
I have Solaris 2.8 64bit Oracle 8172 64bit
At startup the database spat the following:
ksedmp: internal or fatal error
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801:
Deen,
Let's suppose you have to do an import to recover something. What happens
when you try to do the import, but realize you can't because the dump file
is on a local disk on the other server???
It's Miller time...time to relax, one beer stands clear...Miller beer
Chris
"May Oracle be wi
Yellow is out, we use our Company colors now. Black/red/white color
stickers (with the V-check mark) ;>)
- Kirti
-Original Message-
Sent: Thursday, January 31, 2002 10:51 AM
To: Multiple recipients of list ORACLE-L
i can just see it now, user ids generated by the security group, th
We change production password too, but not that often. But I have a DB level
trigger that logs each login and captures OSuser too. Then I have a report
that is run by my good friend "cron" telling me who is logging in as what.
So, if we find somebody, their managers get informed, mentioned in the
TUNE??
-Original Message-
Sent: Thursday, January 31, 2002 6:30 AM
To: Multiple recipients of list ORACLE-L
Bambi,
Thanks for the heads up. How was the response time on the apps if it
relied on an outside location for some of it's work? Most be a nightmare
to tune that sucker.
ROR mô¿ô
Hi, all:
I'm running iPlanet's Unified Development Server (formerly Forte 4GL) on an
NT4.0 Wks. Had an 8.1.6 Oracle client and all worked fine. I installed a
second, 8.1.7 client and ever since I'm getting this error message when
trying to run code that accesses the db. Get the same error no m
i can just see it now, user ids generated by the security group, there must be lots of
little yellow stickers on everyone's pc :)
>>> [EMAIL PROTECTED] 01/31/02 10:25AM >>>
Stephane,
Thanks. Yes, we are properly fenced
None of the databases have those default accounts with default passwo
what a concept... changing production passwords!
hm, I knew I liked your company as my phone provider :)
--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> Stephane,
> Thanks. Yes, we are properly fenced
> None of the databases have those default accounts with default
> passwords.
> We
1. Create a dblink to SID1 from SID2 connecting as userA@SID1.
2. On SID2 create a synonym MYPKG for the user (who wishes to execute the
package) for mail_pkg@dblink created above.
3. On SID1 grant execute on package to userA (identified in step1).
4. from SID2, execute mypkg with appropriate par
Speaking of default accounts with default passwords, here is my list that I
check for. Anyone want to compare notes :) i.e. have I missed any?
Thanks,
Jim
perfstat/perfstat
TRACESVR ??? is only used with 7.x Databases
REPADMIN ???
CTXSYS/CTXSYS
DBSNMP/DBSNMP
INTERNAL/ORACLE
MDSYS/MDSYS
M
Rick,
I do this all the time. What I do is to create a local package that simply
calls the remote package. This insulates the local application from any
changes (especially to the db link name). You could also program in a way
to not call the package if db link goes bad for some reason.
below
you can certainly rename a file with the database open -- but was the
tablespace offline?
--- Joan Hsieh <[EMAIL PROTECTED]> wrote:
> hmmm. I renamed a file yesterday with open database. I didn't check
> the
> manual just did it on the fly. No complains. I have to check the book
> again.
>
> Jo
--- Begin Message ---
You may wont to reconsider using Richard Niemiec's book. It's unfortunately
NOT one of the best books on Oracle tuning, you can get. It's actually pretty
full of factual errors and poor advices. There is a quite negative review
on amazon, that you should read.
I too,
Naveen,
I don't believe that anyone on this list will reprimand a beginner
for asking beginner questions, as long as he or she has done
some homework first.
The gist of the article is that listservs are a great place to ask
questions and get different viewpoints, but don't make it your
first s
OK, so there are risks. I will make sure OPS$ORACLE has restricted access.
New question. In 8.1.6 I have set everything up the same as I did in 7.3.4
but when I
try to run SQL*PLUS as sqlplus / I get invalid user name / password. I am
searching
the sorry documentaion CD but I havn't found the
Hi DBAs,
I have a package(mail_pkg) in instance SID1. Can I run the package from
instance SID2? If so how do I proceed?
Is it just a matter of creating a db_link. ex. exec mail_pkg.send_mail
()@dblink_name.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Aut
Deen,
I am keeping all of the Oracle files (including dump directories) on shared
disks. These disks then fail over when MCS/OFS fail to the other box.
Makes in cleaner, in my view, that the *total* Oracle database fails over as
one unit.
I have the Oracle software installed on local disks (dri
I recently wrote an article for Oracle Magazine that
described some of Oracle9i's new ETL features. A reader
clued me into an interesting issue with respect to bad
files. If anyone's intersted, and if you're using external
tables at all you probably should be interested, I wrote a
follow-up articl
Hi
Naveen,
I have no objections
to RTFM. I do have objections to rudeness, arrogance and nastiness.
It's so easy to just hit the delete key -- nobody is making anybody answer any
e-mails. If they don't want to answer them, they can just delete them,
without all the nastiness. I'm new
Hi,
I'm stuck with a table I can't drop and can't update. Select works fine,
status is valid and the name appears in dba_tables and dba_objects. I
seem to remember someone posting a solution to this problem some time
ago, but can't find it. Something like manually adding a record in a
dictionary
[EMAIL PROTECTED] wrote:
>I agree we need to look at both. Depends on the shop you work in if you
>can though. Where I've been the SAs hold tuning of the OS close, and I
>can work WITH them but can't effect changes on my own. so I concentrate
>on the database.
>
it also helps if the OS is tunable
For what seems to be the few of you who use interMedia Text, I found the
problem - it was ME. :-(
I had set (in CTX_Parameters) Max_Index_Memory to 200MB (from the default of
12.5MB) and used 200MB when I created indexes, but had overlooked
Default_Index_Memory (default of 12.5MB), which is used
Rachel and others,Well thats what i mentioned in my post, that he shud do some RTFM. I being a new joiner to the list was not aware that u guys had already advised him that.in that case, i'll say the blame directly falls on him rather than u guys.Sorry, sometimes little knowledge can be a harmful t
Oh, Sure..
I have seen that in the past (with 7.2.3.0).
Actually, at my current job, we had one 'very special' database (built by an
Oracle Consultant), where the Prod Schema owner was an OPS$ account. How
conveeenient!
The Contractor DBA who managed it when I joined, told me that that
This query should give u the total number of used extents in a tablespace as
well
as the number of used blocks and bytes :
select a.tablespace_name, NVL(count(extent_id),0) "Used Extents",
sum(NVL(bytes,0)) "Bytes Used",
sum(NVL(blocks,0)) "Blocks Used"
from dba_tablespaces a, d
Sergey,
This is how we learn ... by making mistakes and lessons such as these can
never be forgotten.
Good luck
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal
Errata :
Change the last line of the query to
group by a.tablespace_name
Sorry about that !!
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fa
Thank you, Henry, but that still does not excuse my stupidity and being
superficial. I need to learn more about Oracle internals, and that's
something which is NOT taught at schools. So I try to learn it from you,
guys, and much appreciate this opportunity. Anyway, I've been successful,
too, so I
[EMAIL PROTECTED] wrote:
>
>Anyway, BE AWARE, if you're running Vision, about 20% of your app, by
>default, is served outside your own environment, meaning that approximately
>20% of the problems you will have will be outside your control. Oh, and
>that teamwork thing works real well when you're
one of the nicer little features of 9i is that those accounts come
"locked" when you build the database. The set of privileges for each
has also been greatly restricted.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> "Deshpande, Kirti" wrote:
> >
> > We use REMOTE_OS_AUTHENT in many of our d
Well if you want to do it all in one swoop (without the spool stuff that has
worked for eons):
declare
crsr number;
ignore_me number;
userx varchar2 := '&1';
stmt varchar2(100);
begin
crsr := dbms_sql.open_cursor;
for grnts in (select table_name from user_tables) loop
stmt := 'gra
Try this . . . input is name of schema owner and who's being granted the
rights. It grants full DML rights on all schema objects to a known user or
role. Can be edited for "select only" rights on tables, if you want . . .
-bill
/* SQL*PLUS SETTINGS */
SET ECHO OFF
SET VERIFY OFF
SET SERVEROUT
well if an index already exists that satisifies the requirements of the
primary key when you add the constraint, Oracle will use the existing
index/
So I'd create the table, create the index and then add the primary key
constraint.
--- Marin Dimitrov <[EMAIL PROTECTED]> wrote:
>
> hi,
>
> how
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=18870.1
explains that rather well
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
1 - 100 of 126 matches
Mail list logo