Oracle how to use dbms_metadata.get_ddl

I know both desc and dbms_metadata.get_ddl can describe a table,
to use desc,the command is :
SQL>desc table_name

so I don't know how to use dbms_metadata.get_ddl to describe a table,pls tell me.

Oracle error 4068 -- SYS.DBMS.METADATA has errors

I'm trying to export users and receive the following error:EXP-00056: ORACLE error 4068 encounteredORA-04068: existing state of packages has been discardedORA-04063: package body "SYS.DBMS_METADATA" has errorsORA-06508: PL/SQL: could not find program unit being calledORA-06512: at line 1EXP-00000: E ...

Oracle About dbms_metadata and alter table ddl for constraints

I've learned that by using dbms_metadata get_ddl and set_transform components you can easily generate scripts from definitions in the DB. For example, get table definitions with or without tablespace and constraints clause, etc.My question is:- Is it possible to generate a set of scripts much in the ...

Oracle clob to varchar2 + metadata + dbms_output = nothing:(

all! I am in trouble:) i don't know why am getting nothing, i expect either a result or an error, but not nothing.I want to print dll of an object in dbms_outputcreate or replace procedure tomkyte.buildConstraint(cons_name varchar2, cons_owner varchar2) authid current_userASstatement clob; begindbms ...

Oracle Application Server 10g Metadata Repository Creation Assistant

I can't download repca_90402_linux.cpio.gz. Page shows Error 404. ...

Oracle Personel 8i DBMS Packages

Is it possible to get the DBMS_OBFUSCATION_TOOLKIT package with Oracle Personel 8i? This contains the needed functionality for decrypring/encrypting information which is very usefull for storing passwords in the database. ...

Oracle Object Relational DBMS

How do we convert already existing RDBMS into ORDBMS?What are the advantages and disadvantagesnull ...

Oracle How to display database object DDL...

I am used to working with Teradata and on that database you can use the command show table <tablename> and it will display the DDL that was used to create that table. I know of the describe command used on Oracle via SQLPLUS. But the describe command doesn't show the DDL. Is there some command ...

Oracle Will this trigger (on a DDL statement) work?

I need to set up a trigger to audit whenever the application recompiles a stored procedure. So I assume that a trigger on CREATE will do the trick. But when I looked up trigger syntax, it says: "Restriction: You cannot specify as a triggering event any DDL operation performed through a PL/SQL proced ...

Oracle Is it possible to fire DDL queries from within a trigger?

In Oracle 8.0.5, Is it possible to fire DDL queries from within a trigger?e.g. when no. of rows is multiple of 1000, I wish to call a procedure which analyzes the table and finds the size of the table. I am getting :"ORA-04092: cannot COMMIT in a trigger" error message. ...

Oracle How to create a sequence DDL in a procedure

i have a simple question but i dont find a solution here.How to create a sequence DDL in a procedure ? ...

Oracle Upgrade Error with Metadata

Upgrading 1.3.9Got one error with Metadata --- is my env messed up ?WWV_FLOW_REGION_UPD_RPT_COLS 8 0 ERROR!NOT PROCEED ANY WITH THE REST OF THE UPGRADE until you confirm through the HTML DB discussion board on the Oracle Technology Network that it is OK to proceed.<< In Upgradeguide.htmlNote: ...

Oracle issue in DBMS.SCHEDULER procedure

I am using 10g's new dbms_scheduler package. I created a job using the 'create_job' procedure like the following to call a SP written by me. --exec dbms_scheduler.create_job(job_name=>'test100',job_type=>'STORED_PROCEDURE',job_action=>'testsaji');where 'testsaji' is the SP which takes 2 arg ...

Oracle ORA-14552: cannot perform a DDL in a execute immediate - proc

I am trying to disable triggers in a stored procedure:PROCEDURE Alter_trigger_DISBALEISBEGINexecute immediate ('alter trigger BEI_INS_MY DISABLE');END;I get the following error:ORA-14552: cannot perform a DDL, commit or rollback inside a query or DMLIs there a solution for this problem ?Best ...

Oracle question about triggers, commit and ddl

I need a trigger (I am unexperienced about them) that after updating a field in a table will call a procedure that will execute ddl statements (creating and/or dropping partitions)The question is (release 8.1.7):- How can I force the commit to be done in the trigger before calling the procedure? ...

Oracle Anyone use ERwin to generate DDL scripts

