Re: HELP ME!! BACKUP WITH EXP COMMAND

> 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!
>

• Always mention your version of oracle
• Please do not multi post (and you forgot comp.databases.oracle) Check it out: http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch01.htm#45882 hint : query

Please keep in mind that export is not really a backup: no recovery, roll forward, etc. It's just contains the data at a certain point.

Regards,
Rob Received on Fri Oct 29 2004 - 04:58:27 CDT