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!
Hello, Is there a way to change the display of DATE fields in the results data grid? Ours is displaying DD-MM-YYYY and we want it to display YYYY-MM-DD HH:MM:SS. Thanks.
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
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
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