Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ora-01858 populating a partitioned table with insert into ... select ...

User_DGTCCSep 16 2022

I have a table with a timestamp field. I created a second partitioned table - partitioned per month and with the same filed - with the timestamp field used in the "PARTITION BY RANGE" condition. When I insert into "partitioned table" from the initial table I get error 01858.
How should I deal with the timestamp field in my select?
Comments
Post Details
Added on Sep 16 2022
#sqlplus
6 comments
128 views