Question

Asked on 2005-06-09 at 10:23:43ID: 25471535

DB migration

by: crishna1500

Rating6.4Good

Dear Experts,

I inatlled 9i software , patched it upto 9.2.0.6 and then created a database using general purpose option.

The database shows it is 9.2.0.1. How do i migrate this to 9.2.0.6 , i wagely rememebr that i need to shut down the db and then startup with some migrate option.

How do i do it , please advice!

many thanks

  1. How do I migrate an Oracle database
    I need to retire our old database server and bail the data off to a virtual machine for archival purposes but I am not familiar with Oracle and how to use it. The old server is RHEL 3 with Oracle 8i and the new server is CentOS 5.2 with Oracle 10g. I have found some documentation on RMAN which looks promising but I am not sure if it is the right tool or not. Any…
  2. How to migrate migrate partitions from 9i  to 10g
    Is it possible to migrate partitions from 9i to 10g? If it is than can some one give me an example? If not, then what would be the best
  3. How do i to oracle migration
    We have got oracle 8.1.6 production server of data of 110GB & on another server of 80GB (8.1.16). they are both on solaris 8. These 2 servers are in cluster. we are plaaning to do manual migration on new servers as export/imp process failed because of blobs present in server 1. 1. Can I use Database upgrade assistant …
  4. script out all the audit option
    how to script out the audit option in one instance and implement it in another. including system level audit as well as user object audit.
  5. Parallel option in Tables and Indexes
    Hi Experts, I'm looking into the options of Parallelism in our datawarehouse. We have 4 CPUs in development and 8 CPUs planned in the PROD environment. The whole datawarehouse has 12 FACT tables and 24 odd Dimension tables. The 12 FACT tables are partitioned monthly. My Question is What are guidelines to be looked upon …

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
Participating Experts
5
Solution Grade
A

Replies

 by:

Posted on 2005-06-09 at 10:54:20ID: 28306727

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: jwittenm

Posted on 2005-06-09 at 11:26:28ID: 28306728

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: crishna1

Posted on 2005-06-09 at 11:46:53ID: 28306729

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: joelpatt

Posted on 2005-06-09 at 12:24:47ID: 28306730

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-06-09 at 23:48:42ID: 28306731

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-06-09 at 23:51:46ID: 28306732

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: joelpatt

Posted on 2005-06-10 at 05:54:25ID: 28306733

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-06-10 at 06:03:59ID: 28306734

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: joelpatt

Posted on 2005-06-10 at 06:47:03ID: 28306735

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-06-10 at 07:24:45ID: 28306736

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: joelpatt

Posted on 2005-06-10 at 09:50:25ID: 28306737

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-06-11 at 07:09:07ID: 28306738

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: anand_2000v

Posted on 2005-09-17 at 10:40:28ID: 28306739

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: PAQ_Man

Posted on 2005-09-21 at 12:22:55ID: 28306740

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: joelpatt

Posted on 2005-09-21 at 12:26:53ID: 28306741

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: schwertner

Posted on 2005-09-26 at 05:13:04ID: 28306742

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert