You can use DataPump to move data and metadata from one database to another.
Check the current Location:
SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
Change location to /oradata/backup
CREATE or replace directory DATA_PUMP_DIR as '/oradata/backup';
Nenhum comentário:
Postar um comentário