I am learning SqlPlus and I wonder if there's a way
 to append the some of my SQL practice into the same
 file?
 I mean, I would like to something like the following

Is there a way in sqlplus to return the number of rows fetched every
time a select statement ends?  For instance:
SQL> select * from pets;  --pets is a small table with less than 20
rows

Can someone tell me how I can view a specific users permissions in
Oracle 8.1.7? I want to know all the tables a specific user has rights
to. Any help would be appreciated.

  I am planning to upgrade(migrate) from oracle (32bit ,solaris)
8.1.7.4 to oracle 64 bits 10g sometimes soon.
Just curious whether anyone using 10g on a unix system and
using the new "Automatic Shared Memory Management" and

o/s: HP-UX B.11.11
Oracle: 9.2.0.5
Applying the the 9.2.0.6 patchset and run into a weird relink error.
The installer runs a make which in turn runc cc and ld - and ld

What is the max datafile size recommended?
I have a Windows 2003 Server, with 6 145.5 GB drives acting as one
880GB logical drive.  If I need a tablespace to be 150 GB, is it best
for one 150 GB datafile or five 30 GB datafiles?  Or somewhere between?

  Do anyone or any good site has:
I need to find a better lock monitoring
scripts to get segment info, etc.
Thanks,

It seems I've searched for years on this one, on and off, but haven't
ever found an acceptable answer.  I have a table x with a single
composite index created on columns a, b, c (in that order).  I'm
interested to know HOW MUCH of the composite index a particular query

Is there a way, based on the number of records in a table, to figure
out an estimate on how long it would take to create an index?
This table has about 4 million rows, and the index creation time took
almost 20 minutes.

I am doing an import from a dump file that includes comments, like so:
ALTER TABLE "MYTABLE" MODIFY ("MYCOLUMN" DEFAULT 'N' -- this is a comment)"
This results in failure for any such line. I would like to avoid having to
do an 'imp SHOW=y" to get all statements like the above and ...

hello group... my requirement is to write a sql script, that will move
datafiles around.  basically, what i need to do (since we're using omf) is
retrieve the existing datafile location for a tablespace and rename it to
the new location, where i'll move it.  can i do this in ...

Howdy,
We are trying to run some scripts to give us some detail and stats on
our indexes.  Whenever we run the script though, we get:
ORA-00054: resource busy and acquire with NOWAIT specified

OracleStore (Canada English) has a reference to Oracle Application Server
Standard Edition One.  Visible on the 'User Minimums' pages, accessed by
clicking on any 'minimums' link.  
However, I can't find any other suporting info - any clues about this?  

How I can block a table, so that this is of read-only even for the
owner user? And that cannot be drop table, without having to use
trigers
Thanks

Oracle 10.1.0.4 EE running on 2 node RHEL 3 cluster (Oracle Firewire
Kernel)
Shared Storage :  Maxtor One Touch II
It seems that periodically the I/O to the shared device seems to 'hang