test
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Os block size
Could someone please tell what is OS block size on solaris 8 Mujeeb Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Drop schema and all related objects
Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Drop schema and all related objects
Thanks to all who replied, it works. [EMAIL PROTECTED] 05/11 1:42 PM -Original Message- From: james ellis [mailto:[EMAIL PROTECTED]] connect as sys or system. drop user username cascade; The user and all objects will be removed. --- Mujeeb Chowdhry [EMAIL PROTECTED] wrote: How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. In My Humble Opinion, connecting as sys or system should be reserved for tasks that cannot be accomplished through another user. Instead, you could connect as any user that has DBA role (or the appropriate privileges) and then issue the drop statement. Also, it can often prove useful later to first do an export of the user and all the objects owned by that user, BEFORE doing the drop user cascade. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Intermedia question
Hi, Does anyone know the maximum character length for index name for intermedia index. I'm trying to create intermedia index with the index name length of 24 characters, my index name is title_creators_ind_index and getting drg-11439 index name length exceeds maximum of 25 characters error. I'm using Oracle 8.1.6 on Sun Solaris 2.7 Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Find DBA users
Check view dba_sys_privs Mujeeb Chowdhry [EMAIL PROTECTED] 11/26/01 07:10AM Hi! Is there a data dictionary view that gives me all users who have geen granted the DBA role? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: nomount
Hi, Views that can be read in the nomount stage are: v$parameter, v$sga, v$option, v$process, v$session, v$version and v$instance. And tempfile is latest method of defining Oracle database temporary files for Temp tablespaces. Mujeeb Chowdhry [EMAIL PROTECTED] 12/11/01 07:20AM HiAnyone now which 2 V$ views can be accessed while in nomount mode ?Also what is a tempfile ?TIASaj Iqbal-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sajid Iqbal INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
sql loader need help
Hi, I need some help...I am trying to use SQL loader to load a flat file into a table...the problem I have is that when trying to load a blank column into a date column... this throws out an error...and the loader fails...do you know of a way of how to get around this problem...how can I just load nulls into the column or something... really appreciate help... Mujeeb Chowdhry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Metalink gone to sleep ?????
I tried to log on to metalink today(11/20/2001) got the same error. Mujeeb Chowdhry [EMAIL PROTECTED] 11/20/01 09:45AM Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else sharing the same problem Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Oracle 8.1.7.4 (32 bit) to 8.1.7.4 (64 bit)
Hi All, We are in the process of upgrading Oracle 8.1.7.4 32bit on Solaris 7 to Oracle 8.1.7.4 64bit on Solaris 8. The step I'm taking are 1. Install Solaris 8 and recommended patches 2. Install Oracle 8.1.7.4 32bit 3. Restore database 4. Install Oracle 8.1.7.4 64bit on separate home 5. Use oracle metalink doc 62290.1 to change word size. 6. Run utlrp.sql to recompile objects My question is we are using Intermedia Indexes, by running utlrp it may not validate Intermedia Indexes. What is the best way to achieve this task without rebuilding Intermedia Indexes. The export/import is one option but it takes long time to do that. Any idea or recommendation greatly appreciated. Thanks Mujeeb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mujeeb Chowdhry 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: Reboot Solaris and Oracle 9i install
try init 6 [EMAIL PROTECTED] 10/13/03 11:04AM Use 'shutdown now' Then 'reboot -r' [EMAIL PROTECTED] 10/13/03 7:34:24 AM List, Does anyone know the correct Solaris commands to reboot a UNIX Solaris 64 bit os system. Is it init, shutdown or reboot? I'm attempting to install Oracle 9i Release 2 on a Solaris machine. I received a memory error when attempting to create an Oracle database, so I need the system rebooted to load the kernel with the correct shared memory and semaphore settings. The system admin is only part time, and currently not available. The system is in single user mode at this time. With all the knowledge on this list, I thought this may be a good place to ask the question or maybe to point me to a document that would have the reboot information. Thanks, M. Do you Yahoo!? The New Yahoo! Shopping - with improved product search -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mujeeb Chowdhry 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).
Oracle vs Mysql
Hi, I've been asked by management to explore the pros and cons of Mysqlvs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb.Can someonelet me know the advantages of Oracle over Mysql or the problems we can face usingMysqlfor examplesupport issues or availability/performance issues. Thanks in advance Mujeeb