Originally posted by elaine3839:
Try Import with table=tablename, rows=Y and ignore=y
However, the import failed because it tried to recreate the table while the table's definition is already there.How can I only import data but not schema when I use Oracle's Import utility?
imp user/passwd@servicename IGNORE=Y
Originally posted by elaine3839
2. How can I only import data but not schema when I use Oracle's Import utility?
Life is a journey, not a destination!
while doing the import if you have a precreated object in the database then set the parameter in the import IGNORE=Y
which means that if the object is already in existance you need not to pop up the object existance message and terminate the import process.
You can easily reduce the size of a column in oracle without affecting the data in the modifying column.
SQL> alter table column
SQL> alter table employee column emp_name varchar2(12);
If your data size in the modfying column is greater than your reduced new size then it won't change rather it will display an error message "cannot decrease column length because some value is too big".
Last edited by ArjunRaghu; 03-07-2013 at 01:29 PM.
Not only is your advice not helpful, it is also 12 years too late. If you want to post, look for something that has been updated within this decade...
Also as the original poster mentioned, the column set to 12 bytes, so sizing it to what it is won't change anything.
this space intentionally left blank
Click Here to Expand Forum to Full Width