Hi everybody,
Suppose, I have a table called PP32GLOT02_B, which is part of a database PP32GLOT02. 02 stands for Fiscal Year. Suppose, I found, that the fiscal year was assigned incorrectly and everything should be named ending on 03 (Fiscal Year 2003). How can I rename all these files and don't corrupt my database? Doing it in Explorer leads to errors while opening a database (though these errors could be resolved). I want to automate this process.
Would appreciate your ideas.
My own idea would be to create an empty clone of the table and append from the original one, but it seems like too complicated solution.
Thanks in advance.
If it's not broken, fix it until it is.
My Blog