How to export Primavear P6 ADMUSER admin_config table using SQL Developer and import using SQLLDR

Export the ADMIN_CONFIG table 

Open the SQL Developer and create connection to ADMUSER account where you want to export the ADMIN_CONFIG Table . Below are my local ADMIN_CONFIG records I am going to export. As I highlighted below, This contains BLOB  data. 

Click on the TOOLS, Database Export 

Select the Connection as ADMUSER, Format as LOADER, Save as Separate Files and input a path where you want the exported records to be saved. 

Click Next 

Search for the ADMIN_CONFIG table as shown below, Move the table to the right 

Click Next 

Click Finish 

SQL Developer will export the table records to the directory we mentioned above. We can see the File URL in the progress bar 

I listed the SQL-Developer exported files 

Import ADMIN_CONFIG table using SQLLDR 

Truncate the existing records from the ADMIN_CONFIG table. 

truncate table admuser.admin_config  

If you installed Oracle DB client or Oracle database server. The SQLLDR is available in the \product\12.1.0\client_1\BIN directory.  The bin directory usually  added to the PATH variable  . If not input the absolute path of the SQLLDR, For example: C:\app\client\\product\12.1.0\client_1\BIN\sqlldr.exe . This command will import the records into ADMIN_CONFIG table 

cd

sqlldr userid=admuser// control= log=test.log