• Nologging
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>hi tom, I am a bit confused about nologging. I have a couple of object in nologging ,after a full database recovery , I found a couple of block curroption. investigation on the same revealed that those objects were created using nologgi...
  
  
• Difference between DB_NAME and Instance_Name
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Hi,If I use different names for db_name and instance_name in init file.I suppose ORACLE_SID=instance_name (OS variable).For all Alter database and Startup options use db_name.Where else these differences will matter.We are planning to Standb...
  
  
• dbms_job.submit
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Tom, I am required to run a procedure "analyze_user" at 9 AM every morning. For this I am submitting a job as shown below. BEGIN DECLARE v_JobNum NUMBER; BEGIN DBMS_JOB.SUBMIT(v_JobNum,'analyze_user;',sysdate,'sysdate +1'); c...
  
  
• when other than exception, and raise application error
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Tom 1. I have a procedure, where in I drop partitions every day and add partitions. My question is about the exception section. Do I have to give specific exception conditions to handle the erros which are possible while dropping and ad...
  
  
• Column-organized tables?
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  Hi Tom, Michael Stonebraker, co-creator of Ingres and Postgres - is pushing his new database that stores data by column. Here is the article - http://www.computerworld.com/action/article.do?command=printArticleBasic&articleId=9034619 Though I don...
  
  
• Raise_application_error procedure in AFTER LOGON trigger
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Hi Tom, I am trying to create an AFTER LOGON trigger to restrict logon form some terminals. Thats why I have created the following trigger. CREATE OR REPLACE TRIGGER afterlogon AFTER LOGON on DATABASE BEGIN IF sys_context('userenv','Term...
  
  
• How to Update millions or records in a table
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Good Morning Tom. I need your expertise in this regard. I got a table which contains millions or records. I want to update and commit every time for so many records ( say 10,000 records). I dont want to do in one stroke as I may end up i...
  
  
• TO USE BIND VARIABLE
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  hi Tom, I have posted this procedure in oracle forum but friends suggested the way i have coded is not a way i do coding in oracle. I should use bind variable and cursor. As far as i know, how can i use bind variable here with where clasue as my ...
  
  
• Intermedia text and indexing
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>Hello, When you use CREATE INDEX without explicitly specifying parameters, the system assumes that the text to be indexed is stored directly in a text column. The text column can be of type CLOB, BLOB, BFILE, VARCHAR2, or CHAR. The columns t...
  
  
• extracting data to a flat file.
  Sat, 17 May 2008 20:10:07 +0000, Ask Tom MOST RECENT ARTICLES
  <code>How can i extract data from flat file to oracle table with plsql ? </code>
  
  

Powered by Ask Tom MOST RECENT ARTICLES