SQLDeveloper Export Database broken?
raindogJun 10 2011 — edited Aug 10 2011I'm trying to export the DDL for a particular schema using SQLDeveloper 3.0.04. My only connection to the DBA is as SYS (I don't know the schema's password).
After selecting just that schema's tables/indexes, I find SQLDeveloper also exports everything owned by SYS. All the types of objects are checked (I want whatever is in that schema), but I only "move over" that schema's objects in the Specify Objects screen.
When the export runs, it outputs SQL to create ALL_, DBA_, etc. views, system packages, etc.
Is it impossible to export some other schema's DDL as SYS?
Export Summary
-- Files: Single File created using C:\Documents and Settings\someone\export.sql -
-----------------------------------------------------------------
Connection:somedb-sys
-----------------------------------------------------------------
DDL Options
Storage
Terminator
Pretty Print
Include BYTE keyword
Add Force to Views
-----------------------------------------------------------------
Tables
APPLICATION
(snipped for privacy)
-----------------------------------------------------------------
Views
All views will be exported.
-----------------------------------------------------------------
Indexes
IMAP_CODEXREF_18
(snipped for privacy)
-----------------------------------------------------------------
Package Spec
All package specifications will be exported.
-----------------------------------------------------------------
Package Body
All package bodies will be exported.
-----------------------------------------------------------------
Procedures
All procedures will be exported.
-----------------------------------------------------------------
Functions
All functions will be exported.
-----------------------------------------------------------------
Triggers
CACHE_SYNC_TRG
-----------------------------------------------------------------
Types
All types will be exported.
-----------------------------------------------------------------
Sequences
CACHE_SYNC_SEQ
(snipped for privacy)
-----------------------------------------------------------------
Materialized Views
All materialized views will be exported.
-----------------------------------------------------------------
Materialized View Logs
All materialized view logs will be exported.
-----------------------------------------------------------------
Synonyms
All synonyms will be exported.
-----------------------------------------------------------------
Database Links
All database links will be exported.
-----------------------------------------------------------------