Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating datafiles for 500GB database
On Wed, 14 Apr 2004 01:40:21 GMT, Mark Bole <makbo_at_pacbell.net> wrote:
>
> You're right. I was really just trying, in a sloppy way, to bring in a
> related concept: it's not just the size of the datafiles but the make-up
> of the tablespaces that should be considered (for example, the
> partitioning option mentioned by another poster is more useful if
> tablespaces are configured with partitioning in mind).
>
> According to Oracle, the only "logical" backup is an export file. I
> have been conditioned by the "ALTER TABLESPACE ... [BEGIN | END] BACKUP"
> statement to think of tablespaces as a unit of physical backup.
>
Good point, actually. Oracle is really quite sloppy with some of their command terminology, and that's a lovely example, actually.
Unless it's pointed out as you have done, it is not obvious that as a piece of syntax it conflates the logical with the physical.
Bad Oracle!
Regards
HJR
-- ------------------------------------------- Dizwell Informatics: http://www.dizwell.com -A mine of useful Oracle information- -Windows Laptop Rac- -Oracle Installations on Linux- ===========================================Received on Tue Apr 13 2004 - 22:29:00 CDT