
368 13.4 Loading and Transformation
EXP TRANSPORT_TABLESPACE=Y TABLESPACES=(trans)
TTS_FULL_CHECK=Y GRANTS=N CONSTRAINTS=N FILE=C:\TMP\TT.EXP
LOG=C:\TMP\TT.LOG
When prompted for the username, enter:
SYS/<password>@<TNSName> AS SYSDBA
A successful export will look like that shown in Figure 13.6.
The next step is to copy the export file created above and the datafiles
in the transportable tablespace to the target database server. Make
sure datafiles are in the correct path.
Following these steps, in the loading step we can push the transportable
tablespace into the target database.
13.4 Loading and Transformation
Essentially, loading data into a data warehouse ...