object所在的datafile offline后, status 仍然是usable

本文展示了如何使用SQL查询特定索引(IDX_ACCOUNTUNLOCKEX_ORDERID)的所有分区名称及其状态,确认所有分区均处于可用状态。

SQL> select index_name, partition_name, status from dba_ind_partitions
  2  where index_name = 'IDX_ACCOUNTUNLOCKEX_ORDERID';

INDEX_NAME                     PARTITION_NAME                 STATUS
------------------------------ ------------------------------ --------
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_10B               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_10A               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_09B               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_09C               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_10C               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_11A               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_11B               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_11C               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_12A               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_12B               USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_2009_12C               USABLE

INDEX_NAME                     PARTITION_NAME                 STATUS
------------------------------ ------------------------------ --------
IDX_ACCOUNTUNLOCKEX_ORDERID    CDRTIME_MAXVALUE               USABLE

12 rows selected.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10173379/viewspace-617787/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/10173379/viewspace-617787/

我想用requetst提取出这里面的orderKey,帮我找找看他具体在什么位置{'status': 200, 'msg': 'success', 'data': {'storeFreePostage': 1000000, 'virtual_type': 0, 'valid_count': 1, 'deduction': False, 'addressInfo': {'id': 5, 'uid': 2, 'real_name': '阿阿阿鱼', 'phone': '15088888888', 'province': '北京市', 'city': '北京市', 'city_id': 2, 'district': '东城区', 'detail': 'zzzzzzzz', 'post_code': 0, 'longitude': '0', 'latitude': '0', 'is_default': 1}, 'seckill_id': 0, 'combination_id': 0, 'bargain_id': 0, 'advance_id': 0, 'cartInfo': [{'id': 35, 'uid': 2, 'type': '0', 'product_id': 3, 'product_attr_unique': '11c60075', 'cart_num': 10, 'add_time': 1756290311, 'is_pay': 0, 'is_del': 0, 'is_new': 0, 'combination_id': 0, 'seckill_id': 0, 'bargain_id': 0, 'advance_id': 0, 'status': 1, 'productInfo': {'id': 3, 'mer_id': 0, 'image': 'http://172.31.15.134/uploads/attach/2023/02/20230213/small_5ae4f6a3f8bf153beb849e02e14b5c40.png', 'recommend_image': '', 'slider_image': ['http://172.31.15.134/uploads/attach/2023/02/20230213/5ae4f6a3f8bf153beb849e02e14b5c40.png'], 'store_name': '蓝牙音乐手表 | Jeep智能表蓝牙通话健康管理 P07', 'store_info': '', 'keyword': '', 'bar_code': '', 'cate_id': '13,15,12,17,10', 'price': '269.00', 'vip_price': '0.00', 'ot_price': '359.00', 'postage': '0.00', 'unit_name': '件', 'sort': 0, 'sales': 2, 'stock': 98, 'is_show': 1, 'is_hot': 0, 'is_benefit': 0, 'is_best': 1, 'is_new': 0, 'is_virtual': 0, 'virtual_type': 0, 'add_time': 1676281988, 'is_postage': 0, 'is_del': 0, 'mer_use': 0, 'give_integral': 100, 'cost': '219.00', 'is_seckill': 0, 'is_bargain': 0, 'is_good': 0, 'is_sub': 0, 'is_vip': 0, 'ficti': 30, 'browse': 0, 'code_path': '', 'soure_link': '', 'video_link': '', 'temp_id': 0, 'spec_type': 1, 'activity': '0,1,2,3', 'spu': '5254981082521', 'label_id': '', 'command_word': '', 'recommend_list': '1,2', 'vip_product': 0, 'presale': 0, 'presale_start_time': 0, 'presale_end_time': 0, 'presale_day': 1, 'logistics': '1,2', 'freight': 2, 'custom_form': '[]', 'is_limit': 0, 'limit_type': 0, 'limit_num': 0, 'express_delivery': True, 'store_mention': True, 'attrInfo': {'id': 81, 'product_id': 3, 'suk': '黑色,46mm', 'stock': 98, 'sales': 2, 'price': '269.00', 'image': 'http://172.31.15.134/uploads/attach/2023/02/20230213/small_5ae4f6a3f8bf153beb849e02e14b5c40.png', 'unique': '11c60075', 'cost': '219.00', 'bar_code': '', 'ot_price': '359.00', 'vip_price': '0.00', 'weight': '1.00', 'volume': '1.00', 'brokerage': '0.00', 'brokerage_two': '0.00', 'type': 0, 'quota': 0, 'quota_show': 0, 'is_virtual': 0, 'coupon_id': 0, 'disk_info': ''}}, 'attrStatus': True, 'vip_truePrice': 0, 'costPrice': '219.00', 'trueStock': 98, 'truePrice': 269, 'sum_price': '269.00', 'price_type': 'level', 'is_valid': 1}], 'custom_form': [], 'priceGroup': {'storePostage': '0.00', 'storeFreePostage': 1000000, 'isStoreFreePostage': False, 'sumPrice': '2690.00', 'totalPrice': '2690.00', 'costPrice': '2190.00', 'vipPrice': '0.00', 'storePostageDiscount': 0, 'cartInfo': [{'id': 35, 'uid': 2, 'type': '0', 'product_id': 3, 'product_attr_unique': '11c60075', 'cart_num': 10, 'add_time': 1756290311, 'is_pay': 0, 'is_del': 0, 'is_new': 0, 'combination_id': 0, 'seckill_id': 0, 'bargain_id': 0, 'advance_id': 0, 'status': 1, 'productInfo': {'id': 3, 'mer_id': 0, 'image': 'http://172.31.15.134/uploads/attach/2023/02/20230213/small_5ae4f6a3f8bf153beb849e02e14b5c40.png', 'recommend_image': '', 'slider_image': ['http://172.31.15.134/uploads/attach/2023/02/20230213/5ae4f6a3f8bf153beb849e02e14b5c40.png'], 'store_name': '蓝牙音乐手表 | Jeep智能表蓝牙通话健康管理 P07', 'store_info': '', 'keyword': '', 'bar_code': '', 'cate_id': '13,15,12,17,10', 'price': '269.00', 'vip_price': '0.00', 'ot_price': '359.00', 'postage': '0.00', 'unit_name': '件', 'sort': 0, 'sales': 2, 'stock': 98, 'is_show': 1, 'is_hot': 0, 'is_benefit': 0, 'is_best': 1, 'is_new': 0, 'is_virtual': 0, 'virtual_type': 0, 'add_time': 1676281988, 'is_postage': 0, 'is_del': 0, 'mer_use': 0, 'give_integral': 100, 'cost': '219.00', 'is_seckill': 0, 'is_bargain': 0, 'is_good': 0, 'is_sub': 0, 'is_vip': 0, 'ficti': 30, 'browse': 0, 'code_path': '', 'soure_link': '', 'video_link': '', 'temp_id': 0, 'spec_type': 1, 'activity': '0,1,2,3', 'spu': '5254981082521', 'label_id': '', 'command_word': '', 'recommend_list': '1,2', 'vip_product': 0, 'presale': 0, 'presale_start_time': 0, 'presale_end_time': 0, 'presale_day': 1, 'logistics': '1,2', 'freight': 2, 'custom_form': '[]', 'is_limit': 0, 'limit_type': 0, 'limit_num': 0, 'express_delivery': True, 'store_mention': True, 'attrInfo': {'id': 81, 'product_id': 3, 'suk': '黑色,46mm', 'stock': 98, 'sales': 2, 'price': '269.00', 'image': 'http://172.31.15.134/uploads/attach/2023/02/20230213/small_5ae4f6a3f8bf153beb849e02e14b5c40.png', 'unique': '11c60075', 'cost': '219.00', 'bar_code': '', 'ot_price': '359.00', 'vip_price': '0.00', 'weight': '1.00', 'volume': '1.00', 'brokerage': '0.00', 'brokerage_two': '0.00', 'type': 0, 'quota': 0, 'quota_show': 0, 'is_virtual': 0, 'coupon_id': 0, 'disk_info': ''}}, 'attrInfo': {'id': 81, 'product_id': 3, 'suk': '黑色,46mm', 'stock': 98, 'sales': 2, 'price': '269.00', 'image': 'http://172.31.15.134/uploads/attach/2023/02/20230213/5ae4f6a3f8bf153beb849e02e14b5c40.png', 'unique': '11c60075', 'cost': '219.00', 'bar_code': '', 'ot_price': '359.00', 'vip_price': '0.00', 'weight': '1.00', 'volume': '1.00', 'brokerage': '0.00', 'brokerage_two': '0.00', 'type': 0, 'quota': 0, 'quota_show': 0, 'is_virtual': 0, 'coupon_id': 0, 'disk_info': ''}, 'attrStatus': True, 'vip_truePrice': 0, 'costPrice': '219.00', 'trueStock': 98, 'truePrice': 269, 'sum_price': '269.00', 'price_type': 'level', 'is_valid': 1, 'postage_price': '0.00', 'origin_postage_price': '0.00'}], 'levelPrice': '0.00', 'memberPrice': 0}, 'orderKey': '692076567907532800', 'offlinePostage': '0', 'userInfo': {'uid': 2, 'real_name': '客服', 'birthday': 1664208000, 'card_id': '', 'mark': '', 'partner_id': 0, 'group_id': 0, 'nickname': '客服', 'avatar': '/statics/system_images/default_avatar.jpeg', 'phone': '15088888888', 'add_time': 1664273171, 'last_time': 1756290311, 'now_money': '999999.99', 'brokerage_price': '0.00', 'integral': 0, 'exp': '0.00', 'sign_num': 0, 'status': 1, 'level': 0, 'agent_level': 0, 'spread_open': 1, 'spread_uid': 0, 'spread_time': 0, 'user_type': 'h5', 'is_promoter': 1, 'pay_count': 0, 'spread_count': 0, 'addres': '', 'adminid': 0, 'login_type': '', 'record_phone': '0', 'is_money_level': 0, 'is_ever_level': 0, 'overdue_time': 0, 'uniqid': '', 'division_type': 0, 'division_status': 0, 'is_division': 0, 'is_agent': 0, 'is_staff': 0, 'division_id': 0, 'agent_id': 0, 'staff_id': 0, 'division_percent': 0, 'division_change_time': 0, 'division_end_time': 0, 'division_invite': 0, 'is_del': 0, 'vip': True, 'vip_id': 0, 'discount': 0}, 'integralRatio': '0.1', 'offline_pay_status': 1, 'yue_pay_status': 1, 'pay_weixin_open': True, 'friend_pay_status': 0, 'store_self_mention': False, 'ali_pay_status': False, 'system_store': [], 'invoice_func': True, 'special_invoice': True, 'usable_integral': '0', 'integral_open': True}}
08-28
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符  | 博主筛选后可见
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值