Database DataWarehousing (MOSC)

MOSC Banner

default value in the table columns is wrong after transporting tablespaces

edited Nov 21, 2013 12:29AM in Database DataWarehousing (MOSC) 8 commentsAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center