Scripts for exporting backup from selected tables of Oracle DB

Shell Programming and Scripting
1

dear all
please help me !
i need a script for exporting the selected tables of oracle database installed on CentOs.
i waiting your response.
thanks and regards

2

Hi,

Could you post some more details ?

Thanks
Pravin

3

be inform that i have a database service upon oracle that installed on centos.
ok?

when i export a full backup from db , the created export backup db have a very heavy contains volume about 28gb!
also my db have about 100 tables and one of that i dont need to be in my backup.
i want to deselect this table and then export a backup.
also i can just select any tables that i want to backup, not any tables that i dont want!
i know that i need a script for running this task. but i dont know how.
please help me!
thanks

4

Could this help you ?

exp username/password@database tables=table1,table2 file=table_data.dmp
5

dear parvin.
did i must to run this commands on centos bash ?

6

yes , right .. run this command from command line.

7

dear Parvin
did i set a schedule backup for for this command?