Hi,
No logical structures can be considered in the hot backup.. Tablespace backup, if u mean it in hot backup its purely putting the tablespace in begin-backup mode and taking the backup of the...
Type: Posts; User: balasubramanian.j; Keyword(s):
Hi,
No logical structures can be considered in the hot backup.. Tablespace backup, if u mean it in hot backup its purely putting the tablespace in begin-backup mode and taking the backup of the...
Hmm cool man,
To start with i can say that the database is divided into 2 structure:
1.Physical structure
2.Logical structure
Discussing abt physical structure: It has got 3 mandatory files(i...
Hi,
Hierarchy?? In wat aspect u expect the explaination to be?? In the administration part or in the develoopment or in the warehousing.? Or the basic Oracle Server hierarchy??
Just let me know...
Hello ssusmita,
U have to use the dynamic views to resolve this problem.
U can find the information abt the query package by v$sql or v$sqltext view. There it shows which session is executing...
Hi,
What are the types of checkpoints u like u change>??
HI,
I suppose u did not start the database.
Regards
Balasubramanian.J
Hi,
Materialized view is a also type of view. It is basically used in the datawarehousing environment. For generating report sort of thing this mat. view.
If to use the normal view, we need...
Hi thomas,
Even am not sure about this, but i like to share wat i know. There is something like hash algorith which is generated by oracle using the oracle hash algorithm , the basic and the...
Hi Tina,
The answer for "When SCN is generated?" It is getting generated when commiting a transaction. Purpose of SCN is to differntiate the commited and the uncommited transactions.
You can...
Hi,
Register the rest 3 databases in the catalog database.
Hope this helps
Balasubramaniana.J