RE:compare date

backup_date like '%01/01/2001%' that may work OK Cheers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not

Re: Re-claiming the space from T

You can try alter tablespace TABLESPACE_NAME(where the table is lying) coalesce; Cheers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also

Re: Weird - unable to extend err

OK Joe, I am taking back my suggestionCan you exactly tell me what would happen if (maxextents unlimited ) for system tablespace As far as i know only datadictionary and packages(compiled code) reside in tablespace SYSTEM.So even if i give maxextents unlimited What would happen if no

RE:8.0.5 to 8i upgrade

Hi man, during migration you just follow these steps.I didn't read any document.The migration typically takes 2-3 hours on each database (You have to upgrade your replication also if it is there).It depends on your machine RAM etc ofcourse 1) run u0800050.sql in $ORACLE_HOME/rdbms/admin

RE:can not mount database Exclusive

Shut down the database first and startup in exclusiv mode Chhers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are

RE:Materialized views across a db l

HI JOHN, What exactly the error.Please be more specific.Was the MV created. Or after creation of MV after some interval (The interval specified while creating MV) you didn't see the refreshed data.I suppose that must be so.. Check Job_queue_processes,Job_queue_interval parameters in your

RE:No record in import help me plea

Say ignore=y and rerun it.Because when you say ignore=n it sees the table_name alraedy exists So either drop the table and rerun the import again (the same you were using) Or say ignore=y that'll set all things right Cheers Ganti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: RE:Materialized views across

Hi john, Did you check the parametrs right.And any event parameter in your init.ora file Check and reply soon Chhers Ganti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: EXPORT PROBLEM

MALA, in the export log (typial) this is the order. exporting job queues exporting refresh groups and children exporting user history table exporting default and system auditing options Export terminated successfully without warnings. What you have to do is after importing you have to

RE:reset control, redo, logs etc

Hey Joe, No need to worry.Is the database working now.You don't have to reset control file..If you are in doubt create the control file again using the famous ALTER DATABASE BACKUP CONTROL FILE TO TRACE; etc But if you want to retrieve the database from cold back up you have taken while the

RE:Invoking svrmgrl

svrmgrlFILE(Or any other symbol ! ,some mark) connect user/password@my_db @c:\temp\my_script.sql FILE(end of mark) Cheers GANTI -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: questions: security on the u

Oh Mitchell, You have to set s-bit permission should be 6755 --something like that.When user updates a record he is ultimately writing to datafiles.At that time he should assume as file-owner.That means only thru sqlplus or thru some other application only he can write to the file,Neither he

RE:Big Dump file (12gb) from nt to

Hi hessu, Your export might have been right one,Which unix r u using .can you give info.. There is a command strings in AIX which gives all the printable characters of any object-file or dumpfile.So try similar command in your unix. and give the following at the command prompt strings

RE:Shell scripting question

HI JOHN Try to create .netrc file in your home directory.It definitely works for UNIX to UNIX.But I am not sure from UNIX to WINDOWS If it works that'll be great.Please let me know if it works. Regards Ganti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE:Materialized View Problem

Can you please send the full query Regards Ganti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to find a listener servi

Hey Maheswar, If unix user wants lsnrctl services you can write a shell script like this read sid lsnrctl EOF$HOME/lis(HOME is user's HOME directiory) stat lis_a EOF grep $sid $HOME/lis 0/dev/null if [ $? -eq 0 ] then echo "YOUR SERVICE IS UP" fi Write this shell script and write a