| Exp/Imp data from table containing BLOB column..? [message #154438] |
Sun, 08 January 2006 08:38 |
mbadawy
Messages: 1
Registered: January 2006
Location: Dubai
|
Junior Member |
 
|
|
Hi all.
I Have emp table,and it includes a BLOB column to store the employee photo.
when i am going to issue an export against that table it gives an error: there was no storage definition for emp table.
the create statement for that table was :
create table emp(
empno NUMBER(4)
,ename VARCHAR2(30)
....
....
,ephoto BLOB);
the error will appear if you are going to issue this command:
exp userid=scott/tiger@dev file=c:\bcp.dmp tables=emp
.....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
