I am using Power Objects 2.02. In the sample mldata session I cannot change any views that already exist; I come up in a view mode only. This is also true of an ODBC connection to an Oracle 7 UNIX database (I haven’t upgraded to have direct Oracle 7 server support yet).
Also, I’m not able to rename objects in my session. Clicking on an object and getting its property sheet allows me access to the name of the object. At that point I can change the name, but then I can’t save it unless I change the name back.
One more thing: What is the best way to make a copy of a table (other than using SQL*Plus to do a “create table as …” ) from within Power Objects?
- You can’t change a view or rename a table through the ODBC connectionwith OPO. You can change a table name with a direct connection to Oracle.
- If you mean copying the structure of a table, you can open the tablewindow that displays the columns and their attributes for the table youwant to copy. Select all of the columns and copy them with the Copycommand from the Edit menu. Create a new table and paste the columndefinitions into the new table.
- If you want to copy a table and its data to a different database, youcan simply drag and drop the table from one database to another.
If you want to duplicate a table and its data under a different name, usingSQL*Plus is probably the most efficient way.