-
Export/Import issues
I am attempting to export a table,change a couple of data types the import the table. I am getting variuos errors (on the import) Oracle 1401,ORACLE 2298. What I think I need to do is export the data,drop the table, run script to recreate the table with the changes to the data type then import the data only. What setting in IMPORT allows you to only imort the data?
-
Ignore it?
Try:
IGNORE=Y
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
and if you are using impdp then ...
table_exists_action=ignore
also need to double check the data type changes. if you reduce the value for ex. varchar2(20) to varchar2(10) import will fail.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
I have that in the import script already.
imp adbase/adbase@alan file=110909.dmp ignore=y fromuser=adbase commit=y constraints=n destroy=n buffer=10240000 log=ADBASE_IMP_AOADORD.log
-
I am changing the data type from FLOAT(126) to VARCHAR(20) would that cause a problem?
-
what is the max length or the column with float data type?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Not sure how to determine that
-
select length from ;
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
select length (float_data_type_column_name) from table_name;
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
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
|