Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dump file importing problem (urgent)
Message
From
22/05/2001 06:45:30
 
 
To
All
General information
Forum:
Oracle
Category:
Other
Title:
Dump file importing problem (urgent)
Miscellaneous
Thread ID:
00509793
Message ID:
00509793
Views:
57
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.com
ICQ #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.
Next
Reply
Map
View

Click here to load this message in the networking platform