Zohar
In the name of the Rav, Rabbi Yehuda said that in the future, the Holy One, blessed be He, will rejoice with the righteous, and will let His Shechinah dwell among them. Everybody will rejoice in that joy, as it is written, "let Hashem rejoice in His works" (Tehilim 104:31). Rabbi Yehuda said that at that time the righteous will create worlds and raise the dead. Rabbi Yosi said to him: We have learned that "there is nothing new under the sun" (Kohelet 1:9). Rabbi Yehuda responded, Come and hearken. While the wicked are in the world and multiply, the whole world does not endure, but when the Righteous are in the world, it does endure. And in the future they will raise the dead, as it is written, "Old men and old women shall yet again dwell in the streets of Jerusalem, and every man with his staff in his hand for every age" (Zecharyah 8:4).
Zohar
Rabbi Chiya said that it is written, "There is nothing new under the sun" (Kohelet 1:9), but lo, this song is new and under the sun, for it will be under the sun. What is this new song? It is the moon (corresponding to Nukvah). For then the moon will be new under the sun. What is meant by the phrase, "For He has done marvelous things." What are these marvelous things? They are "His right hand, and His holy arm have gained Him the victory." "have gained Him the victory." For whom did they gain victory? For the grade that sang this song (i.e. the Holy Spirit). (The Nukvah) was supported by right and left, Therefore "His right hand...gained Him victory," the grade called psalm. When will that be? When the dead of the world rise from the dust, then what has not yet been done in the world will be new.