 | | | Oracle List | | Do you have any reference? Where can I find that in the literature?
On 02/25/2004 02 37 33 PM "Bobak Mark " wrote
> Dan
>
> Only an INDEX FULL SCAN (walks the tree does single block reads)If the security folks don 't like .netrc they 're sure to dislike .rhosts
and the r* utilities.
ssh would be better.
Jared
"John P Weatherman " <asahoshi@(protected) >
Sent by oJuan
One of the best methods for getting peer reviews of your paper is
to submit it for publication.
I would be glad to submit it for possible publication in the IOUG Journal
SELECT if you On 02/25/2004 01 24 50 PM "Levesque Roger I. CTR WHS/PSD " wrote
> Yes. What happens is because I cannot logon to sys it won 't let me make
> the change which is a kind of catch-22. I am lowho saiys that stored outlines interfere with the CBO? its a tool provided by oracle. it has uses but its not a cure all.
you have to decide whether its appropriate for your case and if so which My advice is to use JFS for database files because on 9.2.0.4 you can
use direct I/O which is supported by JFS. As far as the big files are
concerned JFS supports them without any problem.
On This doesn 't sound right to me in fact it sounds backwards.
If an incoming SQL statement is found in the library cache then that
is evidence that it is syntactically and semantically correct. Thank you very much for your help Ron David Thomas.
When I typed !host then my current directory is pointing to another
directory.
Talked with our sysadmin and he changed my group perms.
>From the SQL > type !host to get out of sqlplus and into the OS. Then
type pwd to see where you are. It may be that you are not in your home
directory and do not have permissions to write to the dHowdy list.
For those of you who migrated a database from 8i to
9i did you move convert to undo tablespace
immediately? Did you run for awhile still using
rollback segments then convert later? Paula
Probably the easiest thing to do is to continually run Rman Archivelog
backups while this process is running to keep the archivelog disk clear. If
you are not using Rman then run your noAlerted by Cary 's comment about the application tracing changes I went looking
for the changes in DBMS_SUPPORT and DBMS_SYSTEM (for SET_EV) but thise two babies
are not in PL/SQL types & package maSo
Oracle 9i
-Vendor is converting data. Their conversion process used 2Gb of space in archivelogs in one hour. Of course we could turn off archiving but then the redo logs get overwritten.
Hi here is the most basic about statistic I would like to know if some one
has experiece about the advangates of using
EXEC DBMS_STATS.GATHER_SCHEMA_STATS( OWNNAME > 'ADM '
ESTIMATE_PERCENT >100 MI believe the sdk is still available independent of collaboration suite.
I played with ifs before it became a separate product requiring more $$$.
In my experience it was VERY unstable...as are Or try to truss sqlplus and see where it is attempting to open the
afiedt.buf file. Alternatively convince your SA to assign you uid 0.
That way you 'll have no problems with file protection. This Melanie when a developer needed to bring data to a Visual Basic program his
books indicated that the version of VB he was using did not support
Reference Cursors or any Rowtype collections howeverR. Rangadoure
You are not finding the new record because the Java program is establishing
a new connection to the database - it is not a part of the current
transaction. Since it is a new conneChris
What would happen if the RMAN backup failed and the next step is executed? The archlogs over 2 days old would be deleted?
You can have rman perform the archiveing of the archivelogs and deletOn 02/25/2004 10 57 05 AM "Koivu Lisa " wrote
> Thanks Rich... You always provide excellent comments from the land of
> cheese. )
>
> Lisa
Indeed blessed are the cheesemakers.
-------That is because triggers don 't see the current version of the table. Had
you tried with PL/SQL you 'd have recieved "table mutants " or "mutating table "
error. Interesting that Java lets you circumveWith Windows? Yes. Theoretically you 're not but then you
have a 64-bit version of BSOD which kicks in after 2GB.
On 02/25/2004 07 36 55 AM Jeffrey Beckstrom wrote
> Currently running 32-bit wiI believe there is /usr/bin/perl on both systems. You can
use it to massage the output any way you want. I don 't have
bdf output but if you post a little template I can work out
the script rather IIRC I have seen this when the delay_seconds in the push call to dbms_defer_sys package had a large value and is not the default of 0.
-Fairlie
Shivaswamy Raghunath <shivaswamykr@(protected) > wroLet me restate the problem so that we may compare apples with apples...
When using SQLPlus (or other tools) there are 3 parts
INPUT EXECUTION OUTPUT
NMelanie
I worked with Progress in 1991/92. There were no REF cursors at that time (Version 2 or 3). SQL
interface to it was pretty basic from what I remember. I always preferred their own 4GL lanPrecreate the table with the structure you like and use INSERT /*+ APPEND */
command to populate your table afterwards.
Tanel.
----- Original Message -----
From "Mark Richard " <mrichard@(protected)I used to be able to go to updates.oracle.com and ftp patches to my Unix servers. But now when I go there it can 't login? Used to be that my metalink login worked. My metalink account works and I canThe only practical way to do this that I can think of at the moment would
be to have the offsite DC dump the RMAN repository for you via exp.
Import the repository and import the tapes into the No. OMF does not let you name datafiles. If you read the
documentation it states that it assigns a guaranteed unique name to the
datafile.
Does 'drop tablespace including contents and datafile |
|
|
