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:
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
i have cracked the export
exp SSW/***@DNETTEST tables=(SDF_ASSET_ALL) LOG=E:\Dumps\SSW_EXP_SDF_ASSET_ALL.LOG FILE=DEV_SSW_SDF_ASSET_ALL.DMP
I now need to construct an imp script to take this data into a new table called SDF_ASSET_ALL_REPORTING rather than SDF_ASSET_ALL
Why not just create a copy of the Table in the main database with whatever name you prefer, Export that out, import it in your test environment and then drop the copy in the live environment. That's way easier..