I have inherited a database an Oracle 11g database with NO primary key field.
Instead an external identifier with a not null constraint was used to relate all the tables, run the forms and update the records.
As is the fate of all external identifiers, it is now being superseded and will no longer be available to my inherited database. Even better--not every record in the inherited database will be assigned a new external identifier.
Ideally, I would like to migrate the old external identifier into a new field, and modify its former field to a primary key field with an autonumber sequence. By reusing the field I hope to avoid having to rewrite all of the tables/queries and forms.
I am unclear as to the method and timing of updating the related tables. Should I create a new temporary field in the 'base' table so that I maintain integrity while I update the related child tables? Other pitfalls? Is this an accepted approach? Are there others?
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.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.