Oracle

<code>I am currently using dbms_metadata to get VIEWS DDLs (in order to re-create them following a FROMUSER-TOUSER import; compilation errors due to in-text schema names). However, the generated file (spool) is full of carriage-returns which makes ma…

<code>Hi Tom, Is it still a good idea to keep indexes in their own tablespace? Does this inhance performance or is it more of a recovery issue? Does the answer differ from one platform to another? Thanks in advance, Tom </code>

<code>Tom, In order to tune the rebulding of an index I have experimented with the "REBUILD PARALLEL 6" option while rebuilding an index on a large table; e.g. "ALTER INDEX index_name REBUILD PARALLEL 6" Are there any side affects to using …

Hi Tom , I’ve been using this function in my code and after some testing, I’ve found that it returns NULL whenever it receives a NULL parameter. I was expecting this behaviour only when the first parameter was NULL since it determines the type of…

<code>Tom, In responding to a question you mentioned that when you take a cold backup in NoArchiveLog Mode, it is a bad idea to include redo log files, in case you later decided to put the database in archivelog mode. – I understand that if we ha…

<code>With earlier versions of the Oracle database a small webserver product was included that enabled one to write html with the htp and htf packages. Now it seems like Apache is included with the database but for use by the OEM product. Is there a …

<code>Would you happen to have a database feature comparision matrix between postgresql and oracle. I would really appreciate if you could provide me with one. thanks. </code>

Tom, Oracle introduces Beta version of Oracle 11g. What are the new features of Oracle 11g? Please compare 11g with the previous versions. thanks Regards, Dawar Naqvi

<code>Hi Tom Feels good to post a question after quite some time. Look at the following : SQL> desc dual Name Null? Type —————————————– ——– ———————…

Dear Tom, I need some help in implementing/understanding stored outlines..As per the articles provided from oracle,i understand that outlines will help in stablizing the exectuion plan across environments(test and production). Here are the steps th…