Anyone use ERwin to generate DDL scripts.Currently I am using ERwin to generate the table creation script but when it try to create FK constraint, the reference table column is missing. Anyone know whether ERwin does not support or I had missed out some setting or configuration?ALTER TABLE XXXADD ( ...

Oracle Trying to recover metadata from a lost DB

We lost a DB instance and cannot recover. Ops replaced the broken disks and restored datafiles from backup, but "recover datafile..." for a specific datafile fails with OAR-01113 (file 89 needs media recovery). It calls for a file called arch1_120544.dbf which it (and I) cannot find.Anyway....What I ...

Oracle can htmldb store metadata for several instances?

can i set up an oracle instance whose sole purpose is to serve as the repository for htmldb metadata, and then i can use that central htmldb installation to develop and run applications across multiple oracle instances on other hosts? Or do i have to have htmldb installed on every oracle database th ...

Oracle Russian Local coordinate metadata

I have got some data from russia which is in local co-ordinate syetem. doe any body have any metadata information about the Russian coordinate system ? i need to convert it to WGS84.any help or link or calculation would be great. ...

Oracle ORA-20001: Excel load run ddl error:

When i am trying to create new table from CSV file than it gave me this error messageORA-20001: Excel load run ddl error: drop table "FILEONE1PTF1" ORA-00942: table or view does not exist ORA-20001: Excel load run ddl error: create table "FILEONE1PTF1" ( "CLIENTID" NUMBER, "APP_PROFIT_IND_IRS" VARCH ...

Oracle Stop session from commit whenever DDL command takes place

After DDL command the session is commited, we know.But I don't want to let the session to commit.Pls reply immediately. ...

Oracle how to delete metadata

hii ran the following script:CREATE TABLE TREE(DR_ID number(11) not null,POINT mdsys.sdo_geometry,primary key (DR_ID))pctfree 10 pctused 40 initrans 1 maxtrans 255 STORAGE ( initial 5120K next 1024K minextents 1 maxextents 2147483645 pctincrease 0 )TABLESPACE "USERS";INSERT INTO USER_SDO_GEOM_METADA ...

Oracle how to get "create database" ddl

How do I generate the DDL needed to create the database again? I can connect to the intance, and would like to reverse engineer the "create database" code. How? ...

Oracle 9.2.0.6 Change DDL Rule - When to reinstantiate

I am in the process of altering one of the DDL rules of a capture process. I am a little confused to when i should reinstantiate the objects captured. I am only changing the objects types captured in a DDL rule e.g to only capture objects of type index and table. Do i need to reinstantiate all the t ...

Oracle Snapshot refresh DBMS Jobs

I have a snapshot scheduled to refresh every hour. I have noticed that job is actually not running every hour. Here is an example of what i am trying to explain.DECLAREX NUMBER;BEGINSYS.DBMS_JOB.SUBMIT( job => X ,what => 'dbms_refresh.refresh(''"Schema"."FLODS_RENEW_MV"'');',next_date => TO ...

Oracle Question About Geodetic Metadata

Just a quick question about geodetic metadata.I'm wondering why the documentation says SDO_LB and SDO_UB should be set to -180 and 180 for longitude and -90 and 90 for latitude. Is this just to accomodate geodetic around the globe? Is there any reason I shouldn't set SDO_LB and SDO_UB to values othe ...

Oracle Way to extract only the DDL out of an 8i Database?

Is there a way in Oracle 8i to extract only the DDL (using a package, etc.) of a database? I know this can easily be done in 10g with Data Pump, but I have to have this done in 8i. ...

Oracle Exporting all schemas MetaData

Can any one tell me how to export all schemas metadata only. I have some partitioned tables/indexes and have 700+ tablespaces. I am using Oracle 10g.I have used this statement for export. Is this correct?expdp directory=dumps dumpfile=oraedwp_fkhalid.dmp logfile=oraedwp_fkhalid.log schemas=FKHALID,s ...

Oracle incorrect results from metadata query after adding an index

I have noticed some strange behavior running dbxml 2.2.13.Using dbxml:create a containeradd a documentadd metadata to documentquery the metadata to get a resultup to this point everything works fine. The query on the metadata is bringing up valid results.Now:add a default index: node-metadata-equali ...

Oracle will the backup metadata older than 10 days be deleted automatically?

If the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 10, will the backup metadata older than 10 days be deleted automatically?----No.151 ...

Oracle Will the backup metadata older than 10 days be deleted automatically?

If the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 10, will the backup metadata older than 10 days be deleted automatically?----No.151 ...