How to deploy multiple PLSQL files at once

This article describes how to deploy multiple pl/sql files (.api, .sql, .etc) at once using command prompt.

First of all you have to store names of the plsql fiels in a text file in below way and save it in the folder where your plsql files are saved.


Then open the command prompt and  change directory path to where your plsql files and text file is saved.
Then type below commands in the command prompt and press enter.

sqlplus/nolog

conn username/password@service_name


Then write @ sign and drag and drop the text file to command prompt or type the path of the text file.
Press enter button.
Do not forget to type @ sign before the path of the text file.

Now all oracle files included in text files are deployed in your oracle database at once. If there are any compile errors in your db files, those are shown in the command prompt clearly.

If There are more db files, it is difficult to type all file names in the text file. So you can create a script for this.
Open a text file and type below code there


dir /b *.* >test.txt

::-----bo Batchl....
@echo off & setlocal

For /F "tokens=1*" %%i in (test.txt) do call :doSomething "%%i"
goto :eof

:doSomething

set "str1=@"
Set "str2=%~1"
set "str3=%str1%%str2%"
echo.%str3% >> result.txt

goto :eof
::-----eo Batch....

Then save it as run.bat in the location where your db files are saved. Then double click on the bat file and it creates two files called result.txt and test.txt. Now, you can use result.txt file for deploying db files because it contains all file names of the files which are saved in your folder.

Comments

Post a Comment

Popular posts from this blog

How to add standard and custom Metadata to PDF using iTextSharp

In a previous blog, I explained How to add custom metadata using Syncfusion library. But this package gives so many difficulties when adding metadata to pdf. Such problems are,    1. When once add custom meta data to a pdf, it does not able to change or remove those custom meta data from the pdf.    2. It does not compatible with meta data search engines. It does not show custom meta data properly when those are searched through the search engines. Due to these reasons, Syncfusion is not good library for custom meta data. But, iTextSharp provides flexible framework to deal with custom meta data as well as standard meta data for PDF. Below I have provided the source code to show usage of iTextSharp library. You can download iTextShrp.dll from here                              PdfReader pdf = new PdfReader(input_path); ...
Read more

How to set and get Metadata to image using BitmapMetadata class in C#

When images are considered, those are storing their Meta data using different types of Meta containers such as EXIF, Adobe XMP, IPTC, Photoshop Image resource and Text descriptions. This every container has their specific unique rules to encode (store) and decode (extract) Meta data. As well as these each Meta container is storing specific Meta information. Exif Meta containers are mostly storing location information and GPS (Global Positioning System) records. As well as, Adobe XMP is responsible to store Dublin core Meta data which provides standard Meta tags that can be used to describe digital objects basically and IPTC is storing Meta information about application records. Meta data extractor is mainly considering these Exif, IPTC and adobe XMP Meta containers when it is extracting Meta data from images. As well as, these different Meta data containers are considered; they are structuring Meta tags in different dir...
Read more

How to generate direct line token to start a new conversation between your own client application and bot framework in Java

You can enable the communication between your bot framework and your client application using Direct Line API. When you add your client application as a site to communicate with your bot framework through azure portal, bot framework will generate secret keys. Your client application can use these generated secret keys to authenticate direct line requests issued to your bot framework. Let me explain how we can generate token to start a  conversations between your own client and bot framework. When we send a request to direct line for generating token,  if the request is successful it will send the conversation id and token that is valid to that conversation id. If client application already has a earlier used conversation Id, you can pass that id as an input to this method for generating token. If there is no conversation id, you can pass null value.  Return type of this method is a Map to retrieve generated token and conversation Id which is valid for that to...
Read more