Password invalid for sqlplus copy command but it is the correct password. Please guide me on it

Question

I am using this command .

COPY FROM username/[pwd]@identifier 
  INSERT SCHEMA_NAME.TABLE_NAME USING SELECT * FROM SCHEMA_NAME.TABLE_NAME;

and my password contains +, ) .

it is showing me this error ORA-01017.

The password and the username and all are other details are true.

Please help me on this and any guidance on it is deeply appreciated.

Answer 1

If your password has the special characters then in cmd.exe, it should be something like this:

username/\"password\"@tns_alias

here \" is used for denoting the double-quotes. so your password is wrapped in double-quotes.