Home » SQL & PL/SQL » SQL & PL/SQL » creating table in remote database (oracle9i)
creating table in remote database [message #293203] Fri, 11 January 2008 03:39 Go to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
Hi,

can anybody help me to provide correct syntax for creating table on remote database?

regrads,
kaushal

Report message to a moderator

Re: creating table in remote database [message #293212 is a reply to message #293203] Fri, 11 January 2008 03:57 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member
Need to used DATABASE LINK

Thumbs Up
Rajuvan.

Report message to a moderator

Re: creating table in remote database [message #293215 is a reply to message #293203] Fri, 11 January 2008 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't execute a DDL on a remote database.

Regards
Michel

Report message to a moderator

Re: creating table in remote database [message #293226 is a reply to message #293203] Fri, 11 January 2008 04:30 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member
I am too silly sometimes Sad Sad Sad

Thumbs Down
Rajuvan.

Report message to a moderator

Previous Topic: Multi Dimensional Array
Next Topic: NLS_COMP and NLS_SORT problems (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 13 03:31:50 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.