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
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.
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't execute a DDL on a remote database.

Regards
Michel
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.
Previous Topic: Multi Dimensional Array
Next Topic: NLS_COMP and NLS_SORT problems (merged)
Goto Forum:
  


Current Time: Sat Dec 10 19:01:07 CST 2016

Total time taken to generate the page: 0.07820 seconds