1 2 Previous Next 19 Replies Latest reply: Nov 9, 2011 10:07 AM by Nicolas.Gasparotto Go to original post RSS
      • 15. Re: Data pump: by using dbms_datapump
        user7829506
        I have this issue. Fix was to grant "create table" to user be imported.
        • 16. Re: Data pump: by using dbms_datapump
          742417
          I had the same issue when testing some code against a newly created scott/tiger demo schema. Scott was missing a number of basic privileges. After granting the privileges below to scott, the error no longer occurred:

          GRANT CREATE VIEW to SCOTT;
          GRANT CREATE TYPE to SCOTT;
          GRANT CREATE PROCEDURE to SCOTT;
          GRANT UNLIMITED TABLESPACE to SCOTT;
          GRANT ALTER SESSION to SCOTT;
          GRANT CREATE TABLE to SCOTT;
          GRANT CREATE TRIGGER to SCOTT;
          GRANT CREATE SEQUENCE to SCOTT;
          GRANT CREATE SESSION to SCOTT;
          GRANT DEBUG CONNECT SESSION to SCOTT;
          • 17. Re: Data pump: by using dbms_datapump
            868534
            I get an error when I put dynamic paramter in dbms_datapump.metadata_filter

            if I will use simular to your logic

            begin
            dbms_datapump.metadata_filter(handle => d1,
            name => 'SCHEMA_EXPR',
            value => 'IN ( '|| '''myname''' || ')');
            end;
            And then I pass this strschemaname

            for example
            exec p_export_schema('myname');

            I get and error

            ora-39001 invalid argument value
            0ra-39170 schema expr in 'myname' does not correspond to any schema
            • 18. Re: Data pump: by using dbms_datapump
              user482717
              i found a solution, for my case, which is the same error as yours.
              at the code line: h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', job_name=> 'budget_exp1', version => '10.1');

              change the job_name to something else, because if for some reason the procedure is not running properly, this job name: budget_exp1 got tied up, so when you execute the procedure again, you got the error message, so change that, and exec procedure_name, you should be fine.
              • 19. Re: Data pump: by using dbms_datapump
                Nicolas.Gasparotto
                Since the very 1st post (on the 2nd of June 2007), this thread has been resurrected multiple times.
                Let's avoid it again and again and lock it.

                Nicolas.
                1 2 Previous Next