Hi,
we purchased a new server so we need move the database to the new one, we have on the old server a script (using 'exp' command to export the file itself and log) scheduled for every night.
On the new server
###############
We installed the Oracle Express 11G and when we try to use the IMP command utility (C:\oraclexe\app\oracle\product\11.2.0\server\bin\imp.exe) the first questions is related with 'only data' and then we say 'no' since we was wondering to import all data and schema itself but show too many errors saying that cannot modify index, another oracle error 403, 2340, cannot update pkg and etc.
Is there a way to export from server one with all options (schemma and data itself) to smooth restore on the new one???