I added a larger harddrive to my NT server. The original instance (Schdora1) was exported to a .dmp file. I then stopped & disabled the Schdora1 Service, stopped & diabled the Listener, and installed a new Oracle 9i DB on the new drive. The new instance is call Schdora3 (because schdora2 failed, and it wouldn't let me reuse the name).
After much consternation and cursing about tnsnames.ora and listener.ora files I FINALLY connected to the new schdora3 Service.
I don't really understand this, but the schema "Schedule" is actually a user. I created my deveopment login of "BX", and the user "Schedule" after reading the IMP error message(s) several times.
answer all the default prompts which include "Import Table Data?" yes.
All the sequences, views, Procedures and Packages come in, and NONE OF THE TABLES or TABLEDATA!!!!!
Its even asks "Import Grants?" to which I answer "yes".
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …