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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help me please!EXP command for backup

Re: Help me please!EXP command for backup

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 29 Oct 2004 18:06:01 -0700
Message-ID: <1099098299.787059@yasure>


PLUTO wrote:

> Hi,
> Sorry for my english!
> I'have a big problem!
> I must carry out the backup of one database!
> I have a table...
> I must use exp command...
> But i want to save only some rows of the table.
> How can i do?
> For example:
> I have a db with only one table (only for example ;-p)
> The table name is "MOUSE"..
> MOUSE have 2 column: ID(key),NAME
> MOUSE have 5 rows:
> ID | NAME
> ------------------------
> 1 | jeffrey
> 2 | rome
> 3 | tom
> 4 | george
> 5 | new york
>
> I want backup with the exp command this table but only the rows with
> MOUSE.ID>3!!!!
> How can i do???
> Thank's!!
> Help me!

First understand that an expert is not a backup.

But if that is what you need to do ... and oh does this look like school work ... create a table with the records you want to export and then export it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Oct 29 2004 - 20:06:01 CDT

Original text of this message

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