get create table statement [message #321515] |
Tue, 20 May 2008 10:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kowalsky
Messages: 37 Registered: May 2003
|
Member |
|
|
hi all,
given that I have dba privileges is there anywhere a table where I can get the create statement of a given table?
I could use desc table_name, and so on, nevertheless, is there a table where I can see the actual create table statement that was used when the table was created for the first time - and subsequent alter table statements,
thanks,
kowalsky
|
|
|
|
Re: get create table statement [message #321551 is a reply to message #321516] |
Tue, 20 May 2008 13:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kowalsky
Messages: 37 Registered: May 2003
|
Member |
|
|
thanks,
and I guess for Oracle 8i there's nothing I can try except a properly interrupted exp that will give me the ddl in some file on the filesystem somewhere ... which is out of the question for me though (i can't access the file system) - so I can't even launch an exp ...
Is there an equivalent dbms package in previous versions?
thanks,
kowalsky
|
|
|
|
Re: get create table statement [message #321559 is a reply to message #321557] |
Tue, 20 May 2008 13:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
kowalsky
Messages: 37 Registered: May 2003
|
Member |
|
|
ok,
thanks, makes sense.
still, i'm going to try one of those GUI things that get the script without you having to move a finger (well, a few clicks at most)(TOAD, sql developer ...) works just fine on ora 8i, the only thing is I lost my toad installation and apparently it is going to be a headeache to get it again.
thanks,
kowalsky
|
|
|