Re: BDUMP, CDUMP and index problem

Umesh Choudhary wrote:

> Hi,
> I am new to oracle I would like to know few things from you.
> 1) In bdump folder we have trc file. How these files are different
> from those in udump folder. Can i delete trc files of bdump folders.

BDUMP is where the background processes stick their trace files. UDUMP is where Users stick theirs. It's a difference between background diagnostics that happen whether you like them to or not, and trace files which are produced as a result of a specific user request.

> 2) In cdump folder we have ./core files. I would like to know what is
> the use of these files and can I delete these files.

God knows what use they are. Last time I checked, Unix systems were allegedly robust, reliable and never crashed (producing a core dump).

If you are fluent in Hex, feel free to browse. If you are but merely mortal, feel free to delete.

> 3) I have a mount which is 100% full and on the same mount I have
> index datafile. Now since this mount is full indexies are not getting
> create. Now how should i add a new index datafile in some other mount
> which has read, write and execute access and how should we point new
> entries in these new index data file. I should able to access data
> from old and new index files

What?

Alter tablespace IDX add datafile '/wherever/whatever' size 000M;

The 'wherever/whatever' can be any valid path to wherever free disk space happens to exist.

Once the new datafile exists, Oracle will use the space it provides to any existing index that needs it.

Have you visited http://tahiti.oracle.com. It sounds like you could use a visit.

Regards
HJR
> waiting for your reply
>
> Regards
> Umesh Choudhary
Received on Mon Aug 30 2004 - 01:53:05 CDT