RE: Progress of an index rebuild
How about v$session_longops Cheers From: Daniel Hanks [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Progress of an index rebuild Date: Tue, 06 Jan 2004 09:49:25 -0800 Is there any way to check on the progress of an index rebuild? (Oracle 8i). I.e., it would be nice to get some indicator as to how far an index rebuild has gone, something like 75% done As a rough indicator, I've noticed when rebuilding/moving an index to a different tablespace, Oracle will allocate temporary extents in the tablespace to which the index is being moved. So, in theory, I suppose I could see how big (in terms of extents) the index is before moving it and use that as a rough indicator to see how far along the rebuild is by counting the number of temporary extents allocated in the new tablespace (taking into account the extent size in the new tablespace). Are there better ways to see the progress of an index rebuild? Thanks for any help. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sys as sysdba with password through ODBC
Can this be done a want to connect through ODBC, for a php web page Can this be done if so how do I declare the username, password and db string Currently i do $username = name $password = password $dsn=dsn Any help appreciated Cheers _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sys as sysdba with password through ODBC
I have done that it works through SQLPLUS but through my page i can connect to the dsn but now i get Warning: odbc_exec(): SQL error: [Oracle][ODBC][Ora]ORA-03114: not connected to ORACLE , SQL state S1000 in SQLExecDirect From: Mercadante, Thomas F [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: sys as sysdba with password through ODBC Date: Fri, 19 Dec 2003 10:36:39 -0500 Craig, did you try: $username = SYS $password = syspassword AS SYSDBA $dsn=dsn Tom Mercadante Oracle Certified Professional -Original Message- From: Craig Richards [mailto:[EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: sys as sysdba with password through ODBC Can this be done a want to connect through ODBC, for a php web page Can this be done if so how do I declare the username, password and db string Currently i do $username = name $password = password $dsn=dsn Any help appreciated Cheers _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sys as sysdba with password through ODBC
Oh yes From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: sys as sysdba with password through ODBC Date: Fri, 19 Dec 2003 07:39:26 -0800 Craig, did you try: $username = SYS $password = syspassword AS SYSDBA $dsn=dsn Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 19, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Can this be done a want to connect through ODBC, for a php web page Can this be done if so how do I declare the username, password and db string Currently i do $username = name $password = password $dsn=dsn Any help appreciated Cheers _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Tired of 56k? Get a FREE BT Broadband connection http://www.msn.co.uk/specials/btbroadband -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT PHP and Oracle
I am trying through php to do select username from v$session I keep getting Parse error: parse error, unexpected $end in c:\program files\apache group\Apache2\htdocs\actusers.php on line 23 Can anybody help so i can escape the $ char please as this is driving me mental Cheers _ Find a cheaper internet access deal - choose one to suit you. http://www.msn.co.uk/internetaccess -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile ?
I don't beelive you can drop a datafile from a tablespace, you have to drop the tablespace, just reaize the datafile to 1M if space is the problem Regards From: Prem Khanna J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How to drop a datafile ? Date: Tue, 28 Oct 2003 22:19:24 -0800 doc 111316.1 doesn't mention about using OEM for the same. so i hope it cannot be done with OEM. am i right LIST ? so how do i do it from sqlplus ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Richards INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).