Oracle 8i / Solaris SPARC
We gather statistics about the tables with a pl/sql script that looks
like

I would to build a stored procedure that would be able to transpose rows
into columns based on a delimited list of keys.  Currently, I have a view
that accomplish this transformation, where a key is tied to an in-line view.
My first idea is to use a Record where I dynamically ...

Because this year is going to desupport (together with 8i) in few days
I wish you:
select max(happiness), max(health), max(love), max(luck),max(money)
from dba's_New_Year;

I tried to do output from pl/sql to a client's box, I tried using
dbms_output and it has a hard limit 1 Megabyte.  I tried UTL_FILE
package, but it can only output to a Server's directory.  How can I run
an PL/SQl and output to screen or a file in client's machine??  Thanks

I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000.
When I export a table from Access to Oracle using ODBC
I get error:
ORA 972 identifier too long

When I try to connect Oracle 10g throught Enterprise Manager, I obtain
the message "RemoteOperationException: ERROR: wrong password for user"
(because EM ask for host and database users) and I´m sure all are
correct, and I am logged on my W2003 with administrator (who installed

I'm looking for a solution for the following problem
We have about 80 table objects in one schema (Oracle 9.2) - called it
"Calc_Apps".
We created few roles for different groups of users (developer, tester,

I'm new to Oracle and just start learning, slowly. We recently moved our
Oracle 8 server which was on H drive of a NT server. I mapped in as H drive
as control file location. After the the Oracle was moved to D drive of the
NT server, I had trouble to access it from a client machine ...

SVRMGR> @alter_table_prod.sql
ALTER TABLE MYTABLE_NAME
*
ORA-00942: table or view does not exist

I wonder is there a list of topics/excel sheet/questions to be answered
or asked from vendor when you are choosing the correction database
software among like oracle/teradata/db2 etc... And now we are talking
about terabyte amount of data...

I have installed the Oracle 9iR2 Patchset (9.2.0.6.0 64 bit) on
Solaris 9 (Sparc 64). When running the root.sh script the output was:
root@S0292108# /SSW/oracle/product/9.2.0.6.0/root.sh                  
Running Oracle9 root.sh script...                                    

I would like to know what are the options available to move the data
may be as table  or together as database or a subsystem to another
database apart from Export/Import.
Thanks in advance.

I am newbie in Oracle PL/SQL.
I need to write a stored procedure which would generate xml and would
post to a URL. Stored procedure should also get the response returned
by the web server.

Can someone explain the Diff. between Redo Log Allocation Latch and
Redo Log Copy Latch.
Thanks in advance.

How do you know to what kind of item a particular synonym
is "pointing"?
All that the view ALL_SYNONYMS says is "table_name"
as a column for the referenced object...