Re: export data
Here are some ways to do that:
1. export metadata with Export Data Pump (expdp with option metadata_only) and then create a SQL file with Import Data Pump (impdp using option SQLFILE). Then you can edit tables and columns definitions...
2. use DBMS_METADATA.get_ddl to get DDL Metadata for DB objects (Tables, Views etc.) and UTL_FILE to write that into file.
http://www.baze-podataka.net/
- Database Consultant & DBA -
Certified MySQL 5.0 DBA
Oracle 9i OCP DBA
Oracle 10g OCP DBA
Edited 1 time(s). Last edit at 11/21/2006 07:05PM by Dejan Topalovic.
Subject
Views
Written By
Posted
4946
October 23, 2006 06:23AM
Re: export data
2424
November 21, 2006 06:29PM
2451
December 04, 2006 02:11PM
2986
January 09, 2007 07:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.