Imp problem

HuaMin Chen

    Hi,

    How to resolve this?

    [oracle@localhost bin]$ imp 'mysch/mysch@xe as sysdba' file=/usr/share/mysch.dmp full=y

    LRM-00108: invalid positional parameter value 'as'

     

    IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

    IMP-00000: Import terminated unsuccessfully

    [oracle@localhost bin]$ imp 'mysch/mysch@xe as sysdba' file=/usr/share/mysch.dmp full=y

    LRM-00108: invalid positional parameter value 'as'

     

    IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

    IMP-00000: Import terminated unsuccessfully

      • 1. Re: Imp problem
        sb92075

        the SYS account should only ever be used for database version upgrades.

        • 2. Re: Imp problem
          HuaMin Chen

          There is no sys account used above.

          • 3. Re: Imp problem

            Wrong.

            'As sysdba' means Oracle will connect as SYS.

            Oracle recommends not using the SYS account for exports and imports.

            If you insist on using this connect string, it should be

            "mysch\/mysch@xe as sysdba"

             

            ---------------

            Sybrand Bakker

            Senior Oracle DBA

            • 4. Re: Imp problem
              HuaMin Chen

              Sorry, still get the same by this

              [oracle@localhost bin]$ imp "mysch/mysch@xe as sysdba" file=/usr/share/mysch.dmp full=y

              LRM-00108: invalid positional parameter value 'as'

               

              IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

              IMP-00000: Import terminated unsuccessfully

              [oracle@localhost bin]$

              • 5. Re: Imp problem

                You didn't follow up what I wrote, didn't you?

                Compare my commandline and yours and note the difference.

                 

                -----------

                Sybrand Bakker

                Senior Oracle DBA

                • 6. Re: Imp problem
                  Osama_Mustafa

                  HuaMinChen wrote:

                   

                  Sorry, still get the same by this

                  [oracle@localhost bin]$ imp "mysch/mysch@xe as sysdba" file=/usr/share/mysch.dmp full=y

                  LRM-00108: invalid positional parameter value 'as'

                   

                  IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

                  IMP-00000: Import terminated unsuccessfully

                  [oracle@localhost bin]$

                   

                  sybrand answered you read carefully

                  • 7. Re: Imp problem
                    HuaMin Chen

                    sybrand_b wrote:

                     

                    You didn't follow up what I wrote, didn't you?

                    Compare my commandline and yours and note the difference.

                     

                    -----------

                    Sybrand Bakker

                    Senior Oracle DBA

                    Sorry, I still get these

                    [oracle@localhost bin]$ imp "mysch\/mysch@xe as sysdba" file=/usr/share/mysch.dmp full=y

                    LRM-00108: invalid positional parameter value 'as'

                     

                    IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

                    IMP-00000: Import terminated unsuccessfully

                    [oracle@localhost bin]$ imp 'mysch\/mysch@xe as sysdba' file=/usr/share/mysch.dmp full=y

                    LRM-00108: invalid positional parameter value 'as'

                     

                    IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

                    IMP-00000: Import terminated unsuccessfully

                    [oracle@localhost bin]$

                    • 8. Re: Imp problem
                      Sreejith_Nair

                      you should put a "\" ( escape the character"/" for unix) infront of your "/" in the command. You can read earlier solution provided carefully

                      • 9. Re: Imp problem
                        HuaMin Chen

                        Sreejith_Nair wrote:

                         

                        you should put a "\" ( escape the character"/" for unix) infront of your "/" in the command. You can read earlier solution provided carefully

                        Yes, I've already done that but I have got the same error.

                        • 10. Re: Imp problem
                          HuaMin Chen

                          Any other help to this?

                          • 11. Re: Imp problem
                            Hemant K Chitale

                            Why do you really need to use "AS SYSDBA" ?

                             

                            Hemant K Chitale


                            • 12. Re: Imp problem
                              HuaMin Chen

                              I cannot proceed with "imp" without "as sysdba". Thanks.

                              • 13. Re: Imp problem
                                Hemant K Chitale

                                AS SYSDBA connect as the SYS schema.  Your command line indicates that you are attempting to import a dump file for the "mysch" schema.  So why not connect as "mysch" only ?

                                 

                                 

                                Hemant  K Chitale


                                • 14. Re: Imp problem
                                  HuaMin Chen

                                  Sorry, I still get these

                                  [oracle@localhost bin]$ imp 'mysch\/mysch@xe as mysch' file=/usr/share/mysch.dmp full=y

                                  LRM-00108: invalid positional parameter value 'as'

                                   

                                  IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

                                  IMP-00000: Import terminated unsuccessfully

                                  [oracle@localhost bin]$ imp "mysch\/mysch@xe as mysch" file=/usr/share/mysch.dmp full=y

                                  LRM-00108: invalid positional parameter value 'as'

                                   

                                  IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

                                  IMP-00000: Import terminated unsuccessfully

                                  [oracle@localhost bin]$

                                  1 2 上一个 下一个