I didn't think there were other clustered databases?!
Mogens
Pete Sharman wrote:
If you're a member of the UKOUG (probably unlikely, but worth a try!)
it's on their web site I believe.
I still haven't managed to get Jonathan to add my editorial but every
example you give would wreck ANY
Check out doc id: 155979. It have info about connecting from form 6i to
oracle 8.1.7 with advance security.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 2:30 PM
List, i need some help on this... i
It all depends on the frequency of your scheduler..
If it wakes up every 10 seconds the blocks are already in memory so updating
the bitmap will not involve that much overhead.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Take any tool that does compare schema, trace it, and put
a wrapper that will activate the script for all schemas in the
database.
If you have TOAD you can easily capture the sql via spool
sql to file (or screen).
For your side note: restore a backup to the test
system.
If you need only
Hi:
I happeded to use strace to trace system call of an oracle process and suprised to
find that it used so many getrusage/gettimeofday/times system call than I can imagine.
Is it because of timed_statistics or Oracle itself used so many to maintain its
v$ views? From the result, it used
Hi
I was thinking in that direction (memory usage, core dumps etc.), but it
doesn't seem to be that. It's also not able to establish a relationship
like: If I execute thing A, error B occurs..
Stefan
-Ursprüngliche Nachricht-
Von: Wartiak Rastislav [mailto:[EMAIL PROTECTED]
Gesendet:
Hi
According to that ... I guess their routers are fired by coal, like those
old steam engines ;). No, seriously, I don't know much about their
equipment. It's supposedly modern equipment mixed with poor skills ;).
I was suggesting to look for dropped packages or problems with MTU size,
since
Hi Dennis
According to Metalink, an ora-03113 on an already established connection
points to a terminated Oracle executable. This is not the case, Oracle is
still up and running.
Unfortunately, it's windows, so I still have to figure out how to see wether
the user process has been terminated
Hi
Looks like I have to try that one, since truncate should be reasonably
faster then replace.
Thanks,
Stefan
-Ursprüngliche Nachricht-
Von: Jacques Kilchoer [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 13. November 2003 20:54
An: Multiple recipients of list ORACLE-L
Betreff: RE:
The solution is simple. The correct sequence of characters is not
chr(10)||chr(13) but rather chr(13)||chr(10). This is obviously changed
by notepad.
regards, Joze
-Original Message-
Sent: Friday, November 14, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L
Hi,
Currently I
HELP
Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida
Stefan - A terminated Oracle executable is one of the possibilities.
Certainly worth verifying. Then you can proceed to the less likely
possibilities. I don't do Windows, so good luck there.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November
Hi Gunnar,
You can use utl_file, it doesn't read from the same directory, you
specify utl_file_dir locations pre 9iR2 and directory objects 9iR2
onwards to where you want it to read from and then you open and read the
fil3es you wish. You could also use external procedures and use C, you
could
Hi
Go to Jonathan Lewis's website and send him an email about it,
http://www.jlcomp.demon.co.uk,
kind regards
Pete
In article [EMAIL PROTECTED], Rognes, Sten
[EMAIL PROTECTED] writes
I've been looking for a copy of Jonathan Lewis' Does Anything Run on
RAC? paper/presentation without luck.
--_=_NextPart_001_01C3AAA8.95C529E0
Content-Type: text/plain; charset=iso-8859-1
Well, I have to say the answer to both questions is probably DataBee . (
www.databee.com http://www.databee.com ) , although not via a script.
Just been using it quite a bit recently, so your question
Thanks for that, Stephane -
hmmm, I'm still working on it... will post the successful script when I get
it...
peter
edinburgh
-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L
Hi Stefan
ORA-3113 means that the thing at the other end of your client's sqlnet
connection has died, i.e. the user process. On unix with dedicated server,
its an oracle executable, on windows I guess it's a thread, I'm not sure
what it would be on MTS. This is not the same as the database
Strip out the chr(10) and chr(13) using
update tname set field = replace(field,chr(13),' ')
where instr(column_name,chr(13)) 0 having count(*) 0;'
BUT check whether you want to replace your chr(10) and chr(13) with a space(
' ') or nothing ('').
Use the above 'where' clause in a select to
Arup, thanks for taking the time to put that together,
that's a great explanation.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per
Hi
I'm not aware of any out-of-the-box Oracle solution either (like STDDEV or
AVG).
Looks like one has to roll ones own statistical functions when it comes to
calculating things like modus or median.
Is anybody aware of an extension, maybe in form of an old cartridge or a
pl/sql library to
-Original Message-
Sent: Thursday, November 13, 2003 10:49 PM
To: Multiple recipients of list ORACLE-L
SNIP
Stopping someone from using a given set of accounts achieves preciously
nothing in terms of security (or auditing) IF the functionality of those accounts
is then replicated to
Dear Gurus,
I have dbms_job in replication environment to push deffered transactions from site A
to B and B to A.
The job which is running at site A is working fine but job which is running at site
B is not pushing the transactions automatically. But if I do it manually (either
Why not just trim the new line of the data, and allow
put_line to do it.
hth
connor
--- [EMAIL PROTECTED] wrote: Im reading from
user_source and writing the text of
packages to files. Problem is that if i use
UTL_FILE.PUT_LINE it adds an extra '/n'(end of line
character or space) into the
I thought SYS and SYSTEM were NOT 'PUBLIC' accounts. It all depends on
how many people you let login as SYS or SYSTEM, and that decision will
be different for each individual DBA.
But my question is: How can you give a portion of SYS/SYSTEM
functionality to Jane DBA and Joe DBA if you DO NOT have
Joze,
It's not that simply. I already tried all the possible combination: chr(13)||chr(10) ,
chr(10)||chr(13), chr(13) , chr(10)||chr(10)...
Thanks for your input anyway.
Regards,
Kitty
-Original Message-
Sent: Friday, November 14, 2003 6:09 AM
To: Multiple recipients of list ORACLE-L
I can see using them in some cases where say I have majority OLTP users and have a few
batch processes that I dont want sucking up resources.
Other than that... Im not sure they are particularly useful?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump (never remember where it goes).
HTH
SF
- --- Original Message --- -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Title: DB Code compilation and library cache lock issue
Hi all,
As we know if procedure A is currently being executed, one cannot re-compile procedure A. And when one tries to do so, the compilation appears to be _hanging_. Though it time-outs after some time.
My question is , is there a
Peter,
Thanks for your input.
You misunderstood the problem. The point is the SAP needs that LF and CR (chr(10) and
chr(13)).
Of course, I used a hex editor to look at it, they are OK (0A and 0D). That's why it
is frustrate.
Anybody who had a similar problem before, please help me.
Thanks,
Kitty,
when the file is written by pl/sql note its size. Then open and save in notepad and
note its size. If both sizes are different, you know there is a CR/LF problem, else
problems is somewhere else.
Raj
Title: RE: LF and CR (chr(10)||chr(13)) problem
Then you should use an editor that is capable to show file contents in hex. Or you can use a program that compares two files - the original and the one transformed by notepad and see the difference.
Regards, Joze
-Original Message-
Hi
I'm not exactly sure about your scenario, but maybe this helps:
I'm getting data from a host plattform, which eventually has to be imported
into an Oracle DB running on Win2k. We take the flat files (containing host
specific EBCDIC character data including CRLFs) and move them via binary
mode
Hi!
I've gone looking for guidelines/info to assist in tuning this particular
parameter, but am getting conflicting information.
- In a post by guru Howard J. Rogers to c.d.o.s. regarding a thread where
someone specifically asks how to configure these two parameter, He states
that he
I have been using this method in all my 8.0 and 8.1 databases.
Unfortunately, if it is a TEMPORARY Tablespace with a TEMPFILE,
[as I have begun using in 9.2] this command fails.
Then, the only option to either resize the TEMPFILE or resize the TEMPORARY
Segment is to drop and recreate the
Thanks Dick. It is worth a try.
-Original Message-
Sent: Thursday, November 13, 2003 6:35 PM
To: Multiple recipients of list ORACLE-L
To the best of my knowledge, I've done this several times now, you run the
appropriate upgrade script then the utlirp.sql script to migrate from 32
Maybe possible that this is related to what Unix needs at that end of a line
and what DOS needs at the end of line and what happens when such files get
FTP-ed in ascii mode from one to the other?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET:
The size do differ between two files.
I attached both files. The problem is between the end of line2 / and the begin of
line3 2 in the customer.txt.
Thanks,
Kitty
-Original Message-
Sent: Friday, November 14, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Kitty,
when the
sorry your attachments were filtered out ... can you attach them as txt files?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Thanks for the info Dick. I also found an article on metalink 62290.1
(changing between 32-bit and 64-bit word sizes).
Murali.
|-+---
| | [EMAIL PROTECTED]|
| | tate.fl.us |
| | Sent by:
Btw, this is a simplification, in parallel execution environment, the
situation is a different (as can be read from ixora).
Also, I missed a comma in my previous post, No sort memory should be No,
sort memory.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Tried it. According to Jonathan the paper will be publicly available after
it's presented at the December UKOUG. Still, I see the paper available for
download (older version?) from UKOUG. I am sure that's a fine group of
people, but when membership starts at £250 and I am not located in the UK
Hi List,
Finally, I used HexCmp and found out the file generated by Oracle PLSQL or report
writer only contains a CR (chr(13)) even if I had a chr(13) and chr(10) in the query.
I re-wrote my export scripts in java, then resulting file is OK.
Thanks to all of you who responded my problem.
Does anyone happen to know of any good email lists that
focus on things SQL?
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one
article on Oracle technologies per month by
How about ORACLE-L at fatcity.com ... 8:)
you are not abandoning us are you Jonathan?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have
Jonathan
Do you mean a list that just focuses on the SQL language in general,
unrelated to any particular database?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November 14, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Does anyone
At some point, when you first create your database, you're going to have the
passwords to sys and system... you created them. After that point, you
create a DBA account for DBA1, DBA2... DBAn. Then you change the passwords
for sys and system to something obscure. But keep them somewhere because
Why not do it like this...
select usr from gab
where val=1
intersect
select usr from gab
where val=5
intersect
select usr from gab
where val=7;
-Original Message-
Sent: Thursday, November 13, 2003 7:35 PM
To: Multiple recipients of list ORACLE-L
Mr. Begun: I'm not convinced that your
Mr Norgaard, you pedant! :)
As you well know, what I meant was that the application coding
techniques that Jonathan describes are ones that will limit any
database's scalability.
Now go and have a few more beers (unless your thief has taken them all!
:)
Or maybe I should have had some more
Friday, November 14, 2003, 11:49:25 AM, Jamadagni, Rajendra ([EMAIL PROTECTED]) wrote:
JR How about ORACLE-L at fatcity.com ... 8:)
JR you are not abandoning us are you Jonathan?
No, not at all. I'm just trying to connect to some people
who live, breath, and eat SQL.
Best regards,
Jonathan
There
are really two answers to this and it depends largely on what you want to
do. If you want to check for the existence of a file and generate an error
if it's not there, you can do something along the lines
of...
whenever oserror do something
!ls -l
$DIR/$FILENAME
Alternatively, if
End of the day, read to it through fast, what can I say.
I totally blew by the part that said 'TEMPORARY'.
Now that I realize which thread I'm in, going back through
it reveals that the original poster has still not clarified
his original post.
eg. there isn't enough information provided to
Simplest if you know the format of the files ... use external
tables.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have
Stephane,
This is what I was exactly looking for. Thank you so much.
- Original Message -
Date: Friday, November 14, 2003 8:59 am
Jay,
Check http://www.oriole.com/aunt_2001_0.html
and look for the 19th. March 2001 entry.
Otherwise look for a snp*.trc in either bdump or udump
Hi
Check out the free tool on http://www.impacttoys.com. It is called
T.O.Y.S. and compares the schema's or complete database between two
databases. You can specify down to the object levels what is compared
and also generate DDL to synchronise the two. Its windows GUI based and
seems quite
I got the impression that the poster was thinking segments allocated in temp
tablespace must be released, cleaned out, blown away, etc. before something
else can come along and use the space.
-Original Message-
End of the day, read to it through fast, what can I say.
I totally blew by
the guys who concentrate just on sql tend to be sql server lists with people who
generally dont like oracle.
i know joe celko who wrote those sql books posts on the sql server usenets.
From: Jonathan Gennick [EMAIL PROTECTED]
Date: 2003/11/14 Fri AM 11:39:28 EST
To: Multiple recipients of
Friends --
Why would these two queries return different results?
This query works.
SQL l
1 select
a.tablespace_name,megs_allocated,megs_used,round(megs_used/b.megs_allocated,
2)*100 pct
2 from (select tablespace_name,sum(bytes)/(1024*1024) megs_used
3 from dba_extents group by
Paula,
I moved a database (Sun box) from 32 to 64 bit Oracle 9.2.x. I did nothing
except point the database to the 64 bit Oracle software. Of course, it was
the same release levels (32 64 were both 9.2.x). Everything is fine.
At the very least, I would think that you need to run catalog
List,
I have 50 lookup tables and all of them have effective date end date I
want to create a rule or some thing like this which any select statement
select the data from these lookup where the sysdate between effective date
end date.
Example:
select * from table1 ( always select those
I believe what you are asking for is called a View.
-Original Message-
Sent: Friday, November 14, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
List,
I have 50 lookup tables and all of them have effective date end date I
want to create a rule or some thing like this which
you answered your own question ...
select *
from my_table
where trunc(sysdate) between trunc(eff_date) and trunc(end_date)
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Here are the requirements for toys:
Microsoft® Windows® XP / 2000 / NT4 / Me* / 98*
Do you know af any tool that doesn't require obscene operating systems?
(Obscene OSes = the ones above, plus anything from the same vendor)
At least, it should work under Wine.
On 11/14/2003 12:09:27 PM, Pete
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
I got the impression that the poster was thinking segments allocated
in temp tablespace must be released, cleaned out, blown away, etc.
before something else can come along and use the space.
i was always under the impression that
ummm fast typing ...
create view v_my_table as
select *
from my_table
where trunc(sysdate) between trunc(eff_date) and trunc(end_date)
/
and then use v_my_table in your code ...
Raj
Rajendra dot Jamadagni at
In the process of testing my rman recovery scripts? How do I corrupt a
datafile created on a raw volume? DD, CAT, VI, RM ?
Thanks in Advance
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services--
That would be the part where the application programming kicks in.
If you want to give users a possibility to run ad hoc queries, which
is something that I allow only to those users who have transcended into
the pure spiritual form and only on written request from the Pearly Gate
manager
Hi Jonathan,
I saw this link posted some time back for a new yahoo group focusing on
SQL:- http://groups.yahoo.com/group/Oracle9iSQL, don't know how popular
it is.
kind regards
Pete
In article [EMAIL PROTECTED], Jonathan Gennick
[EMAIL PROTECTED] writes
Does anyone happen to know of any good
Ja. That was my point ... and probably why some people didn't quite
understand the original question (a lot of assumption on my part, but I
think that is what the confusion was about).
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003
Bambi,
I think that the query (2) will return the the same count as query (1)
if you use the
column user_bytes from the dba_data_files rather than the column
bytes.
If I sum the bytes from dba_extents for a tablespace_name xxx
and sum the user_bytes from dba_data_files for tablespace_name xxx I
Dear Gurus,
Is there a way to give truncate privilege on particular table to a particular user?
(Without using procedure)
Thanks
Jay
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
WOW! There's something you don't hear everyday, Chauncy!
How about
echo Mary had a little lamb /dev/rdsk/file
-Original Message-
Sent: Friday, November 14, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L
In the process of testing my rman recovery scripts? How do I corrupt a
Hamid,
You could always have a canned query that the run to look up the data
and have the script ask them for the table name.
select * from tabname where sysdate between (select min(effdate)
from tabname) and
(select max(enddate) from tabname)
Or something along those lines.
Ron
[EMAIL
Nice try. Same result.
1 select a. tablespace_name, sum(b.user_bytes)/(1024*1024) allocated,
2 sum(a.bytes)/(1024*1024) used, round(sum(a.bytes)/sum(b.user_bytes),4)
pct
3 from dba_extents a, dba_data_files b
4 where a.tablespace_name=b.tablespace_name
5 and
truncate comes with the drop any table privilege so no, unless you
code a procedure or the user in question is the owner of the table, you
can't grant truncate on a particular table.
--- [EMAIL PROTECTED] wrote:
Dear Gurus,
Is there a way to give truncate privilege on particular table to a
Bambi,
Your second query is wrong because all extents in a tablespace don't
necessarily belong to the same datafile. Try the query without the
aggregate functions and the GROUP BY, and you'll understand your
mistake.
HTH,
SF
Bellow, Bambi wrote:
Friends --
Why would these two queries
I agree with you Bill. My temp space is always 80% full. I ignore it until
I get a report of a sql error.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, November 14, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] scribbled on
What you essentially need to do (without any additional programming
effort) is implement VPD (Virtual Private Database).
The link is here:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02.htm#1009919
HTH
GovindanK
On Fri, 14 Nov 2003 09:49:25 -0800, Hamid Alavi
Yes. Instead of using a procedure, create a function or a package that does the
truncate. Grant execute on the function or package to the user doing the truncate.
Without creating a procedure, a function or a package: no.
-Original Message-
[EMAIL PROTECTED]
Is there a way to give
Odder still, I get inconsistent results. megs_allocated is always
wrong, but megs_used is right when run against one tablespace, wrong
against another:
TABLESPACE_NAMEMEGS_ALLOCATED MEGS_USEDPCT
-- -- -- --
Thanks Bambi,Rachel and Jacques.
- Original Message -
Date: Friday, November 14, 2003 2:19 pm
Yes. Instead of using a procedure, create a function or a package
that does the truncate. Grant execute on the function or package
to the user doing the truncate.
Without creating a
Bambi,
I tried your sql on my test server and the used space is the same.
here are the results. The ALLOCATED and PCT are way out, I'm looking.
1 select
a.tablespace_name,megs_allocated,megs_used,round(megs_used/b.megs_allocated,2)*100
pct
2 from (select
Jay,
How about that particular owner own the particular table and give the
DBA rights with admin option?
The owner of the table can truncate it can it not? and if the owner
gives the DBA all rights with admin option can not the DBA treat the
table as it's own? don't forget the synonyms.
Ron
Kitty , it is nice on your part to share the solution with the list.
For future : (On the lines of what Stefan said)
May be dd if=inputfile of=outputfile conv=ebcdic/ebcdicb/ibm/ibmb might
have
helped. Check with man dd.
The suggestion given by Raj is worth keeping in mind.
HTH
GovindanK
On
But Stephane, I am aggregating by tablespace for both extents and for
data_files. There is nothing here that is separating out anything by
datafile. And, if I take away the GROUP BY, I lose the ability to aggregate
at all, which is the point of this...
-Original Message-
Sent: Friday,
fdisk (format on SUN) will probably do it as well.
On 11/14/2003 01:59:32 PM, Bellow, Bambi wrote:
WOW! There's something you don't hear everyday, Chauncy!
How about
echo Mary had a little lamb /dev/rdsk/file
-Original Message-
Sent: Friday, November 14, 2003 12:19 PM
To:
Did you try copying a junk file to it. dd if= of=
:) did not think corrupting something would be a problem. "Bellow, Bambi" [EMAIL PROTECTED] wrote:
WOW! There's something you don't hear everyday, Chauncy!How aboutecho "Mary had a little lamb" /dev/rdsk/-Original Message-Sent: Friday,
Did you try copying a junk file to it. dd if= of=
:) did not think corrupting something would be a problem. "Bellow, Bambi" [EMAIL PROTECTED] wrote:
WOW! There's something you don't hear everyday, Chauncy!How aboutecho "Mary had a little lamb" /dev/rdsk/-Original Message-Sent: Friday,
Raj
This was discussed recently on this list. If you go to Google and enter
oracle-l corruption, you will find the discussion thread and the
suggestions.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, November 14, 2003 12:19 PM
To: Multiple
NO I mean these tables always filtered even if some body run a query like
this:
select * from table1 -- return the all the records where the
sysdate between effective date end date
-Original Message-
Sent: Friday, November 14, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
I encountered the same issues. Also, just to make things interesting, if
you replace DBA_EXTENTS with DBA_FREE_SPACE, the number of MEGS_ALLOCATED is
different. Still wrong, mind you, but different.
None of this makes any sense to me. My bet is that I got me a bug.
Bambi.
-Original
Below is a very nice tablespace script, followed by some sample output.
Thought you might like it. I found in somewhere.
REM name: freespace.sql
REM This script is used to list database freespace, total database
REM space, largest extent, fragments and percent freespace.
REM
REM Usage
Corrupt a datafile ... you mean morally or ... physically
??
tgif
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts,
Hamid,
Create a view on top of the table and apply the where clause in the view.
Only give the view to the application folks - not the base table itself.
create or replace view my_view as
select * from some_table
where sysdate between effective date end date;
How about that??
Tom Mercadante
The aggregate function operates last, on a result set. Why I suggested
to suppress the GROUP BY is that then you would have seen that the
number of bytes from each datafile is returnedtoo many times.
If you have F1 and F2 associated to your database, with E1 and E2 in F1
and E3 in F2 (I hope the
Be aware that this script does not include autoexted info
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
You can't join DBA_EXTENTS and DBA_DATA_FILES based on an
equality of tablespace_name, and then add up the bytes of the files
for the tablespace.
ie.
select
b.tablespace_name,
b.bytes
from dba_extents a, dba_data_files b
where a.tablespace_name=b.tablespace_name
Try running that query, and
Jonathan,
You are welcome. Another time for the syntax table (partitoion) comes handy
is while dropping, merging or doing some other partition maintenance work.
This will quickly check is the partition is empty or not, othewise you have
to ge the hig values of the partition and one prior to it
So in this case I have to Create 50 Views, I am looking for some sort of
common rule the apply it for all of these 50 tables.
-Original Message-
Sent: Friday, November 14, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L
Hamid,
Create a view on top of the table and apply the
You
know, I never even considered a bottle of whiskey and some scantily clad
data.
I live
in shame.
Bambi.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Friday, November 14, 2003
2:25 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: How
1 - 100 of 120 matches
Mail list logo