Hi!
When importing dump file, data imported fine, but Stored Procedures, Functions and Triggers do not import no matter what we do.
Dump file created by:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Trying to import at:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Note that we tried to import it successfully at the original server.
Note that we answered 'Yes' to the question of imp.exe: 'Import Entire Export file'
Note that we granter 'all' privilegies to the user.
Note that we tried to remove user completely, create it again and import - data are imported when SP and such are not imported.
Note that we even tried to re-install server on other machine - the same problem.
Is that problem is related to the differences in version?
How we can copy the entire schema from one server to another? Is there any way to do this and which tools to use?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.