How can I create backup script for selected tables in Oracle

Question

I am using below script to create backup file but it takes backup of all tables. I want backup of selected tables. how can I achieve this.

imp <username>/<password>@<hostname> file=<filename>.dmp log=<filename>.log full=y;

Below script is working fine. select 'C:\Daily-MIS-Backup\'||TO_CHAR(SYSDATE,'YYYYMMDD-HH24MISS')||'.DMP' foo3 from dual; HOST EXP USERID=myusername/mypassFILE='^LOG1' GRANTS=Y ROWS=Y OWNER=SMPSYS LOG=EXPORT.LOG

We tried following code but it took backup of all tables. we need backup of selected tables. select 'C:\Daily-MIS-Backup\'||TO_CHAR(SYSDATE,'YYYYMMDD-HH24MISS')||'.DMP' foo3 from dual; HOST EXP USERID=myusername/mypassFILE='^LOG1' GRANTS=Y ROWS=Y OWNER=SMPSYS LOG=EXPORT.LOG

Matthew McPeak · Accepted Answer · 2023-07-18 03:20:26Z

2

The import and export utilities have a TABLES parameter. Syntax is like this:

 TABLES=(myschema1.table1, myschema2.table2, ...)

Remember to escape the parentheses if you're on UNIX or an OS that requires that.

edited Jul 18, 2023 at 3:20

answered Jul 17, 2023 at 14:30

Matthew McPeak

18.1k3 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I create backup script for selected tables in Oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related