I want to run Import tool with user system, i fail as you see below script:
D:\TÖÖ\exp_ddl.dmp>sqlplus system/[email protected] as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 4 16:40:58 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'a';
User altered.
SQL> quit;
Disconnected from Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
D:\TÖÖ\exp_ddl.dmp>imp userid=system/[email protected] file=exp_cas_ddl.dmp log=exp_ca
s_ddl.log full=y
Import: Release 10.2.0.1.0 - Production on Mon Oct 4 16:41:31 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername: system
Password:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon deniedUsername: SYSTEM
Password:
IMP-00058: ORACLE error 1017 encountered
ORA-01017: invalid username/password; logon denied
IMP-00005: all allowable logon attempts failed
IMP-00000: Import terminated unsuccessfully
D:\TÖÖ\exp_ddl.dmp>sqlplus system/[email protected] as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 4 16:41:53 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select sysdate from dual;
SYSDATE
---------
04-OCT-10
SQL> quit;
Disconnected from Personal Oracle Database 10g Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
D:\TÖÖ\exp_ddl.dmp>sqlplus system/[email protected]
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 4 16:46:13 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:I read following thread:
3691283
That didn't help much either i think.
What i want is to have one command that runs "Imp" and gives tns-database-name as input parameter and parameter user_id must be in pramaters. Can i run this way Import?