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
Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Wrapping and unwrapping in SQL Operators WRAP and UNWRAP in connection with attributes whose declared types are tuple types. Example shows how extension and projection can be

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Pl/SQL Expressions The Expressions are constructed by using the operands and operators. An operand is a constant, literal, variable, or function call which contributes a value

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec