ORA-00904 invalid identifier

ORA-00904 invalid identifier :
In the cross machine through the examples of dblink access different database (A--B examples of two different physical machines), if the latter updates the table on the B machine (modify field names or add fields), then stored in the A instance references added these fields may appear ora-00904 error, solution table rename: the new name in the B instance, and then rename to the original name, and then re compiling instances in A process, OK!

Started by Sabrina at February 03, 2016 - 10:59 PM

CSDN is in need of spirit, such!
Ask questions after the process is recorded and sharing
In order to provide dinner for him and to facilitate their access to

Thank you, hope to maintain

Posted by Eden at February 11, 2016 - 11:34 PM

Recommend ha
Mainly want to recommend this spirit!

Posted by Eden at February 19, 2016 - 12:00 AM

This is the original solution.
Thanks for share

Posted by Taylor at February 25, 2016 - 12:29 AM

Thank you for sharing experience

Posted by Pamela at March 02, 2016 - 1:19 AM

The response to 2012-12-29 14:07:53 was removed by the administrator

Posted by Duncan at March 06, 2016 - 1:42 AM

Thank you for sharing experience

Posted by Charles at March 19, 2016 - 2:12 AM

Bunkers have

Posted by Peter at April 02, 2016 - 2:35 AM

Posted by Tommy at April 10, 2016 - 2:48 AM

The response to 2012-12-30 12:15:44 was removed by the administrator

Posted by Walter at April 21, 2016 - 3:43 AM

The response to 2012-12-30 12:15:44 was removed by the administrator

Posted by Walter at April 29, 2016 - 4:39 AM

Good good oh

Posted by Emily at May 13, 2016 - 4:55 AM

Thank you for sharing experience

Posted by Chad at May 16, 2016 - 5:30 AM

Posted by Sunny at May 26, 2016 - 6:22 AM

The response to 2012-12-31 10:39:26 was removed by the administrator

Posted by Jackson at June 05, 2016 - 6:36 AM

Study. Study.

Posted by Cinderella at June 18, 2016 - 7:05 AM

Learning to learn

Posted by Bart at June 27, 2016 - 7:27 AM

Dblink sometimes hear disgusting. I sometimes when creating tables using dblinc.Create table XXX as select * from xx@dlk_xx.

Insert data into the XXX table have field type mismatch errors.

Posted by Stephen at June 28, 2016 - 8:25 AM

China will have such talent technology is in a daze

Posted by Ella at July 10, 2016 - 8:50 AM

Thank you for sharing.

Posted by Woodrow at July 17, 2016 - 8:55 AM

Thank you for sharing experience

Posted by Amy at July 21, 2016 - 9:35 AM

This is the original solution.
Thanks for share

Posted by George at July 28, 2016 - 9:37 AM

The response to 2013-01-01 10:13:03 was removed by the administrator

Posted by Geoff at July 31, 2016 - 9:59 AM

Create table as some of the key information is easily lost
Beware of CREATE TABLE AS

Posted by Robinson at August 06, 2016 - 10:38 AM

Posted by Josie at August 15, 2016 - 10:43 AM

Thanks for sharing!

Posted by Jane at August 24, 2016 - 10:48 AM

Thank you very much, just need!

Posted by Tim at August 25, 2016 - 11:15 AM

Onlookers pass by

Posted by Dempsey at November 24, 2016 - 8:16 PM

The response to 2013-01-01 16:01:55 was removed by the administrator

Posted by Paul at November 29, 2016 - 8:35 PM

Thank you for sharing experience

Posted by Gene at December 06, 2016 - 8:55 PM

Thank you very much, just need!

Posted by Marvin at December 10, 2016 - 9:55 PM

Study

Posted by Zero at December 21, 2016 - 10:11 PM

Thank you for sharing experience

Posted by Boris at January 01, 2017 - 10:36 PM

Posted by Abner at January 06, 2017 - 10:40 PM

Posted by Bruno at January 12, 2017 - 10:39 PM