Stack Overflow
Stack Overflow

Questions tagged [dbms-metadata]

An Oracle package that enables the retrieval of an objects metadata.

DBMS_METADATA enables the retrieval of an objects metadata as either XML or the creation DDL then to submit the XML to re-create the object.

Questions tagged DBMS_METADATA should always be tagged .

37 questions
0
votes
1 answer

Oracle's dbms_metadata.get_ddl for type DIRECTORY: invalid input value for parameter SCHEMA

When I try to call dbms_metadata.get_ddl('TABLE', 'MYTABLE', 'MYSCHEMA') either in the pl/sql block or in the package procedure it works fine. When I try to call dbms_metadata.get_ddl('TABLE', 'MYTABLE') (without schema explicitely provided) either…
igortche
  • 115
  • 1
  • 8
0
votes
1 answer

How to get the functions name used by a column in the whole database?

I have a view called employee_vw which contains the query below: select function_standard(ename) from employees; I want to find out which functions are applied on a column. I tried using select dbms_metadata.get_ddl('COLUMN','ENAME','HR') FROM…
Rak kundra
  • 168
  • 11
0
votes
2 answers

oracle ORA-31603 even when sysdba

I am connected by sqlplus with sys as sysdba to an oracle database 11.2.0.4 Enterprise edition. If I run the query : select DBMS_METADATA.GET_DDL ( 'TYPE' , 'SYS_PLSQL_9131_DUMMY_1' , 'SYS' ) from dual ; I get error the error *ORA-31603:…
RSA
  • 1
  • 2
0
votes
2 answers

How can dbms_metadata from Oracle produce constraints seprate from the table schema files?

Why is dbms_metadata.set_transform_param(dbms_metadata.session_transform, 'CONSTRAINTS_AS_ALTER', TRUE) not generating constraints in separate files? At this moment this pl/sql pastes the constraints after the table schema definition files. What…
Ronaldus
  • 29
  • 2
  • 7
0
votes
3 answers

Create a copy of a table with an additional column using dbms_metadata

You can get the DDL of a table by executing DBMS_METADATA.get_DDL('Table','TABLENAME'). I'm looking for a way to change the name of the table in the DDL and then execute the DDL to create an equivalent table with a new name and an additional…
Maxii
  • 695
  • 2
  • 13
  • 26
0
votes
1 answer

How do I properly use CONSTRAINTS_AS_ALTER for GET_DDL?

exec dbms_metadata.set_transform_param(DBMS_METADATA.SESSION_TRANSFORM, 'CONSTRAINTS_AS_ALTER', TRUE); SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner) FROM all_OBJECTS WHERE OWNER = 'USERNAME' AND OBJECT_TYPE = 'TABLE'; When I run…
Eric
  • 786
  • 1
  • 9
  • 16
-1
votes
1 answer

How to decrypt the password which is encrypted by oracle?

I want to decrypt the password which is encrypted by oracle 10g. The encrypted password like 'S:987DFSSDF9879SDFD80FSS0D8DFH8F0H77S;234SDFSF987FSDF34E'
Kannan Arumugam
  • 1,119
  • 2
  • 18
  • 27
1 2
3