-
I am trying to export a schema's object from nt box(8.1.6) to
Linux box(8.1.7). I am able to export the schema's objects as tables,stored proce
cedures,function except the indexes,array time. As for the documentation, I have tried the option of setting INDEXES as Y to export and import the objects. But nothing is happening and the thing
I could not understand there is no error logs reported in both export and
import log files.
Am I am missing something on exporting/Importing indexes along with other objects?
I was using following statement.
exp system/manager file=exp.dmp log=exp.log owner = schuser indexes = Y
imp system/manager file=exp.dmp from=schuser to=linuxschuser indexes = Y
log=imp.log
Any suggestion.
SKM
-
try this
use "rows=Y"
imp system/manager@*HOST* file=exp.dmp from=schuser to=linuxschuser indexes = Y ROWS=Y log=imp.log
- Magnus
-
is there anything in exp.log or imp.log?
if not, you are probably not getting connected to the database.
if you run these commands from a command prompt you should be able to see if exp or imp is doing anything, or just bombing. what is it showing you at the command prompt when you execute these commands?
-
jdorlon,
In exp.log file, I am seeing a lot of exporting statement.
But I don't see any exporting statement for the indexes.
Isn't that weird?
SKM
