Recent content by parbhani

Oh great ... and quick ...... Am I correct in saying that before I do the steps you mentioned, I set the environment veriable ORACLE_SID to "DEMO" ? One more question, did you create the script you mentioned with , alter database backup controlfile to trade ?? Thanks again.

Hi Guys, We have a MS-Access based application. Its growing a lot and we are slowly thinking, what if we migrate it to some bigger RDBMS ? So, as usual there is a question. Should we go to Oracle or Sybase ? why ? why not ? The application is modarate on with say 500 to 1000 inserts a day and...

Hi all, I am not a very expert Oracle DBA. I have all the data files from a Oracle database which we have stopped using a long ago and does not exist. Also I do not have the control files, just all the data files. If I have to create the database just from the data files, what steps I need to...

Hi all, Whats difference between Character set and National Character set of a database ? The question came to my mind when I was trying with LOBs and was trying to understand the difference between CLOB and NCLOB. Please guide. Regards

Hi there , I may look like a fool , but , v_32k VARCHAR2 (32767); I cannot understand this. I never tested the limits of varchar2, but assume that it should not grow beyond 4000. Please explain. Also convey the Oracle version you are on. regards

HI there , I do not know which version of Oracle you are using. You cannot do such thing with LONG column, unless you write a pro*C program, get the data in a c-veriable and find with strstr function or use Java in similiar way. But with Oracle 8i and onwards you can do all such thing with LOB...

Hi, The application is not too huge of transactions, but still 1000 to 2500 inserts a day and reasonable updates. We have enterprise license for Oracle. Is MySQL really free for professional use ? I heard/read sometimes in past that MySQL does have some problems with very large and complex...

Hi Guys, We have a MS-Access based application. Its growing a lot and we are slowly thinking, what if we migrate it to some bigger RDBMS ? So, as usual there is a question. Should we go to Oracle or Sybase ? why ? why not ? Your opinions and experiances are most valuable. Regards

Hi Guys, I need help ... come ooooon ....

Hi All , I have a strange problem. There 2 programs, which run one after the another, once a day. First one inserts records in a table ( may be between 3000 to 5000 records each day ) and another update on the table. The second program which updates, starts running immediatly after first is...

Hi all , I have landed in a slight confusion over the value of "number of locks", we get in sp_configure. What does that indicate ? Does it give the number of locks, which can be made in that data server ( at any given point of time for all possible objects in the data server ) ? Or it gives...

Hi there, I was working on AIX and used to use fuser command to check if a file is locked ( in use ) by any user. Does the same command exist on Solaris or what is the equivalant then ? Please help. Regards

Hi all , I want to put a single quote at the begining and single quote plus a comma at the end of each line in a file. I did the following , sed -e "s/^/'/" -e "s/$/',/" filename It worked. But if I do , sed -e 's/^/\'/' -e 's/$/\',/' filename That do not work, I am given a secondary prompt...

Hi all, I am on Solaris. One of the C codes (Pro*C) we have has following declaration statement, int (*dbg_print) (const char *fmt_str,...); What is the meaning of this ? I can make out that this is pointer to function. But what the three dots "..." stand for ? Please explain. Regards

Hi Guys , I am learning XML. I have read a book on XML and familier with the concept and theory of XML. Some reality stuff ...... Which are the softwares or software layers involved in a typical J2EE based XML messaging application. Please explain. Basically I want to create one example...