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

Oracle 's system is too large, for beginners, it is inevitable that there is a feeling. After a semester of learning to have some in-depth understanding of Oracle learning, because previously learned Some basic knowledge of Oracle, so learn to get started faster.

This Oracle Project has allowed me to re -use Oracle 's basic knowledge, and also has a new understanding of software engineering, from requirements analysis, conceptual structure design, logical structure design, physical structure design, Database establishment and testing, database operation and maintenance.

Although the database design cycle is about three weeks long, but every step is still very serious treatment, I chose the fleet management system, the United States Navy equipment performance significantly ahead of the Chinese navy, in recent years, the United States has introduced a new military strategy policy, return to the Asia-Pacific, at this critical juncture, According to our existing warships, how to manage, assign personnel, install weapons and so on is a primary problem. In this system, there are four modules: Fleet information Management, warship information management, military officer information management, weapon information management, and in the four systems to be inserted, query, modify and other changes.

Based on these analyses, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDM,and PDM 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.

Many software power Designer,Visio 2003,Oracle SQL developer , etc. are used in the process of doing the project. The use of software in the process of the relevant software to learn, through the Internet to find information, ask the students basically mastered the basic operation of the relevant software, I believe that in the future study will also use these common software, all master the use of these software is very important.

The original database objects such as synonyms, sequences in Oracle have not been known, do not know how to write, what they use, through this big job will use these objects, and the meaning of these objects and the use of familiar.

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

The data is exported in EXPDP, Creating a directory object before using the EXPDP program and granting the user Read,write permission to the object. EXPDP was not used before, but after experimental operation, it learned to use it easily. (PS: the teacher to the PPT is very detailed, a lot of examples, very suitable for learning, but there are some mistakes, can let me take a great effort to find, but learned a lot of knowledge, harvest quite abundant.

Although the course is over, but the path of learning is still very long, the need for long-term perseverance, and continue to experiment, summarize and re-experiment to summarize, so that their technology will slowly improve.

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