Re: expdp without password
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 27 Sep 2011 13:58:07 +0200
Message-ID: <4E81BA4F.3020005_at_nordea.com>
W dniu 27.09.2011 13:45, Joel.Patterson_at_crowley.com pisze:
>
> I was wondering if you can export, (expdp), without a password, (or wallet etc.) similar to using other utilities such as 'Sqlplus / as sysdba', or 'rman target /'?
>
> I have a password script and can create a centralized password file (unencrypted), but since I have been able to do most everything else without a password, I would rather not implement it just because of this issue.
>
> I've googled (with mixed results -- seen an answer that did not work). Did not find it (an example) in the manual.
>
> Best Regards,
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
expdp "userid='/ as sysdba'" dumpfile=test.dmp schemas=test
Date: Tue, 27 Sep 2011 13:58:07 +0200
Message-ID: <4E81BA4F.3020005_at_nordea.com>
W dniu 27.09.2011 13:45, Joel.Patterson_at_crowley.com pisze:
>
> I was wondering if you can export, (expdp), without a password, (or wallet etc.) similar to using other utilities such as 'Sqlplus / as sysdba', or 'rman target /'?
>
> I have a password script and can create a centralized password file (unencrypted), but since I have been able to do most everything else without a password, I would rather not implement it just because of this issue.
>
> I've googled (with mixed results -- seen an answer that did not work). Did not find it (an example) in the manual.
>
> Best Regards,
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
expdp "userid='/ as sysdba'" dumpfile=test.dmp schemas=test
for wallet works as well
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 27 2011 - 06:58:07 CDT