-
Originally posted by elaine3839:
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?
Try Import with table=tablename, rows=Y and ignore=y
-
Originally posted by elaine3839
2. How can I only import data but not schema when I use Oracle's Import utility?
Thanks!
imp user/passwd@servicename IGNORE=Y
http://www.oradoc.com/ora816/server....ch02.htm#25141
Sam
Thanx
Sam
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.
sonofsita
http://www.ordba.net
-
You can easily reduce the size of a column in oracle without affecting the data in the modifying column.
SQL> alter table column
example:
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 02: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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|