AnsweredAssumed Answered

Export of a single Oracle GIS table and import into a different table name

Question asked by ChrisWhittaker_SSWater on Jun 8, 2018
Latest reply on Jun 8, 2018 by asrujit_pb

Hi I am after the syntax to export and import a single GIS Oracle 9i table from 'live' to 'test' as part of our migration to ARC.

 

We currently dump the entire database out via a scheduled task as per below:

 

del e:\dumps\dev_sswdnet.dmp
exp SSW/****@DNET tablespaces=(GIS_DATA,GIS_ARCHIVE,GIS_INDEX) LOG=E:\Dumps\SSW_EXP.LOG FILE=DEV_SSW.DMP

 

Does anyone know how just to specify to export JUST the data in a single table from  sdf_asset_all.

 

I also need help with the import script if this is ok to ask

Outcomes