table creation

Dave Henley -

  Sorry, Dave, there is no data dictionary table that will show the text of a CREATE TABLE command the way USER_VIEWS does with views. It isn't that the information isn't there, but it is spread out among four or five different dictionary tables. However, see if you can get a copy of the latest IOUG Utility Disk. It is packed with useful stuff *including* scripts that will recreate CREATE commands from the data in the data dictionary.

As for exporting a User's data dictionary: Please understand that the USER_ tables are really views of the underlying data dictionary tables, which are owned by SYS. Only the definitions of SYS's tables are ever EXPorted; the data is recreated in an IMPort by re-executing the CREATE commands. So you can't really EXPort a user's data dictionary, the closest you can come is to EXPort a User with the ROWS=N parameter. This puts the CREATE commands for the user's objects in the exported file but not the data.

By the way, some people strip the non-human-readable parts of export files to reveal the commands inside them, like CREATE. The readable text needs reformatting to be understandable - it is all jammed together with no spacing - but is an alternative way of recreating the original CREATE commands. Received on Sun Mar 19 1995 - 17:39:53 CST