difference between v$version and sm$version
Quote:
Originally posted by aarganesh
Hi,
I think the ideal solution, incase if you mean that U want to copy the entire database including the name sid etc, then it's better for you to just shutdown the database and copy all the control files, data files and the log files to another machine with the same location specified in the existing one. This way the copying becomes very very easy and acquires less time.
Rgds
Ganesh .R
Hi ganesh
I went through your suggestion of maintaining two databases, I have a question with you can you give me the details about the colums the view sm$version give when it is queried and also what is difference between v$version and sm$version