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
Received on Fri Oct 29 2004 - 05:30:35 CDT
