"Steve" <ThisOne_at_Aint.valid> wrote in message
news:clt64b$ven$1_at_lust.ihug.co.nz...
> PLUTO wrote:
> > "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
> >>
> >>
> >
> >
> >
> Why not just create table as select * from mouse where... and then exp
that?
>
> Steve
THANK'S
Received on Fri Oct 29 2004 - 05:53:06 CDT
