Re: CREATE TABLE with LIMITED RECORDS

From: <mpir_at_compuserve.com>
Date: Tue, 20 Jul 1999 18:43:32 GMT
Message-ID: <7n2g0g$4kk$1@nnrp1.deja.com>

If you mean limiting the load, if the size of the records are such that the storage requirement for 50 records is less than 10K (5 db block buffers at 2k per block, the default on most systems), you may not be able to.

Basically, allocate the space for the table such that it has only one extent, and that extent is just large enough for 50 records.

In article <37927BBE.FF7054BE_at_ix.netcom.com>, Kenneth Stahl <kcstahl_at_ix.netcom.com> wrote:
> CREATE TABLE TEST AS
> SELECT * FROM ABC
> WHERE ROWNUM < 51;
>
> "Tay, Virginia" wrote:
> >
> > Hi,
> >
> > I would like to create a table to restrict only 50 records based on
other
> > table....How do I do that??
> >
> > Like the following:
> >
> > CREATE TABLE TEST
> > AS
> > SELECT * FROM ABC
> >
> > Since ABC table has about 60,000 records.......I would like to
create
> > portion of the records for testing...
> >
> > Thanks in advance for your help.
> >
> > Virginia
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 13:43:32 CDT