The session is rolling back, you can't kill it.
This is why the serial# is changing.
The following query can be used to track its progress.
select s.osuser
,s.username
,s.sid
,r.segment_name
,t.space
,t.recursive
,t.noundo
,t.used_ublk
OK - This is of no real need for me, so I'm not going to RTFM :P I thought
I'd just ask..
When using the compress=y option on an export to import a table of 500Mb to
an LMT with a UNIFORM EXTENT size of 100Mb, will it import the table in to 5
extents of 100Mb - or one of 500Mb?
My thought would
--Boundary-00=_9KJR12S0
Content-Type: Multipart/Alternative;
boundary=Boundary-00=_9KJRBHK0
--Boundary-00=_9KJRBHK0
Content-Type: Text/Plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi List,=0D
Jeff,
Sorry, I didn't read your original email properly
(geez, I hate it when I do that) and now I see that
you're getting this error on creating the snapshot,
not refreshing it, so my previous answer won't help
you much.
What versions are the db's involved? If the master
site is not 8.0.6 or
Hi all,
I got one problem about UTL_FILE_DIR.
My oracle version is 8i 8.1.6
Platform is unix sun solaris.
I have set UTL_FILE_DIR to : /customer/ShopA
and I write PL/SQL code to write a log file (A.txt )into /customer/ShopA
When I execute the PL/SQL job through SQLPLUS,
I hit error message
Exporting an individual schema within APPS (GL /PA etc)
is not recommended due to the number of constraints that cross schemas (to fnd
tables for instance).
So
changing the block size is essentially non Apps specific and is just a straight
export /import.
Depending on your hardware and plan
Dennis,
I believe that Note 73974.1 - Restoring and RMAN Backup to Another Node
has the details you are looking for.
Essentially, when you need to recover to another server that does not have
mount points or file systems directory
names that match in name and size, you need to rename your
Dennis,
And even if there is a problem with the Rman trying to use a link, pointing
to another directory, you can always create a new mount point /ora01 on the
box provided to you, right? I think what you are trying to do is very
feasible and covered within the Oracle docs.
Hope this helps.
It seems to me, I remember something like this. If I do remember correctly,
you need the execute permissions for the directory, so it would need to be
775.
Terry
-Original Message-
Sent: Monday, December 03, 2001 5:40 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I got one
if I set UTL_FILE_DIR = *
would there be any security issue ?
In a word yes...this allows read/write access to *all* directories and there
is bound to be particular ones you don't want people to see.
-Original Message-
Sent: 03 December 2001 11:40
To: Multiple recipients of list
Mark,
The COMPRESS=Y option is basically used to combine multiple extents into a
single large extent while importing...it is useful when u r trying to
defragment the segment.
If u export 5 extents of 100MB using this option, it will b imported
as one single extent of 500 MB which means that
Title: RE: Deleting files on w2k
Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there... I'm stuck with this one.
-Original Message-
From: Kimberly Smith [SMTP:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 4:25 PM
Title: RE: Deleting files on w2k
Go
with Linux. That way you could use your same servers:-) Ain't I so
useful! HA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent:
Monday, December 03, 2001 6:20 AMTo: Multiple recipients of list
Title: RE: Deleting files on w2k
Unlike
UNIX, NT will not let you delete a file while another process (ie.
Oracle)has got a hold on it. I assume Win2K is the
same.
-Original Message-From: Koivu,
Lisa [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001
14:20To: Multiple recipients of
In particular,
declare
f utl_file.file_type;
begin
for i in ( select name from v$datafile
order by file# desc ) loop
f := utl_file.fopen(
substr(i.name,1,instr(i.name,'/',-1)),
substr(i.name,instr(i.name,'/',-1)+1),
'W');
utl_file.fclose(f);
end
Jared
Say, process A is interested in reading a block, then it hashes the data block address of the block to find the hash bucket in the buffer cache. If that specific block is in the buffer cache, then it must be attached with that hash bucket. Holding the hash bucket latch, the process A
Title: RE: Deleting files on w2k
Hi,
We have to performance benchmark test for our application .
We have to check only scalibiliy and performance and not much concern for
reliablity.
We have 10 36G hard disks(Fiber Channel array) and 2 18G(Internal boot
disks).4 400MHZ cpu's
Expected
Connor,
Can you please test your code before posting ;-)
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Connor
McDonald
Sent: Monday, December 03, 2001 9:00 AM
To: Multiple recipients of list
Title: RE: Deleting files on w2k
You are! The problem is, by going with an os other than windoze of some sort, I am almost guaranteed that the production hardware and software support will be outsourced moved to Denver, CO to IBM's datacenter there. This stupid company believes in paying ibm
Bambi,
Excellent one. Great. Printed it and filed in my personal file.
Rao
-Original Message-
Sent: Friday, November 30, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Dennis --
I sent Kimberly my tips offline (and my resume) but thought I would forward
my tips based on
The Logical Standby Database is listed in Oracle 9i's New Features
documentation on Technet, but there is nothing about it in the actual Data
Guard manual that I have found. Maybe it is a 9.0.2 feature as someone else
already indicated.
Best,
Ed
- Original Message -
To: Multiple
Title: rman restore arclogs
Good morning all -
I've been practicing rman restores. It's a lot easier than I originally thought. I've noticed that when you restore and the arclogs are needed, it restores them. Which is expected. However, when I take another backup, these arclogs are
Hi
v$controlfile_record_section is based on the fixed table x$kccrs. This does provide values for all the columns except maxlogmembers. Here is the query to pull the information..
select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY') , rsnum from x$kccrs
All right, Here is the complete query to get the information from the control file.
select
decode (indx, 3,'MAXLOGFILES',4,'MAXDATAFILES',2,'MAXINSTANCES',9,'MAXLOGHISTORY
') , rsnum from x$kccrs
where indx in (3,4,2,9)
union all
select 'MAXLOGMEMBERS ',dimlm from x$kccdi
/
Thanks
Riyaj Re-yas
Hi Friends,
I need to clean Oracle8 database size 3Gb on one of my NT server, Is it
possible that shutdown the database and delete all datafiles and all
directories??? Or Is there any other way to clean all files and
directories?? I appreciate all suggestions and responses.
Thanks in
All:
Has anyone service level agreements with theirdDatabase users and would be willing to
share some
information? I am in the processing of creating SLA with my Oracle database users and
am looking
for templates.
TIA
--
Steve,
We have a three 420R boxes, two 450 boxes, three 6500's. Each of our 420R's
configuration is --- 4 cpu's - 450 MHZ, 4 GB RAM. We are using 420R boxes
for our development. We have Oracle 817, WebLogic 6.1 and some middle tier
software loaded onto these 420Rs.
These 420R boxes come
8.1.7
I am loading an input file to a single DB table. The input file is
different than the table I'm loading and contains fields I don't need to
load. I do not want to load some of the input fields. The input file has
11 cols. and I need to ignore 5 of them. The DB table has 15 cols and I
The database in question is cloned so I don't have to worry. Thanks! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 30, 2001 12:16 PM
If you genuinely clone a database ie copy the
datafiles, then the stats will also be
Can you please tell us which version of NT you are working on??
also throw some info about type of database, number of users (generally as
well as concurrently)??
if possible, give a brief description about the character of your SYSADMIN???
regards
***
Binay
Hi, Could any one show me how to write the following
function? Thank you very, very much!
The GPA Function
1. A GPA is calculated in the following fashion:
Assume a student receives
an A on a 3-credit_hour course and a D on a
2-credit-hour course. His grade
is (4*3+1*2)/(3+2)=2.8.
Title: RE: SQL Loader Input File Situation
Don't include them in your control file.
-Original Message-
From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL Loader Input File Situation
8.1.7
I am
Well I think it's time for you to start reading papers discussing OFA
(Optimal Flexible Architecture).
http://technet.oracle.com/doc/oracle8i_816/linux_816/unixdoc/a82848/a82846/a
ppa_ofa.htm
The above link is for the LINUX OFA document, but the concepts are the same,
and you will probably find
Enabling parallel=2 or higher on this table could resolve the problem for
the original poster.
Regards,
Waleed
-Original Message-
Sent: Saturday, December 01, 2001 9:20 PM
To: Multiple recipients of list ORACLE-L
Malcolm,
The paragraph below would indicate that readers are
I have
just started a project and have encountered a database problem. The previous DBA
did not create any backup scripts or backup and recovery plans.
Is there a way to get around this problem without
re-creating the database?
When
executing my script to get corrupted data block
Hi Jared
why does the serial# have to change due to rollback?
lots of us would be curious for a brief expln ...
Thx
Deepak
--- Jared Still [EMAIL PROTECTED] wrote:
The session is rolling back, you can't kill it.
This is why the serial# is changing.
The following query can be used to
_delete_me=true
__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: [EMAIL PROTECTED]
Fat City Network
All,
I have the install disks for 8.1.7 for Sun SPARC Solaris.
Are these disks (2 of them) the same for Sun 64bit?
I looked on TechNet, and I do not see any other 817 release for Sun.
I do see, however, 64 bit for Oracle for 9i.
Thanks!
Tom Mercadante
Oracle Certified Professional
--
Raghu,
By shutting down the database and stopping the listener, you can delete all
the data files and directories without a problem. This will remove your
database.
If you want to remove Oracle8 software, that will require purging the
registry. I don't think I have ever successfully
Hi All!
We had an interesting sequence of events last night, and I was
hoping somebody could tell me if what we saw was what should've
happened. Clear? As mud? Ok...
System is up and running.
The backup process starts, and puts the datafiles in backup mode.
The system crashes. Hard.
Lisa,
We backup all archivlogs with the backup set and delete them. Delete is an
rman option when you backup archivelogs. We don't have room to keep them.
It is a bit of a pain to restore them but you learn to live with it.
Have a look at rman's tables and views. You should be able to query
Does he think - UNSUBSCRIBE?
:-))
On Mon 3. December 2001 18:55, you wrote:
_delete_me=true
__
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ:
Removing Oracle on NT (or any Windoze for that matter)
1. shutdown all oracle services (db, listener, etc.)
2. use the oracle installer and deinstall everything - this gets rid
of a large portion of oracle
3. use regedit and remove the key HKEY_LOCAL_MACHINE\software\oracle
4. search the
Raghu,
If you just want to delete one oracle database from an NT machine, do as you
suggest - delete all of the files (control, log, data), init.ora, and any
directories that held these files. Then, be sure and run ORADIM -delete
{sid} to remove the instance from the registry. That should do
Howdy,
I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
determined the query was not using the indexes I
I have just done installation of 8.1.7.0 on a Compaq
Tru64 Unix box and applied 8.1.7.2 patch. There were no installation errors.
When I start svrmgrl I see a line "inst emulated pid=175364...".
--$ svrmgrlinst emulated pid=175364 svrmgrl
va=0x11fffa358 pc=0x1205c0148 inst=0x327e0028
Your error message indicates file #1 associated with the system tablespace and the trace file indicates the file #6. I would do the following
1. Check the OS error message for any hardware errors.
2. Find what objects are corrupted. To get this information use dba_extents and the given
Title: rman restore & arclogs
Lisa,
I
guess I'm lazy (or cautious) in that I would allow the first backup to take this
archive log files back to tape where they belong, rather than determine (by
running reports) which log files I may delete (by hand).
The
cautious part of me says that if
Carle, William T (Bill), NLCIO wrote:
Howdy,
I have a query which was taking an extremely long time
to complete. The OPTIMIZER_MODE in the init.ora file is set to CHOOSE,
meaning it will use the ALL_ROWS method to determine its access paths. I
Title: rman oddities
Hi Ruth, thanks so much for responding.
Yes, I wrote the scripts to do an arclog backup delete. I'm concerned about the arclogs hanging around after a restore and taking up disk space, along with unnecessarily inflating the size of my backup files. (I'm testing backup
Howdy,
I have a query which was taking an extremely long time to complete. The
OPTIMIZER_MODE in the init.ora file is set to CHOOSE, meaning it will use
the ALL_ROWS method to determine its access paths. I determined the query
was not using the indexes I thought it should. When I changed to
Kevin Bass wrote:
I have just started a project and have encountered a database problem.
The previous DBA did not create any backup scripts or backup and
recovery plans. Is there a way to get around this problem without
re-creating the database?
When executing my script to get
Thanks for the explanation. I usually try to avoid delving
that deep into the internals, but I guess it's necessary on
occasion just to understand what's going on.
Jared
Anand,
I installed the same(?
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get this
result. However, I do remember this kind of result with a earlier upgrade
to 8.0.x in the distant past. I believe it is a verbose linking option
with no negative impact. Is svrmgrl the only
Bill,
Besides statistics and how they are gathered, and other information, there
are numerous parameters that influence the CBO and it's decisions. And just
to clarify, you said the query ran in under a second when using FIRST_ROWS
(and thus a nested loops indexed lookup approach if possible).
NO, no no... it is Holy Unsubscribe Batman!
-Original Message-
Sent: Monday, December 03, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Gee, how do I unsubscribe? Oh-yeah! Its at the bottom of every piece of
mail!!!
Holy Cow BatMan!
To REMOVE yourself from this mailing
Title: RE: rman restore arclogs
Thanks Tom. I did try removing the arclogs and then running a backup - no complaints. The arclogs in question were still present in the catalog via past backups. I'm guessing this is because the last scn of the last backup was larger than the scn's included in
Hi
The following files are backed in hotbackup right?
-Switch the current log
-take the structure of database by alter database backup controlfile to
trace;
-Data files (ALter tablespace begin backup and
ALter tablespace end backup )
-All parameter like init.ora,listener.ora,tnsnames.ora and
1. ping fbsrv to make sure the host can be found
2. it should be 'export DISPLAY', not 'export $DISPLAY'
3. make sure that an X server is running on fbsrv
how to test this varies from system to system. If you
log on to the box in a graphical environment, then
X is running.
HTH
Jared
Title: rman restore & arclogs
I just
wanted to throw something else out there - it may have already come up
though. We backup the archivelogs first without deleting them, and then
immediately backup another set with the "delete" specified. Obviously,
this is because anything can happen to
Mark,
With an LMT using UES of 100M, you will get 5 extents.
Jared
Mark Leith
Title: RE: FIRST_ROWS vs. ALL_ROWS
Hi Bill,
It's been a while since I messed with the optimizer but I'll take a stab.
FIRST_ROWS is for something like forms, where returning something quickly, even if it is just a few rows, is important.
ALL_ROWS is meant for throughput. The execution
Rao, Maheswara wrote:
Tom,
Yes. Oracle 817 comes in two disks. Installation is little tricky. The
best way, I found is, copy both the cd's onto two different locations on the
disk. Then start the installation. Once, the first file is over, it asks
you for the second CD. Then, you give the
Deepak,
To be quite honest, I can't remember. I'm like that with details
sometimes.
I tend to forget them, though I remember the reason I learned them in
the first place. :)
This is on MetaLink somewhere if you care to look for it. I really
can't do that now. It's back to the grindstone
When you have finished the restore and open the database with resetlogs, all
of the old archivelogs are toast anyway. Just delete them!
You can manually delete any orphaned backupsets. If a backup fails then you
need to redo it until in completes so that it will be recorded in the
catalog and
Tom,
Yes. Oracle 817 comes in two disks. Installation is little tricky. The
best way, I found is, copy both the cd's onto two different locations on the
disk. Then start the installation. Once, the first file is over, it asks
you for the second CD. Then, you give the file path where you
I have attempted a full export and received the following message:
[/u03] $ exp system/password full=y rows=y file=full.dmp
Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connected to: Oracle8 Release 8.0.5.0.0 -
Seema,
You do not need to switch current log file at the beginning of your job.
You switch the log file before taking the copy of archive log files.
Generally, listener and tnsnames files copy is not required.
Overall the steps you outlined are ok. But remember at every step to check
for the
Hi all,
Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):
Location: Chevy's at Howard and 3rd.
Time: 7pm onwards at the bar, sit down at 8pm
Contact: Gerardo Molina/John Kanagaraj (table booked in Gerardo's name)
1. Rachel Carmicael
2. Kirti Deshpande
3. Gerardo
On NT LAN use the NET SEND command.
You can send to individual user names or domain wide
or to those that have connections to the server.
HTH
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original
Mike
I found a note on metalink (124568.1) which explains the
reason. Oracle 8.1.7.x products are not supported on chip prior to
EV56.
Thanks.
Anand Prakash
[EMAIL PROTECTED] 12/03/01 12:40PM
Anand,
I installed the same(?
8.1.7.2.1) patch about 2 weeks ago on Tru64 5.1 and did not get
Title: RE: rman restore arclogs
Interesting. Does rman ever get confused during a restore or does it just grab the most convenient backup set with the required archive logs on it? I don't suppose you can parallel restore your arclogs from different files/tapes? (There goes that monkey again)
WOW ( or should I say OOW) it's like a
List of Oracle HeavyHitters and Cognoscenti.
-Original Message-
Sent: Monday, December 03, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Just a reminder once again for those listers meeting at OOW tomorrow
(Tuesday):
Location:
William,
Thanks for the update.
Rao
-Original Message-
Sent: Monday, December 03, 2001 3:15 PM
To: Multiple recipients of list ORACLE-L
Rao, Maheswara wrote:
Tom,
Yes. Oracle 817 comes in two disks. Installation is little tricky. The
best way, I found is, copy both the cd's onto
Title: RE: Corrupted data blocks in tablespace SYSTEM
Kevin,
Try exporting your schema owners (code, tables, etc.) as a CYA. When you recreate the db, you can import each schema separately. A pain, but it will save you.
Lisa
-Original Message-
From: Kevin Bass [SMTP:[EMAIL
Hello all,
could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a
minuteona table with 50,000 rows
and about 21 mins on a table with 235,000 rows??
Ihave created a
bigger rollback segment to take care of this, but no improvement.where
should i be
Nookala, Sunil would like to recall the message, Message at the start of
svrmgrl.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
Hello all,
could someone please tell me why the procedure
below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21
mins on a table with 235,000 rows??
i have created a bigger rollback segment to take care of this,
but no improvement.where should i be
Sangeetha,
1. During creation of tablespace, if you make it online, then, tablespace is
available for use immediately after its creation. Otherwise (offline), you
need to issue a separate statement making the tablespace online after
tablespace is created.
2. Yes. You could store two different
Hello again,
I want to thank everyone for responding to my query. I have a much
better understanding of how this works now. I changed my query to remove the
rownum 5 and the query returned 344066 rows. The output of the tkprof is
below:
FIRST_ROWS
call count cpuelapsed
Title: RE: Message at the start of svrmgrl
Did you trace the statement? Send a trace to the list.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Message at the start
I am working on a control script that I have restricted to only loading 5
records as a test. Basically I am taking data from the load file and
putting it into a table SQL Loader runs and gives me this.
-
SQL*Loader: Release 8.1.7.0.0 - Production on
Kevin Bass wrote:
I have attempted a full export and received the following message:
[/u03] $ exp system/password full=y rows=y file=full.dmp
Export: Release 8.0.5.0.0 - Production on Mon Dec 3 15:3:21 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connected to:
Ken,
Check the Loader log file. The records are being rejected for some reason
and Loader only tells you in the log.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
Sunil,
If there are multiple
duplicates foreven a few SKU_Num values, you're doing multiple scans (full
table or full index) to get all the dups out. You might reconstruct the
SQL to not use a looping construct if there are lots of duplicate rows for each
SKU_Num
Delete From
FMS_Test
Thanks,
Waleed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
yeah Jared, i will look at it. C i am wondering that
if the SID is sufficient to gaurentee uniqueness ..
why does oracle need the serial# as well??
or maybe there is a scheduled maintainance window at
this time inside of my head ;)
Thx anyhu ;)
Deepak
--- [EMAIL PROTECTED] wrote:
Deepak,
Michael
i remember (long time back) they had released a new
command called as alter database .. end backup or
somethin in 7.3.. maybe this is the default behaviour
in later releases including 817
Deepak
--- Vergara, Michael (TEM) [EMAIL PROTECTED]
wrote:
Hi All!
We had an interesting
Haven't heard myself, but I hope this is true. Please, please, please
let it be true!
--Scott
Khedr, Waleed wrote:
Thanks,
Waleed
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the
Andrea,
Here is a version of the function you asked for, IT IS NOT WELL
TESTED, should give you something to go on.
Scott Crabtree
FUNCTION calc_avg (student_id IN NUMBER)
RETURN NUMBER
AS
CURSOR student_c
IS
SELECT snum
|| call# class, credit, RTRIM
Hi All,
I have a question on dba_ts_quotas.
User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
tablespaces. And, I expect that the relation/quota
would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
for this schema. I checked for other
schemas and they showed
We have a slightly differnt apprach for this ..
1.
cp arch files to arch history location (stage 2 days
worth achives on disk. there is a cron that fires
everday and deletes all files from hostory arch
location which are two or more days older)
2.there is a script that invokes rman to backup
List,
I am sending email from the database.
I have UTL_SMTP setup which works fine.
However in the message field I would like to query a table (using
a select)
rather than a hardcoded
message.
Not sure how to do this though.
Anyone got any pointers will be greatly appreciated.
Why???
-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re
Haven't heard myself, but I hope this is true. Please, please, please
let it be true!
--Scott
Khedr, Waleed wrote:
Thanks,
Waleed
Found it:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1011386.6
Jared
Deepak Thapliyal
Rumor is that there will be a perl engine in the database instead of Java
one.
-Original Message-
Sent: Monday, December 03, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
future re
Haven't heard myself, but I hope this is true. Please, please, please
let it be true!
--Scott
If you check DBA_SYS_PRIVS you will likely
find that the user has 'UNLIMITED TABLESPACE'.
Probably due to granting RESOURCE to the user.
Jared
being a dba is kinda fun. Once I actually got to start doing it, that
is.
Look Lisa, you keep that to yourself.
Under no circumstances should you *ever* let
a manager hear you say that.
JARed
Hi,
If you alter the quota for a user to zero bytes on any tablespace, it will
not show up in the dba_ts_quotas for that user. In your third query, in
which schema the table was created?
HTH,
Quamrul
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
Hi all,
What is OAS ?
Thx...
1 - 100 of 126 matches
Mail list logo
