Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating datafiles for 500GB database

Re: Creating datafiles for 500GB database

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 14 Apr 2004 13:29:00 +1000
Message-ID: <opr6ffympg3d8uqx@news.optusnet.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US