| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: file size limitations?
Solaris 2.6 doesn't have a 2GB, but the Oracle software might. On my Sun
boxes, I can create a file larger than 2GB. But the export utility
can't. So when I export, I have to compress the file through a pipe.
When I do this, I'm bypassing Export's writing to disk. It's writing to
a pipe and the file can be much bigger.
Anyway, to be sure that one of your tablespaces doesn't run out of room and doesn't hit a 2GB file size limit, just add another datafile to the tablespace.
HTH,
Brian
Nuno Souto wrote:
>
> On Thu, 3 Feb 2000 09:51:08 -0500, "Jim Day" <jday_at_fslso.com> wrote:
>
> >in size. Is there a size limitation for any single *.dbf Oracle file on
> >Solaris 2.6 (I thought I read once there was a 2GB file size limitation)?
>
> Probably yes. Most older UNIX implementations have that limit. Dunno
> if Sol2.6 does.
>
> >If so, 1) can someone point me to documentation on this restriction,
>
> man ioctl(), read, follow the Related fields to write().
>
> > and 2)
> >what are my options?
>
> a) Add more files of <2Gb size to your tablespace. You can add
> many,many more without hitting problems. The maximum capacity of your
> tablespace will be the sum of the sizes of all these files.
>
> b) Upgrade the OS and use larger files. You need to export/import the
> tablespace to move it to a larger file.
>
> Pick the one that makes sense to you.
>
> HTH
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
--
 |
 |