1 2 Previous Next 21 Replies Latest reply on Sep 6, 2013 5:56 PM by Dean Gagne-Oracle Go to original post
      • 15. Re: move schema from EE to SE
        Srini Chavali-Oracle

        If you cannot recreate the target database, then you will have to follow the steps in 1297961.1.

        • 16. Re: move schema from EE to SE

          Srini.. thanks for the info... I have read manual and also check database looks exactly what I want.


          Unfortunately we don't have CSSCAN utility installed on the test/prod databases, I spoke with the developer and he's ready to update records but need the list. Since it's production database it will take months to get approval from management before we can install anything new.


          I know I'm pushing my luck but without csscan utility is it possible to get list of problem rows/columns?

          • 17. Re: move schema from EE to SE
            Richard Harrison .


            You could try something like this to find the problem rows using the convert function - it gives you the basics anyway - just wrap it in something that displays rowid for anything large than size 'X'




            create table test (col1 varchar2(1));

            Table created.



            insert into test values ('Ü');

            1 row created.



            select max(length(col1)) from test;






            select max(length(convert(col1,'AL32UTF8'))) from test;








            • 18. Re: move schema from EE to SE
              Dean Gagne-Oracle

              Srini and others,


              You do not have to use a single export file. You can export in parallel 100 if you want and you will import as parallel 1.   You can have 1 file or 1000 files.  It does not matter to import.  Run your export command as you normally would and then run your import command using only the features allowed in SE.



              • 19. Re: move schema from EE to SE

                select max(lenght(convert(comment, 'AL32UTF8'))) from table1;


                Error at line 1:

                ORA-01401: inserted value too large for column


                I can run similar select statement to different database.

                • 20. Re: move schema from EE to SE
                  Srini Chavali-Oracle

                  Thanks Dean - does the import then read the multiple export files serially ? I assume that this will not cause any referential integrity issues ?

                  • 21. Re: move schema from EE to SE
                    Dean Gagne-Oracle


                    The Data Pump will only create objects serially.  I may read them in parallel.  Let's say you exported scott.emp and external tables was used.  Now let's say the first pq slave wrote to file 1 and the second pq slave wrote to file 2, these would both be read during import while scott.emp was being imported.


                    All that is meant by parallel=1 is that 1 worker process will be working at a time.


                    referential constraints are only loaded after data is loaded so there won't be a problem with them with any value of parallel.


                    Hope this helps.



                    1 2 Previous Next