Tuesday, July 25, 2006

Ask Tom

In keeping with the theme of my most recent post, I just couldn't stop laughing at Tom's most recent response to a question about recursive sql.

Comments:
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
 
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?