"rob" <rob_at_dsdelft.nl> wrote in message news:clt486$p79$1_at_news.tudelft.nl...
>
> > 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
ORACLE 7
> - 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:23 CDT
