Execute your documentation in oracle, PL-SQL Programming

Using research notes and Oracle documentation plan and execute an upgrade of an installation of Oracle 10g to Oracle 11g release 1. To do this you must show in screen shots and written notes

(a)    Your planning notes

(b)   Pre-upgrade validation of DB

(c)    Create a unique user and unique tablespace for that user and associated datafile.

(d)   Your EM screen for your 10g User Tablespaces. To do this you must use the supplied Schema, load it into your 10g instance under a unique user name, and then load data into it - choose your own user name.

(e)   Execute the upgrade using the notes provided and using course book and Oracle online help

(f)    Show a migration of the data you had in 10g now available in 11g instance.

(g)   Post-upgrade validation of DB.

 

Posted Date: 3/15/2013 1:37:11 AM | Location : United States







Related Discussions:- Execute your documentation in oracle, Assignment Help, Ask Question on Execute your documentation in oracle, Get Answer, Expert's Help, Execute your documentation in oracle Discussions

Write discussion on Execute your documentation in oracle
Your posts are moderated
Related Questions
Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

Create a procedure named DDPROJ_SP that retrieves project information for a specific project based on a project ID. The procedure should have two parameters: one to accept a projec

Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Using Host Arrays The Client-side programs can use anonymous PL/SQL blocks to bulk-bind input and output host arrays. However, this is the well-organized way to pass the colle


What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL

Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n