Export data from Oracle table to TXT (“;” semicolon delimited text) file without programming

by

Want to export data from Oracle table to TXT (“;” semicolon delimited text) file?

Using DBToFile, a native GUI tool, you can export data from Oracle table to TXT (“;” semicolon delimited text) file easily and fast.

  • Step by step, just a few mouse clicks.
  • Support schedule and automate converting task.
  • Support Windows, Linux, macOS.

Download DBToFile Download DBToFile

Here’s how to.

Export data from Oracle table to TXT (“;” semicolon delimited text) file

Choose Oracle and logon.

export Oracle  table to SEMICOLON file - Choose Oracle and logon

Click “Export From Table” at task dialog.

Export data from Oracle  Table To TXT File - task window

Select TXT file type.

Export data from Oracle  Table To TXT File - select TXT file type

1. Choose Oracle table.

Unload data from Oracle  Table To TXT File - select table

2. Set TXT (“;” semicolon delimited text) file options.

Extract data from Oracle  Table To TXT File - enter file name

3. Summary.

Convert data from Oracle  Table To TXT File - summary

4. Export Oracle data to TXT (“;” semicolon delimited text) file.

Dump data from Oracle  Table To TXT File - export

After exporting, you can view output TXT (“;” semicolon delimited text) files.

Export data from Oracle  Table To TXT File - view TXT file

Download DBToFile Download DBToFile

Save/load session of exporting Oracle to TXT (“;” semicolon delimited text)

You can save/load session to run “Oracle to TXT” conversion repeatly.

1.Save Session.

Click “Save Session” button, then enter a session file name.

Oracle to TXT - save session

click “OK” button.

2.Load Session.

Click the “Open a Saved Session” in task window, select a session file.

Oracle to TXT - load session

then show the wizard form, click a few “Next” to export Oracle to TXT (“;” semicolon delimited text).

Oracle to TXT - start session

Download DBToFile Download DBToFile

Run in command line for exporting Oracle to TXT (“;” semicolon delimited text)

You can run “Oracle to TXT (“;” semicolon delimited text)” conversion in command line.

When you save session, you can click “Save & Make Batch File”.

Oracle to TXT - save session

The “Save & Make Batch File” form shows.

Oracle to TXT - create batch file

Click “OK” button, you’ll create a batch file, in Windows, like this:

C:
cd "C:\Users\pansh\AppData\Local\Programs\DBToFile"
DBToFile task="C:\Users\pansh\Documents\test.uld" logfile="C:\Users\pansh\Documents\test.log"

You can run this batch file in command line.

Download DBToFile Download DBToFile

Run as scheduled task for exporting Oracle to TXT (“;” semicolon delimited text)

You can run “Oracle to TXT (“;” semicolon delimited text)” conversion automatically at specific time.

On Linux/macOS, you can use Crontab.

For macOS, How to Fix Cron Permission Issues in macOS.

On Windows, in “Save & Make Batch File” form, you can click “Create & Schedule Task” to set a scheduled task.

Oracle to TXT - create batch file

And then, with scheduled task wizard, step by step.

Oracle to TXT - scheduled task application

You’ll see created task listed in scheduled task list.

Oracle to TXT - scheduled task list

Download

Here you can download DBToFile, and buy DBToFile.

30-day free trial Download DBToFile