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