OraFAQ Forum: Server Administration » Copying tables from one database to another database(urgent)

Home » RDBMS Server » Server Administration » Copying tables from one database to another database(urgent)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copying tables from one database to another database(urgent) [message #155545]

Tue, 17 January 2006 03:14

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

I am using following query :

SQL> copy from system/jetdb@jetora-
> to scott/tiger@jetora-
> create new_emp1-
> using select * from purchase;

it is showing some precision error,

how to solve this problem, i have number(4,2):

in db

Report message to a moderator

Re: Copying tables from one database to another database(urgent) [message #155547 is a reply to message #155545]

Tue, 17 January 2006 03:19

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Why dont you export that table from the old database and import it into a the new database??

Read Export/Import

Report message to a moderator

Copying tables from one database to another database(urgent) [message #155549 is a reply to message #155547]

Tue, 17 January 2006 03:33

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

the error is

ERROR:
ORA-01727: numeric precision specifier is out of range (1 to 38)

Report message to a moderator

Re: Copying tables from one database to another database(urgent) [message #155554 is a reply to message #155549]

Tue, 17 January 2006 04:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Look into these two discussions --

http://www.orafaq.com/forum/t/5593/0/

http://dbapool.com/thread.asp?id=810

hope it helps.

I got something like this from manuals

if you are copying between Oracle databases, a NUMBER 
column with no precision will be changed to a DECIMAL(38) 
column. When copying between Oracle databases, you should use 
SQL commands (CREATE TABLE AS and INSERT) or you should ensure 
that your columns have a precision specified.

[Updated on: Tue, 17 January 2006 04:24]

Report message to a moderator

Previous Topic:	small database
Next Topic:	Qouta

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 10:57:04 CST 2025