Home » RDBMS Server » Server Utilities » exporting database objects without tables
exporting database objects without tables [message #184936] Fri, 28 July 2006 15:35 Go to next message
sweet_angel
Messages: 4
Registered: July 2006
Junior Member
Hi all

is there any way that i can export all the objects in a database except the tables.

Regards
Re: exporting database objects without tables [message #184938 is a reply to message #184936] Fri, 28 July 2006 15:47 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
You probably want to take a look at the DBMS_METADATA package.
Re: exporting database objects without tables [message #185219 is a reply to message #184936] Mon, 31 July 2006 10:40 Go to previous messageGo to next message
sweet_angel
Messages: 4
Registered: July 2006
Junior Member
isnt DBMS_METADATA only for Oracle 9i and above. I have oracle 8i and i have a problem with the system tablespace so i am trying to get all the data from the database.

Thnx
Re: exporting database objects without tables [message #185226 is a reply to message #185219] Mon, 31 July 2006 11:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
OP wrote:
>> i have a problem with the system tablespace so i am trying to get all the data from the database.
OP also wrote:
>> is there any way that i can export all the objects in a database except the tables.
Which is true?
Whatever it is,
export with rows=n.
No data is exported. Just the table structures are exported.
Import in destination and drop the tables.

[Updated on: Mon, 31 July 2006 11:29]

Report message to a moderator

Re: exporting database objects without tables [message #185237 is a reply to message #184936] Mon, 31 July 2006 12:25 Go to previous messageGo to next message
sweet_angel
Messages: 4
Registered: July 2006
Junior Member
when i do an export
exp username/pwd file=bank.dmp

i get the error

. exporting synonyms
. exporting views
EXP-00056: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 1 (block # 1151)
ORA-01110: data file 1: '/home2/oradata/GPKA/system01.dbf'
ORA-27091: skgfqio: unable to queue I/O
Intel SVR4 UNIX Error: 5: I/O error
Additional information: 1150
EXP-00000: Export terminated unsuccessfully
$

at the end of the export. When i try importing this data into a new database only the tables with all the rows come back no views, procedures, triggers nothing else. What i want is any utility for 8i that can export jus the objects without the tables. The exp username/pwd file=bank.dmp rows=no gives the same error.

Thanx
Re: exporting database objects without tables [message #185239 is a reply to message #185237] Mon, 31 July 2006 12:30 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> ORA-01110: data file 1: '/home2/oradata/GPKA/system01.dbf'
Talk to your DBA.
Seems there is a block level corruption.
Or
Call Oracle support.
Previous Topic: Loading control file in SQL loader
Next Topic: Export Error
Goto Forum:
  


Current Time: Fri Dec 02 23:01:58 CST 2016

Total time taken to generate the page: 0.20218 seconds