OracleBlog

That was funny :)
 

how long does the catproc.sql take
 

Hi, i am really, really, new at HTMLDB and want to know the best way to learn the program. Also i have been trying to research validations and can't seem to find easy explainations for them (i just get course overviews)

pls help :{
 

Hi,

I didn't find out how to post question in ask tom home page, How can I join and ask question?

My question is: Can I create physical standby database using 10.1.0.5 for 10.1.0.2

Thanks
 

Hi Tom,

I have a question.
I have a procedure being called by a web page. if the procedure is in MSSQL then It work fine and data is returned to the web page but if the same procedure is in oracle 10g, it shows the inconsistent behaviour. it sometimes returns the data to web page and sometimes did not return any data and the page got freezes. Please let me know what might be the cause or its something related to oracle 10g.

Thanks
Paramjit
 

sigh.

THIS is not Ask Tom. This is an article ABOUT Ask Tom.

If you have a question for Tom, go to Ask Tom.

Of course, if you can't even find his web site, I'm not hopeful that you'll be able to solve your problems.
 

yes, this was so funny from Mr. Tom.

By the way I liked your blog Mr. Robert
 

question about logmnr i am not getting any output
i am doing as follows:--


log in as sysdba

create table,

insert some record ,

delete some records


alter sysytem set utl_file_dir='c:\oracle\oradata\one' scope=spfile

exec dbms_logmnr_d.build('test1.ora',c:\oracle\oradata\one');
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo01.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo02.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo03.log',dbms_logmnr.new)
exec dbms_logmnr.start_logmnr(dictfilename=>'c:\oracle\oradata\one\test1.ora')
everthing thing is going fine excepts no out put from v$logmnr_contents
where i am doing mistake
answer i am getting ''no records found'
 

question about logmnr i am not getting any output
i am doing as follows:--


log in as sysdba

create table,

insert some record ,

delete some records


alter sysytem set utl_file_dir='c:\oracle\oradata\one' scope=spfile

exec dbms_logmnr_d.build('test1.ora',c:\oracle\oradata\one');
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo01.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo02.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo03.log',dbms_logmnr.new)
exec dbms_logmnr.start_logmnr(dictfilename=>'c:\oracle\oradata\one\test1.ora')
everthing thing is going fine excepts no out put from v$logmnr_contents
where i am doing mistake
 

question about logmnr i am not getting any output
i am doing as follows:--


log in as sysdba

create table,

insert some record ,

delete some records


alter sysytem set utl_file_dir='c:\oracle\oradata\one' scope=spfile
alter database add supplemental log data;

exec dbms_logmnr_d.build('test1.ora',c:\oracle\oradata\one');
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo01.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo02.log',dbms_logmnr.new)
exec dbms_logmnr.add_logfile('c:\oracle\oradata\one\redo03.log',dbms_logmnr.new)
exec dbms_logmnr.start_logmnr(dictfilename=>'c:\oracle\oradata\one\test1.ora')
everthing thing is going fine excepts no out put from v$logmnr_contents
where i am doing mistake