473,394 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

sqlplus copy

58
Hey all, I know its from oracle ~8.. but i find myself using sqlplus copy pretty often to move tables between instances on the fly. The one thing that is perplexing me is that it doesn't seem to like decimal numbers (ie it always truncates them) searched google and haven't had any luck yet. Anyone know if there is a solution for this?
Thanks ahead of time.
Eric
Nov 6 '08 #1
3 2993
amitpatel66
2,367 Expert 2GB
Can you tell me what is the data type of the decimals you are trying to copy? Is it NUMBER or NUMBER with scale and precision?
Nov 7 '08 #2
erbrose
58
its a generic number (no precision or scale set) hmmm will give that I try and see what happens.
well tried it already and yes it worked, will just have to set numbers to the proper precision and scale.
Thanks so much
Nov 7 '08 #3
amitpatel66
2,367 Expert 2GB
Alright. great that your issue is resolved
Nov 10 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Rick | last post by:
I am installing Oracle 9i client runtime on AIX 5.1-003. The installation completes successfully, but neither the Net Configuration Assistant or SQLPLUS will run. I get the following error when...
0
by: Yves | last post by:
I want to run sqlplus from command line and I'm having a bit of trouble... what I want to do is this.. sqlplus <username>/<pass> "contents of filename.sql" I know how to run it command...
4
by: tommy | last post by:
I'm running sqlplus from a DOS command line and inducing an error by purposly giving it the wrong script (hence, it cannot find the script file.) What it is doing is exiting to the SQL> prompt as...
2
by: massimo874 | last post by:
Please some one can tell me wich is the SQLPlus default script directory an how I can set it. I tryed by 'Define' but SQLPlus don't find the scripts I give it in input. WinXP, ORACLE 9i.
3
by: 91YJ_Renegade | last post by:
why can I TNSPING but I can not connect using SQLPLUS? Oracle 10g Slackware 10 install 2.6.6 kernel exports ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle/product/10g ORACLE_SID=ora9i...
0
by: tyousaf | last post by:
Hi i am new to mysql and mysql++, i have installed mysql server, it is running fine. i also installed "mysql++-1.7.9gcc3.2-2.i386.rpm" (i have gcc 3.3) , first of all as the readme file says to do...
0
by: tngoe | last post by:
echo "" echo "Enter person ID:" read person_id sqlplus -silent '/nolog'<<end_sql1 connect useract/passwd start $BANNER_LINKS/gurlsid.sql $person_id FAISMGR end_sql1 cat person.lst...
0
by: Mark D Powell | last post by:
getamit23@rediffmail.com (Amit Kapoor) wrote in message news:<c33bca54.0307090046.7698321f@posting.google.com>... The Windows version of sqlplus should be part of the Oracle client install for...
3
by: draffe | last post by:
This is not a sqlplus script problem per se but I don't know where else to go with my problem. I use wordpad to record my sqlplus script, then copy and paste it into the sqlplus prompt. I've run...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.