• Product: Aleph
• Product Version: 20, 21, 22, 23
• Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Desired Outcome Goal: 
Copy Oracle table from one server to another 

Procedure: 
> Connect to source server with GUI client > Services 
> "Manage Database Tables" > "Export Database Tables (file-03)" 
> Specify "Table to Export", leave "Procedure To Run" as "Go" 

> Connect to target server with GUI client > Services 
> "Manage Database Tables" > "Import Database Tables (file-04)" 
> Specify "Table to Import", leave "Procedure To Run" as "Replace"

Additional Info
This could also be done from the command line.   

Example:
> cd /exlibris/aleph/a22_1/aleph/proc
> csh -f p_file_03 USM50,z30,go > & $alephe_scratch/usm50_p_file_03.0705.log &
> dlib usm50
> cd $data_files
>  [ftp oracle table to the usm50 $data_files directory on the target server]
   [On the target server:]
> cd /exlibris/aleph/a22_1/aleph/proc
> csh -f p_file_04 USM50,z30,replace > & $alephe_scratch/usm50_p_file_04.0705.log &

• Article last edited: 02-Mar-2016