Solved

10g to 11g Schema Refresh

Posted on 2012-03-20
4
1,015 Views
Last Modified: 2012-03-27
Hello All,

Here is my scenario ..

I have a 10g (10.2.0.4) Database  - Database A and i have cloned the same Database and upgraded it to 11g R2 (11.2.1.0) Database - Database B.

DATABASE A and DATABASE B has same Schema structure also.

I need to refresh Database B Schemas from Database A schemas.

The following are my questions :

1.) Will this be compatible, since i am doing an export/import of schemas from 10g to 11g.
2.) Should i need to do additional operations like validations.
3.) Is there any other way to do this other than export/import or Materialized Views.

Thanks

Max
0
Comment
Question by:Max4rDBA
  • 3
4 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 37744210
create a database link from the 11g db to the 10g db and use dbms_datapump


declare
   v_handle NUMBER;
BEGIN
   v_handle:=
   DBMS_DATAPUMP.OPEN (operation   => 'IMPORT',
                       job_mode    => 'SCHEMA',
                       remote_link => 'YOUR_DB_LINK'
                               );

   DBMS_DATAPUMP.metadata_filter (handle => v_handle,
                                  NAME   => 'SCHEMA_LIST',
                                  VALUE  => '''SCHEMA1'',''SCHEMA2'''
                               );

   DBMS_DATAPUMP.set_parameter (handle => v_handle,
                                NAME   => 'TABLE_EXISTS_ACTION',
                                VALUE  => 'REPLACE'
                               );


   dbms_datapump.add_file(handle => v_handle,
                          filename => 'your_log_file_name_here.log',
                          directory => 'DATA_PUMP_DIR',
                          filetype=>3);


   DBMS_DATAPUMP.set_parallel(v_handle, 4);

   DBMS_DATAPUMP.start_job (v_handle);
END;
/
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 500 total points
ID: 37744215
for your export/import,  use expdp  and impdp.

if you must use exp/imp (can't think of reason why you would have to though)
then use 10g exp and 11g imp
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 37745702
why the B?


penalty grades are not appropriate when you have not asked for additional information or explained any deficiency
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

1 Experts available now in Live!

Get 1:1 Help Now