Hi all ;
I have tried to find DB details using trigger. but i did not get any output amd also i am getting Trigger created with compilation errors.
SQL> create trigger trigger_db_hist
2 AFTER STARTUP ON DATABASE
3 begin
4 insert into db_hist(ins_no , ins_name , dbid , db_name , startup) values
5 (INSTANCE_NUMBER ,INSTANCE_NUMBER , DBID , NAME , STARTUP_TIME);
6 end;
7 /
Warning: Trigger created with compilation errors.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 104860292 bytes
Database Buffers 176160768 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
SQL> select * from db_hist;
no rows selected