|
|
|
|
|
|
| Re: exporting database objects without tables [message #185226 is a reply to message #185219] |
Mon, 31 July 2006 11:27   |
 |
Mahesh Rajendran
Messages: 10708
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
