Search:

But it should not stop the database. have you checked in the alert log file what message is coming there?

i think i have replied it

No it is not needed you can create a temporary tablespace no issues.

Yes we can export a tablespace make the concerned tablespace read only so that no write operation is taking place an then export it.

No it is just a configuration file which oracle reads to configure the instance

Yes if you search the google a lot many books comes. but i am giving some name of the books that may be helpful to you. if you wants certification in oracle 9i then you should read oracle press books...

I dont think it can be done through sql query, but it can be done through java jdbc programming which can extract all the predefined functions and display them

When you update the Oracle Server in some way, that update should initially be regarded as tentative only - tentative in the sense that, if something subsequently goes wrong, the update may be...

Actually there are three layers in the shared pool, these are
Library cache, Data dictionary cache, and control structures
as you are well aware with Library & data dictionary cache,
the control...

See creation of indexes are fine in some situation i.e when the data retrival from the table is less than 5%, otherwise a FTS is occuring there is no need of index.

unique index and index is...

Try to search in google

Crash can be media crash or instance crash in media crash the hard disk containing the files is crashed or due to some error in the read write head. And instance crash means crash due to power...

Backup of database can be taken in hot mode or cold mode in cold backup the database is shutdown properly and then backup of datafiles and controlfile is taken, but in hot bakup the database has to...

Decompose a table or index into smaller, more manageable pieces, called partitions. Each partition of a table or index must have the same logical attributes, such as column names, datatypes, and...

First go for..

analyze table tabe_name compute statistics;
and then give
select num_rows,blocks ,empty_blocks as
empty,avg_space,chain_cnt,avg_row_len from dba_tables
where...

The SLEEP procedure suspends the session for the number of seconds specified in the seconds parameter. Sleep periods can be specified with accuracy down to the hundredth of a second (e.g., 1.35 and...

Most database applications do a specific job. For example, a simple program might prompt the user for an employee number, then update rows in the EMP and DEPT tables. In this case, you know the...

The datatype in a declaration can either be constrained or unconstrained. A datatype is constrained when you specify a number which constrains or restricts the magnitude of the value which can be...

The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for...