logo
down
shadow

How to mention schema name in dbms_metadata.get_ddl


How to mention schema name in dbms_metadata.get_ddl

Content Index :

How to mention schema name in dbms_metadata.get_ddl
Tag : oracle , By : user179938
Date : November 28 2020, 09:01 AM

With these it helps If I want to run this statement in SYS_LEE schema.
select dbms_metadata.get_ddl('PROCEDURE', 'PROCEDURE_NAME', schema => 'SCHEMA_NAME') from dual

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

What Oracle privileges do I need to use DBMS_METADATA.GET_DDL?


Tag : oracle , By : Tonci Grgin
Date : March 29 2020, 07:55 AM
may help you . Read this document, but basically, you need SELECT_CATALOG_ROLE
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_metada.htm#i1016867

Generating DDL script for object without schema name baked in using DBMS_METADATA.GET_DDL?


Tag : oracle , By : druta
Date : March 29 2020, 07:55 AM
may help you . How can I generate the DDL script for my object with DBMS_METADATA.GET_DDL without the schema name baked in? , Use SET_REMAP_PARAM with the REMAP_SCHEMA option:
DBMS_METADATA.SET_REMAP_PARAM(th,'REMAP_SCHEMA','HR',NULL);

dbms_metadata.get_ddl not working


Tag : sql , By : LucaN
Date : March 29 2020, 07:55 AM
hop of those help? From the dbms_metadata documentation:

Customized Table DDL from dbms_metadata.get_ddl


Tag : oracle , By : beebob
Date : March 29 2020, 07:55 AM

Any alternative way of DBMS_METADATA.GET_DDL


Tag : sql , By : KT.
Date : March 29 2020, 07:55 AM
like below fixes the issue The only scenario in which we need to run DBMS_METADATA.GET_DDL() is when we're working with a database whose schemas are not under proper source control. This is a bad situation and one which a DBA ought to want to improve.
So, you need to get the DBA on your side. This should be easy if the purpose of your request is to get the database into source control, that is, this is a one-off exercise and safe development practices are being put in place to ensure that all future changes to the database will be tracked under source control.
Related Posts Related QUESTIONS :
  • Is there any major impact if we don't add tablespace clause while creating the table or indexes in oracle?
  • how to I unload a 300 million row table in Oracle
  • Multi-column Index Using Only First Column
  • Performance issue - will collections improve perf?
  • How to initialize variables in oracle before next iteration of the loop?
  • query to change the date format in the column
  • To other users, How to hide the Oracle object owner of a table
  • Shared code for multiple specific exceptions in PL/SQL
  • Convert LONG format to DATE without a function
  • I want to write a procedure with input parameter as single or multiple values and return a ref cursor as per the input
  • Procedure as an argument in PL/SQL
  • Encrypt 3DES on oracle, decrypt doesn't work on DB2
  • Grant table pass on other users in Oracle
  • How to remove a strange table named "BIN$c+eOnMB3RbKSEfg/rsxtAQ==$0" from oracle database?
  • Replace string between characters using regx_replace
  • I have problems importing tables from DUMP files into an Oracle database
  • How to improve the performance of this insert statements for huge data ingest?
  • How to create new table and insert using function in plsql?
  • Inserting selected data from table in one schema into another table in a different schema
  • Unique constraint without index
  • ORA-06550: line 7, column 2: PLS-00306: wrong number or types of arguments in call to 'SALE'
  • PL/SQL Bind Variable in an Insert Statement ,
  • oracle Cursor + FORALL taking time
  • How to manually generate a log file the same as SQL*Plus spool results
  • Need help in converting Oracle trigger to PostgreSQL
  • ORACLE11g autoincrement
  • Impact of Dropping low selectivity indexes in oracle
  • How do I set up a New Connection for a personal-use Oracle Database?
  • FORALL and sql%rowcount when FORALL is never entered
  • Column aliasing while copying a table in oracle
  • Oracle table column contain $
  • Why Oracle changes rowid with fetch?
  • sql statment in email messge utl_mail.send
  • Remove extra space
  • error while building a view on Application designer "invalid number of column names specified "
  • How can I silence SQLPlus compilation warnings?
  • Strange behaviour of PB
  • Save Package body and Spec
  • Oracle: using Automatic List Partitioning with Range Subpartitioning
  • How to capture SQL fired from Business Object Deski
  • Select Count from sub table in Oracle
  • Building oracles for hyperledger composer
  • Oracle iterates thru values on columns (Oracle 11)
  • How to transfer from one to another PC
  • how to configure oracle job to run at every minute of 00 second
  • I don't know what's bad in my SQL (in Oracle SQL Developer)
  • What is the purpose of this package?
  • execute immediate a pl/sql that having execute immediate
  • replace function in dml statements in oracle 8i
  • DBMS_OUTPUT.NEW_LINE and DBMS_OUTPUT.NEW_LINE() difference?
  • Can someone explain ORA-29861 error in plain english and its possible cause?
  • Simple oracle backup without using exp or expdp
  • Variable declared with variable keyword in sql plus(oracle 9i)?
  • optimizing oracle query
  • Customer Support Identifier-How to get this?
  • Display query results like \G in MySQL when using Oracle / sqlplus?
  • Does vsize give the correct result for number?
  • How to generate alphanumeric id in Oracle
  • to_date function pl/sql
  • How can I create a "dynamic" WHERE clause?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com