Home » SQL & PL/SQL » SQL & PL/SQL » 9i to 10g
9i to 10g [message #231858] Wed, 18 April 2007 11:30 Go to next message
jinga
Messages: 115
Registered: January 2003
Senior Member
I dont know in which forum to post. I posted here.

When i used export & import to bring data from oracle 9i to 10g, I saw strange primary key definitions. with table names starting with "BIN$K5TXU6MsFangRAAUTwELHg==$0' Any one have experienced this before??


ALTER TABLE "BIN$K5TXU6MsFangRAAUTwELHg==$0"
ADD CONSTRAINT "BIN$K5TXU6MjFangRAAUTwELHg==$0"
PRIMARY KEY (ITEM,MONTH,TREE_SID,PPI_SID)
ENABLE
VALIDATE
/

Re: 9i to 10g [message #231859 is a reply to message #231858] Wed, 18 April 2007 11:31 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
purge your recylebin.
Search forum for details.
Previous Topic: ORA-01858: a non-numeric character was found where a numeric was expected
Next Topic: build formula
Goto Forum:
  


Current Time: Tue Dec 06 10:37:03 CST 2016

Total time taken to generate the page: 0.10528 seconds