Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Extract Data From EBS

SoofiOct 17 2019 — edited Feb 9 2021

Hi All,

I need to extract the data from Oracle EBS database to my local database (Oracle) and after processing the data in my local db, I need to push the data from my local db to a target database which is again Oracle EBS database.

what will be the best practice to establish this connectivity?

OR

Is there any way we can create links between EBS DB with another Oracle DB?

Comments

Paulzip
Answer

First of all, ensure that your terminal is set to UTF-8 by locale charmap or echo $LANG
Then in SQL*Plus set your NLS_LANG environment variable, via the export command, for example, for UTF-8 Unicode
export NLS_LANG=.AL32UTF8
By the way, Oracle 12.2.0.1 and above, SQL*Plus is capable of displaying the result of a query as CSV, which can make formatting easier
SET MARK[UP] CSV {ON|OFF} DELIMI[TER] character QUOTE {ON|OFF}

Marked as Answer by r.khattri · Apr 5 2021
r.khattri

Thanks @paulzip ..
This will definetly help me. I will check.
But what my requirement is I need a script to generate CSV file and I execute that file using crontab daily baisis.
So, How I export UTF-8 everytime. Or can i write this in spool file? . Or Can you suggest any better way to perform this task.

You cannot set character set as using an SQL*Plus command. You have to set it in the environment of SQL*Plus in the variable NLS_LANG.
You can call SQL*Plus from a shell script and set (and export) NLS_LANG in this shell script before calling SQL*Plus.
You can also write your own spooling program in Java+JDBC or in C+OCI and then you can set the character set inside the program.

Thanks,
Sergiusz

Richard Zhang

I just user PowerShell to convert the file into UTF8 encoding, by:

Get-Content $inFileEncodingCp936 | Set-Content $outFileUTF8 -Encoding UTF8
1 - 4

Post Details

Added on Oct 17 2019
#general-ebs-discussion
9 comments
445 views