| FlyBean 2005-10-27, 8:21 am |
| Hi Sybaser:
The following comes from bcp's output(under linux):
> usage: bcp [[db_name.]owner.]table_name[:slice_num] [partition pname] {in | out} [filename]
> [-m maxerrors] [-f formatfile] [-e errfile]
> [-F firstrow] [-L lastrow] [-b batchsize]
> [-n] [-c] [-t field_terminator] [-r row_terminator]
> [-U username] [-P password] [-I interfaces_file] [-S server]
> [-a display_charset] [-z language] [-v]
> [-A packet size] [-J client character set]
> [-T text or image size] [-E] [-g id_start_value] [-N] [-X]
> [-M LabelName LabelValue] [-labeled]
> [-K keytab_file] [-R remote_server_princi
pal]
> [-V & #91;security_options
]] [-Z security_mechanism] [-Q] [-Y]
> [--maxconn maximum_connections]
[--show-fi] [--hide-vcc]
While refer to the "Beta Feature Description, Volume 3: Partitions", the syntax is:
> bcp [[database_name.]owner.][view_name | table_name[:partition_id | ptn_name_clause]] {in | out} & #91;datafile_clause]
[--maxconn max_parallel_connect
ions]
Of course, the one from the manual is correct.
BTW, it seems the bcp does not bcp the assigned partition out, it does bcp all
datas. The following is the output of sp_helppartition:
> 1> sp_helpartition XXXXX
> 2> go
> name type
> partition_type partitions
> partition_keys
> ------------------------------------------------ ----------------
> -------------- -----------
> --------------------------------------------
> XXXXX base table
> range 2
> rangeColumn
>
> (1 row affected)
>
> partition_name partition_id pages segment
> create_date
> ---------------------------- ------------ ----------- ----------------
> --------------------------
> PART1 896003192 8963 seg1
> 十月 18 2005 11:37AM
> PART2 912003249 38225 seg2
> 十月 18 2005 11:37AM
>
> Partition_Conditions
> --------------------------------------------------------------------------------
> VALUES <= ('440000')
> VALUES <= ('440599')
>
> Avg_pages Max_pages Min_pages Ratio(Max/Avg)
> Ratio(Min/Avg)
> ----------- ----------- ----------- ---------------------------
> ---------------------------
> 23594 38225 8963 1.620115
> 0.379885
> (return status = 0)
And the row_count()'s output is:
> 1> select row_count(4,57600205
2,896003192)
> 2> go
>
> ---------------------
> 43838
>
> (1 row affected)
> 1> select row_count(4,57600205
2,912003249)
> 2> go
>
> ---------------------
> 210648
FlyBean
|