Oracle Learning-power Designer, Visio 2003, Oracle SQL Developer, OEM, EXPDP

Oracle 's system is too large. For those who have just started to learn, it is inevitable to have some sense of how to start.

After a semester of learning , we have a deep understanding of Oracle Learning and have learned some of the main knowledge of Oracle . So learn to get started a little faster.

This Oracle Project has once again made use of Oracle 's basic knowledge and a new understanding of software project. From demand analysis, conceptual structure design, logical structure design, physical structure design, database establishment and test, database execution and maintenance.

Although the database design cycle is more than three weeks long, but every step is very serious treatment. I chose the fleet management system. The U.S. Navy's equipment performance has been a major pioneer in the Chinese navy. In recent years, the United States has introduced a new military strategy policy, return to the Asia-Pacific. At this critical moment. According to our existing battleship, how to manage, assign personnel. The installation of weapons is a top priority. There are four modules in the system: Fleet information Management, warship information management, military officer information management, weapon information management. At the same time in the four systems to be inserted, query, change and other changes.

Based on these analysis, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDMandPDM are drawn using Power Designer . Create a table space, create a user, assign permissions, create a user profile, and then build tables, views, synonyms, stored procedures, functions, and WQH users in the Oracle database Trigger.

A lot of software power Designer,Visio 2003,Oracle SQL developer , etc. are used in the project . The software is used in the process of learning the relevant software. By finding information on the web. Ask the students basically mastered the basic operation of the relevant software. I believe that in the future learning work will also use these frequently used software, all master the use of these software is very important.

The original database objects such as synonyms, sequences, and so on are not known to Oracle. I don't know how to write it. What they are used for is the use of these objects through this big assignment. And the meaning and use of these objects are well known.

The OEM has a new understanding, learned the simple use.

The data is exported in EXPDP, first creating a directory object before using the EXPDP program, and the object's read. The Write permission is granted to the user. Prior to EXPDP not used, but after experimental operation learned the simple use.

(PS: the PPT given by the teacher is very specific.) There are many examples that are ideal for learning. But there are some mistakes, let me take a great effort to find, just learned a lot of knowledge, harvest quite abundant.

Despite the end of the course, Oracle 's learning path is very long and requires a long-term commitment. and continue to carry out experiments, summary and re-experiment to summarize, so that their own technology will slowly improve.

Oracle Learning-power Designer, Visio 2003, Oracle SQL Developer, OEM, EXPDP