Home » RDBMS Server » Server Administration » Error during in creating partitioning table (merged 3)
Error during in creating partitioning table (merged 3) [message #399819] Fri, 24 April 2009 04:04 Go to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Hi ,

I am getting the following error when I run this DDL.
SQL> CREATE TABLE traffic_hit
  2  (
  3    site_id                                varchar2(40),
  4    country                                  varchar2(40),
  5    country_carrier_id               number,
  6    code_type                                number,
  7    page_request                             number default 0,
  8    valid_page_request               number default 0,
  9    ad_request                               number default 0,
 10    valid_ad_request                 number default 0,
 11    page_impressions                         number default 0,
 12    ad_impressions                   number default 0,
 13    request_date                             timestamp
 14    )
 15    partition by list(to_char(request_date,'D'))
 16    (
 17    partition traffic_hit_sun values (1),
 18    partition traffic_hit_mon values (2),
 19    partition traffic_hit_tue values (3),
 20    partition traffic_hit_wed values (4),
 21    partition traffic_hit_thu values (5),
 22    partition traffic_hit_fri values (6),
 23    partition traffic_hit_sat values (7)
 24    ) ;
  partition by list(to_char(request_date,'D'))
                           *
ERROR at line 15:
ORA-00907: missing right parenthesis



I have checked the no of opening and closing parenthesis, they are matching. But still I am getting this error.

Please give me suggestions , how to get out of it.

Thanks
Re: Error during in creating partitioning table (merged 3) [message #399841 is a reply to message #399819] Fri, 24 April 2009 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot use a function there, only a column name.

Regards
Michel
Re: Error during in creating partitioning table (merged 3) [message #399846 is a reply to message #399841] Fri, 24 April 2009 04:48 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks for you timely response.

If I have to create partitions by day of a week , then how can I do that?

Please give me suggestion.

Thanks
Re: Error during in creating partitioning table (merged 3) [message #399848 is a reply to message #399846] Fri, 24 April 2009 04:49 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Add a new column with this information.

Regards
Michel
Previous Topic: Moving files in ASM
Next Topic: Oracle 11G command line create database command (merged)
Goto Forum:
  


Current Time: Wed Dec 07 18:57:09 CST 2016

Total time taken to generate the page: 0.12022 seconds