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

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

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

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

Intermedia question

. 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

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

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

sql loader need help

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

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

Oracle 8.1.7.4 (32 bit) to 8.1.7.4 (64 bit)

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

Re: Reboot Solaris and Oracle 9i install

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

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