Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Excel Formating downloaded from Oracle

3188003Mar 1 2016 — edited Mar 1 2016

Hi i have a problem. I am downloading an excel file from oracle and changes the format of number contained in the excel file. For example assume that the excel file contains bank account numbers which should be in the following format 15927.2405. 25001. However when the excel file is downloaded from Oracle it changes the format considering the bank accounts as numbers and turns them into the following format 1.592.724.052. etc. Do you know how i can solve this? Is it a setting that needs to be changed in Oracle or in Excel?

Comments

top.gun

OMG - where do I start!

If you are using Oracle for commercial purposes then you or your client needs a licence from Oracle. So really you should stop now.

Once you have your licence from Oracle, you can do a simulated import (ie show metadata) like this:

imp ar/live show=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Then if the above works you can do the real import (ie metadata and data) like this:

imp ar/live full=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Dean Gagne-Oracle

You can always use

imp help=y

to give you the available commands and options.  If you only want the data, then you can use:

imp user/password file=your_file.dmp rows=y

Hope this helps.

Dean

Lisa-Oracle

Hi AJVinkles,

You need to add ignore=y since the table pre-exists

Using IGNORE=y instructs Oracle to ignore any creation errors during the import

and permit the import to complete.

imp user/password file=  log= FROMUSER= TABLES=  ignore=y

rows=y as stated above is the default so it is not needed in the command

Regards,

Lisa

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 29 2016
Added on Mar 1 2016
0 comments
89 views