default value in the table columns is wrong after transporting tablespaces
Hi,
I have a problem with Transporting tablespace between databases:
My source server is:
Windows2008 32x Enterprise Edition SP1
Oracle32x 11.2.0.1
My Destination Server is:
Windows2008 64x R2 Standrad Edition
Oracle64x 11.2.0.1
Both servers have the same NLS parameters as follow:
SQL>
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
PARAMETER VALUE
------------------------------ --------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ -----
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
0