OraFAQ Forum: Server Administration » the way DBMS_METADATA.GET_DDL can get the object's ddl from sybase database ?

Home » RDBMS Server » Server Administration » the way DBMS_METADATA.GET_DDL can get the object's ddl from sybase database ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

the way DBMS_METADATA.GET_DDL can get the object's ddl from sybase database ? [message #111955]

Tue, 22 March 2005 01:43

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi everybody !
i new to use this forum.
can i get sybase database objects ddl message from oracle 9i transparent ???
SQL> desc F_ORGAN@ok
ORGAN_ID NOT NULL CHAR(40)
ORGAN_NAME CHAR(60)
ORGAN_TYPE CHAR(40)
ORGAN_GRADE CHAR(10)
ORGAN_HIGH CHAR(40)
ORGAN_LEADER CHAR(10)
ORGAN_OFFICE CHAR(80)
ORGAN_TEL CHAR(20)
ORGAN_DESC CHAR(100)
ORGAN_IFHIGH CHAR(1)
ORGAN_BGNDATE DATE
ORGAN_ENDDATE DATE
ORGAN_BGNFILE CHAR(80)
ORGAN_ENDFILE CHAR(80)
ORGAN_REGION VARCHAR2(40)
ORGAN_RESPCNTR CHAR

note: @ok is link to sybase ase 12 version
when i use that :
SELECT DBMS_METADATA.GET_DDL@ok('TABLE','F_ORGAN') FROM DUAL;
some errors appear :
ORA-00904: "DBMS_METADATA"."GET_DDL":

how can i do ????

Report message to a moderator

Previous Topic:	Howto migrate a LOB type INDEX to another tablespace (ORA-02327)
Next Topic:	Problems with ORA-XXXXX Messages not in alert.log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:32:40 CDT 2024