Database Utilities (MOSC)

MOSC Banner

need procedure for export - reimport during upgrade

edited Mar 1, 2017 4:01AM in Database Utilities (MOSC) 6 commentsAnswered
 Hello-
I'm trying to port my production 10.1.0.4 db to 11.2.0.1

I've been trying various approaches and resolving various bugs for 2 days but finally I'm stumped.

I have migrated upwards from 8.x to 9.x to 10.x in the past but it's been long enough that I don't remember the exact procedure I used.

Here's what I am trying:

brought up Oracle 11.2.0.1 under Win Server 2008 r2 64

using dbca I created a database by creating a template from the existing 10g production (actually a copy) db - this created all the tablespaces and corresponding datafiles from 10g in 11g but no schema, users etc.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center