kalo memang ada table namanya rs di schema OSCAR, coba pake huruf besar RS
nya
On 12/21/06, Oscar Wilyanto <[EMAIL PROTECTED]> wrote:
>
> sama.. saya malah dapat pesan ini:
>
> SQL> select sys.dbms_metadata.get_ddl('TABLE','rs') FROM dual;
> ERROR:
> ORA-31603: object "rs" of type TABLE not found in schema "OSCAR"
> ORA-06512: at "SYS.DBMS_METADATA", line 1546
> ORA-06512: at "SYS.DBMS_METADATA", line 1583
> ORA-06512: at "SYS.DBMS_METADATA", line 1901
> ORA-06512: at "SYS.DBMS_METADATA", line 2792
> ORA-06512: at "SYS.DBMS_METADATA", line 4333
> ORA-06512: at line 1
>
> ----- Original Message -----
> From: Dany Agustiyanto
> To: [email protected] <indo-oracle%40yahoogroups.com>
> Sent: Thursday, December 21, 2006 3:17 PM
> Subject: Re: [indo-oracle] Show create table di Oracle
>
> kok saya coba qery tersebut error yah.
>
> ERROR at line 1:
> ORA-00904: invalid column name
>
> Indra Armansyah <[EMAIL PROTECTED] <indra%40hastinapura.com>> wrote:
> SQL> set long 10000
> SQL> SELECT sys.dbms_metadata.get_ddl('TABLE', 'NAMA_TABLE') FROM dual;
>
> Salam,
>
> Indra Armansyah
> [EMAIL PROTECTED] <indra%40hastinapura.com>
>
> ----- Original Message -----
> From: Oscar Wilyanto
> To: [email protected] <indo-oracle%40yahoogroups.com>
> Sent: Thursday, December 21, 2006 2:19 PM
> Subject: [indo-oracle] Show create table di Oracle
>
> Dear Masters,
>
> Apakah Oracle punya perintah untuk menampilkan SQL syntax pembuatan tabel
> yang sudah eksis? (di MySQL menggunakan 'show create table nama_tabel')
>
> Thanks in Advance,
> Oscar
>
> ----------------------------------------------------------
> This message contains confidential information and is intended only for
> the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete
> this e-mail from your system. E-mail transmission cannot be guaranteed to
> be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. MKD Group
> therefore
> does not accept liability for any errors or omissions in the contents of
> this
> message, which arise as a result of e-mail transmission. If verification
> is
> required please request a hard-copy version.
>
> MKD Group, www.mkdgroup.com
> ----------------------------------------------------------
>
> [Non-text portions of this message have been removed]
>
> ----------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.0.409 / Virus Database: 268.15.26/594 - Release Date:
> 12/20/2006
>
> [Non-text portions of this message have been removed]
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
>
> ----------------------------------------------------------
> This message contains confidential information and is intended only for
> the
> individual named. If you are not the named addressee you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately by e-mail if you have received this e-mail by mistake and
> delete
> this e-mail from your system. E-mail transmission cannot be guaranteed to
> be
> secure or error-free as information could be intercepted, corrupted, lost,
> destroyed, arrive late or incomplete, or contain viruses. MKD Group
> therefore
> does not accept liability for any errors or omissions in the contents of
> this
> message, which arise as a result of e-mail transmission. If verification
> is
> required please request a hard-copy version.
>
> MKD Group, www.mkdgroup.com
> ----------------------------------------------------------
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
