Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafiles and tempfiles
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D21D2D2.6DD24E26_at_exesolutions.com...
> Just did the following:
>
> SQL> SET TIMING ON
> SQL> CREATE TEMPORARY TABLESPACE temptest TEMPFILE
> 'c:\temp\temptest01.dbf' SIZE 400M;
>
> Tablespace created.
>
> Elapsed: 00:00:04.16
> SQL>
>
> on an IBM 380Z ThinkPad, 300MHz CPU with 64MB RAM, WinNT 4 SP 6, Oracle
> 8.1.7.0.0 Enterprise Edition. The disks are configured as NTFS.
Seems pretty good to me.perhaps its Oracle version dependent as well
-- Niall Litchfield Oracle DBA Audit Commission UKReceived on Tue Jul 02 2002 - 16:24:10 CDT
![]() |
![]() |