Here are several possible solutions.
1). INSERT INTO <new_empty_table> (<column1, column2)
SELECT *
FROM <old_table>;
Another solution.
2). Quick solution. Export the data in the <old_table> into a delimited file like comma. Write a control_file and use SQL*Loader to load the data...
This problem typically occurs when you are not part of the administrators group on W2K Server. If you're not either add yourself or have the administrator add you to the administrators group.
In addition to Robbie's response once you discover the node and database. Click on System on the top navigation bar and select Preferences. Go through the tabs, however, pay attention to the last tab Preferred Credentials.
Make sure you supply your login information for the node, and the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.