Ciao a tutti, ho creato un nuovo DB oracle che ora viene caricato tra le
istanza di avvio del mio PC...
come posso eliminare definitivamente tutta l'istanza (Dati, DB,....)?
(ovvero i vari servizi eseguiti all'avvio: OracleDBConsole_MioDB,

              Can anyone tell me a query which gets all the parent
tables first and then child tables?
Any help would be appreiated.
TIA

On this page
http://www.adp-gmbh.ch/ora/sql/sys_refcursor.html
it shows a function that accepts a SYS_REFCURSOR as a parameter and
then does a

I have an Oracle database and they have given me a windows domain
account to access the DB.  With SQL Server, I need a DTS to use that NT
credentials and connect to the Oracle DB.  Have used OLE DB for both
Microsoft and Oracle and putting the credentials there, but it wont

Hello DBAs,
Pls I will like to have a full explanation on how I will export a
database running on oracle 8i on Windows XP platform to a new machine
running oracle 8i on a Windows Server 2003 platform.

I hope someone have a good idea to get it right:
3 tables
1)  user  (us)
  column:  user_id, state_name

Ok, I know that are old machines, but my company is migrating a "core
businness" application from a 24 procs S80 to a 24 procs E10K.
I am DBA of this project and I am convicted that I need a > 48 procs E10k to
substitute S80 without performance degration.

Is sga_max_size pre-allocated in memory at instance startup?
I can't seem to find a definitive answer from docs or the web. Some
suggest yes but only on certain OSs.
Thanks

Each,
Anybody point me towards good material on learning more about analytics
and aggregates.
Regards

Thanks!

what should i do to export the database fast?

I have written a procedure that accepts a SYS_REFCURSOR as an input
parameter and writes out the contents of that cursor using a FETCH and
DBMS_OUTPUT. This works great as long as you know the structure of the
cursor ahead of time.

I am running a 9.2.0.5 db with the compatibility ini param set to 8.1.0
and the optimizer_features_enable is set to 9.2.0.
After reading an article on asktom I found that you can count the
records for a column in user_histograms to determine if histograms have

I have a this SQL Statement
select DECODE ((SELECT MI.IND
from MAMA  MI
where MI.MBD =147193

It appears that sorting in Oracle only writes to one sort segment at a
time.  If an ORDER BY is executed on a large table, and if it will not
fit into memory for the sort, then temp sort segments are used.  We
have defined multiple temp files using locally managed.  While the sort