Home » SQL & PL/SQL » SQL & PL/SQL » Use Partition Name in select for remote database (Oracle10g)
Use Partition Name in select for remote database [message #351269] Tue, 30 September 2008 02:58 Go to next message
mrvafaei
Messages: 27
Registered: September 2008
Junior Member

Hi ,

I use partition name in my select command in local database ,
like :

select * from table_name partition(p_xxxx) ;

but i can't use partition name when i use DBLINK ,
Is it possible to use partition name when i selecting remote database tables ?
Re: Use Partition Name in select for remote database [message #351270 is a reply to message #351269] Tue, 30 September 2008 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session.

Regards
Michel
Re: Use Partition Name in select for remote database [message #351277 is a reply to message #351269] Tue, 30 September 2008 03:38 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link. You will understand why.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements009.htm#i165979

Regards

Raj

P.S : Please follow what @Michael has suggested.
Previous Topic: How to view the status of the constraints in a single table
Next Topic: deadlock detected
Goto Forum:
  


Current Time: Mon Dec 05 08:37:31 CST 2016

Total time taken to generate the page: 0.08126 seconds