Export utility EXP where user id contains character DOT
Hello all,
On Windows, I have an user account 'joe.smith'. This user created adatabase, and the schema name = 'joe.smith'. It is working well. Connecting to the database via sqlplus is fine, for example:
sqlplus "\"joe.smith\"/password@TESTDB"
SQL>select * from "joe.smith".TABLE1;
However, if we tried to export a table, the USERID in the EXP utility seems not happy with the 'dot'. We've been trying different ways:
[1]
EXP "joe.smith"/password@TESTDB "TABLES=("joe.smith".TABLE1)" INDEXES=N FILE=TABLE1.OUT
EXP ""joe.smith"/password@TESTDB" "TABLES=("joe.smith".TABLE1)" INDEXES=N FILE=TABLE1.OUT
Export: Release 11.1.0.6.0 - Production on Fri Jun 3 23:02:44 2011
On Windows, I have an user account 'joe.smith'. This user created adatabase, and the schema name = 'joe.smith'. It is working well. Connecting to the database via sqlplus is fine, for example:
sqlplus "\"joe.smith\"/password@TESTDB"
SQL>select * from "joe.smith".TABLE1;
However, if we tried to export a table, the USERID in the EXP utility seems not happy with the 'dot'. We've been trying different ways:
[1]
EXP "joe.smith"/password@TESTDB "TABLES=("joe.smith".TABLE1)" INDEXES=N FILE=TABLE1.OUT
EXP ""joe.smith"/password@TESTDB" "TABLES=("joe.smith".TABLE1)" INDEXES=N FILE=TABLE1.OUT
Export: Release 11.1.0.6.0 - Production on Fri Jun 3 23:02:44 2011
0