Arccatalog imports spatial data from SQL Server into the Oracle library
1. Create a new database connection in Arccatalog->sqlserver
2. Create a new database connection in Arccatalog Oracle
3.Import the spatial data from SQL Server into the Oracle library
Here are two ways to use:
1) Copy and paste data
In the source database (SQL Server), select the data that you want to export, right-click Copy
Right-click Paste in the target database (Oracle)
In particular, it is important to note that:
Change the default value of the Config.keyword entry defaults to Sdo_geometry, which is the spatial data type that SDE for Oracle supports, as shown in:
2) Select the data to export in the source database (SQL Server), right-click Export to Shapefiles (single), and set the export path
At this point, the import and export of data is complete! Note that the spatial data type is modified, and if the data table does not have spatial data records can not be imported and exported, Arccatalog will error, so the data table must have at least one space record;
Arccatalog imports spatial data from SQL Server into the Oracle library