Create BKP EXPDP with .BAT Windows

Backup, Recover, Import, Export, Datapump, etc
Post Reply
borgesrs_br
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 5
Joined: Mon, 19 Jun 2017 5:24 pm

What's the need?


In the .bat block create the script drive routine.
Call the .sql script to perform some required BKP settings.

I need it from the SQL below.
Where environment = 'Model' and version = '12 .1.16.0 '

I keep in a variable and do the EXPDP of that schemma
because At the end the result is a schemma of my internal.

Someone already done something in this sense? to call a SQL script inside a bat with variables?
Wanderson Silva
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Mon, 29 Jul 2019 5:50 pm

Helo!

has this template to create a backup via .bat in Windows.

Select all

F:\oracle\product\10.2.0\db_1\BIN\expdp system/xxxx Directory=DataPump_Out DumpFile=XClinic_DP_Full LogFile=XClinic_DP_full Full=Y 
See the link below details to create .bat
https://forum.imasters.com.br/topic/286 ... tar-expdp/
Source: Imasters
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest