Skip to main content
ExLibris
ExLibris Dev

Copy Oracle Table from One Server to Another

 

  • 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
//doorbell.io feedback widged