How to copy a schema with another name but with same data?
It's a quite old database. Your SQL command creates new user.

You can use Export in order to copy contents of one schema to another.

exp FILE=$ORACLE_HOME/scott_export.dmp LOG= $ORACLE_HOME/scott_export.log OWNER=scott

Create new user as you have shown in your post and grant required privileges.
Then import it to new schema.

imp FILE=$ORACLE_HOME/ scott_export.dmp LOG= $ORACLE_HOME/scott_import.log FROMUSER=scott TOUSER=scott2

Details are here and here