RE: One Peta Byte = ??

From: Tran, Chieu Minh <tranc_at_recralab.com>
Date: 18 May 2000 14:08:00 -0400
Message-Id: <10501.106003@fatcity.com>

To my understanding, the prefix mega (M) , giga (G), peta (P), ... will be =
understood depending on who talks to. With hard drive 1 GB,  manufacturers =
mean their disks' size 1Gb =3D 1.000 X 109  bytes; meanwhile, memory manufa=
cturer mean 1Gb =3D 1.024 X 109  bytes because we haven't had the unique de=

finition about that. Therefore, I'm unsure which one is correct.

I hope that I'm not the one starting the flame about this issue.

-----Original Message-----

From: 	ORACLE-L_at_fatcity.com [mailto:ORACLE-L_at_fatcity.com]
Sent:	Thursday, May 18, 2000 10:16 AM
To:	Multiple recipients of list ORACLE-L
Cc:	tranc_at_recralab.com
Subject:	RE: One Peta Byte =3D ??

1024 terabytes surely

awaisb_at_paktel.com on 18-05-2000 07:15:50 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Brian McQuillan/GELCO)

1000 tera bytes

-----Original Message-----
Sent: Thursday, May 18, 2000 3:34 PM
To: Multiple recipients of list ORACLE-L

Oracle ver 8 Can Theoretically Support a MAX 512 Peta bytes Database Size Wha is ONE Peta Byte Equal to ?

--
Author: VIVEK_SHARMA
INET: vivek_sharma_at_inf.com

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: ListGuru_at_fatcity.com (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). --
Author:
INET: awaisb_at_paktel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
 --------------------------------------------------------------------

--
Author:
INET: Brian_McQuillan_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
 --------------------------------------------------------------------

=3D=3D=3D=3D=3D Internet Headers: Start =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

Received: from 63.74.90.24
          by recralab.com;
          THU, 18 May 2000 10:16:00 -0400
Received: from newsfeed.cts.com ([209.68.192.199]) by mail.bee.net
          (Post.Office MTA v3.5.3 release 223 ID# 0-52106U5000L500S0V35)
          with ESMTP id net for <tranc_at_recralab.com>;
          Thu, 18 May 2000 08:51:26 -0400
Received: from fatcity.UUCP (uucp_at_localhost)
	by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA50710;
	Thu, 18 May 2000 05:36:33 -0700 (PDT)

Received: by fatcity.com (04-May-2000/v1.0f-b69/bab) via UUCP id 00162427; = Thu, 18 May 2000 04:55:48 -0800
Message-ID: <F001.00162427.20000518045548_at_fatcity.com> Date: Thu, 18 May 2000 04:55:48 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> X-Comment: Oracle RDBMS Community Forum
X-Sender: Brian_McQuillan_at_gelco.com
Sender: root_at_fatcity.com
Reply-To: ORACLE-L_at_fatcity.com
Errors-To: ML-ERRORS_at_fatcity.com
From: Brian_McQuillan_at_gelco.com
Subject: RE: One Peta Byte =3D ??
Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
Mime-Version: 1.0
Content-type: text/plain; charset=3Dus-ascii Content-Transfer-Encoding: 7bit

=3D=3D=3D=3D=3D Internet Headers: End =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D




------------------------------

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Thu, 18 May 2000 20:17:55 +0200
Subject: New mailing list for Oracle Intermedia

Dear all,

I am happy to announce a new mailing list dedicated to developers and users of Oracle Intermedia.

Visit the list homepage to subscribe:

http://www.egroups.com/group/oracle-intermedia

Kind regards
Andreas Jung

From: "Heidi E. Schmidt" <heidi_at_cybercom.net> Date: Thu, 18 May 2000 14:37:54 -0400 (EDT) Subject: Re: Dynamic SQL

> A friend was trying to execute dynamic sql using EXECUTE IMMEDIATE (Create
> table ....) in his own schema but was getting insufficient privileges error.
>
> What's happening? Any special roles to be granted?
>
> The database version is Oracle8.1.5 on NT.
>
> Manish

Manish,

What the roles connect, dba, resource don't tell you is that it automagically includes "UNLIMITED TABLESPACE" You can grant create table, and other object creation abilities but unless unlimited tablespace privilege is given none of thoose grants apply.

So try granting that and then testing it. If that isn't the case note the Received on Thu May 18 2000 - 13:08:00 CDT