For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi, could you please advice when is the UDT will be finally supported? There were some rumors for the first half of 2021. Is this still the case, or later?. Many thanks in advance and rgds, Alexander
Hi, Please execute this making appropriate substitutions for VIEW_NAME and VIEW_OWNER:
select dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'VIEW_OWNER') from dual;
Or you can try:
SELECT VIEW_NAME, TEXT FROM USER_VIEWS;
Hi, I tried the first one but have problems to replace accordingly. So, I put:
select dbms_metadata.get_ddl('ALL_VIEW_SOURCE', 'ALB') from dual;
But who is meant by owner? Is it the username which is used to establish the connection? The host name? Connection Name? "Dual" should be used as given? Thanks!
undefined (0 Bytes)undefined (0 Bytes)In your case, please try this:
select dbms_metadata.get_ddl('VIEW', 'ALL_VIEW_SOURCE', 'AWS_DEV_ALB') from dual;
Thanks, it took me one step further. I right clicked on AWS_DEV_ALB -> "open new sql file" and pasted what you provided:
I right click on the query and "execute sql" but all I get is: If that's relevant, the structure is: The view I want is in "Relational Views" file order.
You greyed out the view name, so I cannot check to see if you have a typo which is the first thing I would suspect. Did you give the view name in all caps, surrounded by single quotes? Maybe you can create a view called TESTVIEW and run this again using 'TESTVIEW' as the second parameter and share the full error message without greying it out. Finally, please issue: select owner from ALL_VIEWS where VIEW_NAME ='NAMEOFYOURVIEW';
If that is NOT AWS_DEV_ALB then you will need to change the pl/sql block accordingly.
The owner it was. With your second view I got the owner, changed it and it worked. Thank you very much for your patience! Just for clearance and everybody else who might have problems with it. Owner is the name you fill in to connect to your database. What I used before - and what didn't work - was the name I gave for the connection.