Oracle系统表大全

合集下载

推荐下载-Oracle系统表大全 精品

推荐下载-Oracle系统表大全 精品

数据字典dict总是属于Oracle用户sys的。

1、用户:select username from dba_users;改口令alter user spgroup identified by spgtest;2、表空间:select * from dba_data_files;select * from dba_tablespaces;//表空间select tablespace_name,sum(bytes), sum(blocks)from dba_free_space group by tablespace_name;//空闲表空间select * from dba_data_fileswhere tablespace_name='RBS';//表空间对应的数据文件select * from dba_segmentswhere tablespace_name='INDEXS';3、数据库对象:select * from dba_objects;CLUSTER、DATABASE LINK、FUNCTION、INDEX、LIBRARY、PACKAGE、PAC KAGE BODY、PROCEDURE、SEQUENCE、SYNONYM、TABLE、TRIGGER、TYPE、UNDEFINED、VIEW。

4、表:select * from dba_tables;analyze my_table pute statistics;->dba_tables后6列select extent_id,bytes from dba_extentswhere segment_name='CUSTOMERS' and segment_type='TABLE'order by extent_id;//表使用的extent的信息。

segment_type='ROLLBACK'查看回滚段的空间分配信息列信息:select distinct table_namefrom user_tab_columnswhere column_name='SO_TYPE_ID';5、索引:select * from dba_indexes;//索引,包括主键索引select * from dba_ind_columns;//索引列select i.index_name,i.uniqueness,c.column_namefrom user_indexes i,user_ind_columns cwhere i.index_name=c.index_nameand i.table_name ='ACC_NBR';//联接使用6、序列:select * from dba_sequences;7、视图:select * from dba_views;select * from all_views;text 可用于查询视图生成的脚本8、聚簇:select * from dba_clusters;9、快照:select * from dba_snapshots;快照、分区应存在相应的表空间。

Oracle EBS常用数据表

Oracle EBS常用数据表

来源:/126211/INV库存organization 两个含义:1. 经营单位,A/B/C分公司,A下面有A1,A2等工厂,主题目标是为了独立核算此组织ORG,ORG_ID;2. 库存组织,例如制造商的仓库,例如A1,A2等工厂Organization_id;HR_ORGANIZATION_UNITS -Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数(没有用ID,直接用name)MTL_SYSTEM_ITEMS_b -物料信息(同上,应用了库存组织name)MTL_SECONDARY_INVENTORIES -子库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本;ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位现有量汇总历史记录(正负合计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物品 summary可能按照挑库先进先出统计,如果设置了"不允许负库存",这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收-退货/组织间转移/正常状态都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态!例如:接收100个,80个接受入库,20个退回,那么有80个接受事务/20个退回事物select TRANSACTION_TYPE,DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段:A1.RECEIVE – RECEIVINGA2.ACCEPT – RECEIVINGA3.DELIERY – INVETORY(影响库存现有量)如果按照正常模式,最后会触发产生MTL_MATERIAL_TRANSACTIONS 销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_TO_ORG_ID和客户结构有关客户 RA_customers客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 siteOE_ORDER_LINEs_allGL凭证gl_je_batches凭证日期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CRgl_je_headers日记账头信息批号: JE_BATCH_ID会计期间: PERIOD_NAME币种: CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率日期: CURRENCY_CONVERSION_DATE帐套: SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCEgl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额GL_JE_BATCHES 日记账批信息(当年)GL_ARCHIVE_BATCHES 日记账归档GL_JE_HEADERS 日记账头信息GL_JE_LINES 日记账明细信息其中GL_JE_BATCHES和GL_JE_HEADERS通过JE_BATCH_ID相关联,并且是一对多的关系其中GL_JE_HEADERS和GL_JE_LINES通过JE_HEADER_ID相关联,并且是一对多的关系GL_SETS_OF_BOOKS 账套信息,每套账有一行记录GL_PERIODS 会计期信息GL_CODE_COMBINATIONS 代码组合信息GL_BALANCE 总账余额表GL_DAILY_RATES 每天汇率GL_TRANSLATION_RATES_V 每月汇率——期间的平均汇率GL_BUDEGETS 总账预算信息GL_BUDGET_TYPES 预算类型表——仅支持一种预算类型,所以仅有一条记录GL_BUDGET_VERSIONS 预算版本信息,通过BUDGET_VERSION_ID与GL_BUDEGETS对应GL_INTERFACE 总账接口表GL_BUDGET_ASSIGNMENT_RANGES 预算分配范围GL_BUDGET_ASSIGNMENTS 预算帐户信息GL_BUDGET_PERIOD_RANGES 预算历期信息GL_BUDGET_INTERFACE 预算导入接口表GL_BUDGET_FROZEN_RANGES 预算冻结信息GL_BUDGET_ENTITIES 预算部门信息AR应收发票RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID 发票编号BILL_TO_SITE_USE_ID 客户收单方编号PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框,但是由于版本问题和长度(<=30),不建议用户使用,如果要使用外部编号,请使用说明性弹性域RA_CUSTOMER_TRX_LINES_ALLLINE_ID 行号INVENTORY_ITEM_ID 可以为空,比如非物料的服务,只在DESCRIPTION中出现 /税行DESCRIPTIONQUANTITY_INVOICE 开票数量LINE_TYPE 行类型 (一般/税)EXTEND_PRICE 本行金额注意:税行是隐藏行,所以至少会有两行收款情况AR_CASH_RECEIPTS_ALL(还包含了非收款信息)CASH_RECEIPT_ID 内部codeRECEIPT_NUMBER 收款号RECEIPT_DATE 收款日期AMOUNT 总额RECEIPT_TYPE 现金/杂项 Cash/MiscFUNCTIONAL_AMOUNT 本位币计量金额UI上为RECEIPTS核销关系不是一一对应,也不是一次核销100%,UI上右下方的Application 按钮AR_RECEIVABLE_APPLICATIONS_ALLAPPLIED_CUSTOMER_TRX_ID 发票编号APPLIED_CUSTOMER_TRX_LINE_ID 发票行编号STATUS APP表示核销 /UNAPP表示未核销AMOUNT_APPLIED 匹配金额注意:红冲收款报表时间跨月的问题;必须联查AR_CASH_RECEIPTS_ALL和AR_CASH_RECEIPT_HISTORY_ALLAP应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoiceAP_INVOICES_ALL实际付款PAYMENTAP_CHECKS_ALL核销关系同AR,右下方的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表,情况比较复杂:比如两个用户合并,应收应付差额,预付款资产信息FA_ADDITIONS名称编号分类数量资产类别FA_CATEGORIES资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系?FA_BOOKSUI中的InquiryMothed是折旧方法(直线法/产量法)FA_DISTRIBUTION_HISTORY分配assignment,给什么部门使用多少LOCATION_ID 部门联查FA_LOCATIONS折旧信息(分摊方法)FA_DEPRN_DETAILperiod_counter 折旧期间编号折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERSselect fnd_profile.VALUE('ORG_ID') FROM DUALselect * from hr_operating_units hou where anization_id=204--fndselect * from fnd_applicationselect * from fnd_application_tl where application_id=101select * from fnd_application_vl where application_id = 101----值集select * from fnd_flex_value_setsselect * from fnd_flex_valuesselect * from fnd_flex_values_vl----弹性域select * from fnd_id_flexsselect * from fnd_id_flex_structures where id_flex_code='GL#'select * from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num=50671 select * from fnd_profile_options_vlselect * from fnd_concurrent_programs 程序表select * from fnd_concurrent_requests 请求表select * from fnd_concurrent_processes 进程表--invselect * from org_organization_definitions 库存组织select * from mtl_parameters 组织参数select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表select * from mtl_secondary_inventories 子库存select * from mtl_item_locations 货位select * from mtl_lot_numbers 批次select * from mtl_onhand_quantities 现有量表select * from mtl_serial_numbers 序列select * from mtl_material_transactions 物料事务记录select * from mtl_transaction_accounts 会计分录select * from mtl_transaction_types 事务类型select * from mtl_txn_source_types 事务来源类型select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'--poselect * from po_requisition_headers_all 请求头select * from po_requisition_lines_all 请求行select * from po_headers_all 订单头select * from po_lines_all 订单行select * from po_line_locations_allselect * from po_distributions_all 分配select * from po_releases_all 发送select * from rcv_shipment_headers 采购接收头select * from rcv_shipment_lines 采购接收行select * from rcv_transactions 接收事务处理select * from po_agentsselect * from po_vendors 订单select * from po_vendor_sites_all--oeselect * from ra_customers 客户select * from ra_addresses_all 地址select * from ra_site_uses_all 用户select * from oe_order_headers_all 销售头select * from oe_order_lines_all 销售行select * from wsh_new_deliveries 发送。

oracle+ebs+11i+数据表大全

oracle+ebs+11i+数据表大全

OWNER OBJECT_NAME OBJECT_TYPE CREATEDPA PA_PROJECT_ROLE_TYPES_B TABLE2004-6-12 0:41:00 PA PA_EXPENDITURE_TYPES TABLE2004-6-12 0:37:04 PA PA_PROJECTS_ALL TABLE2004-6-12 0:40:13 PA PA_TASKS TABLE2004-6-12 0:43:09 PA PA_EXPEND_TYP_SYS_LINKS TABLE2004-6-12 0:37:07 PA PA_PERIODS_ALL TABLE2004-6-12 0:39:46 PA PA_BUDGET_TYPES TABLE2004-6-12 0:33:39 PA PA_SYSTEM_LINKAGES TABLE2004-6-12 0:43:06 PA PA_EXPENDITURES_ALL TABLE2004-6-12 0:36:40 PA PA_TRANSACTION_INTERFACE_ALL TABLE2004-6-12 0:43:26 PA PA_BUDGET_VERSIONS TABLE2004-6-12 0:33:40 PA PA_REPORTING_EXCEPTIONS TABLE2004-6-12 0:41:45 PA PA_IMPLEMENTATIONS_ALL TABLE2004-6-12 0:38:25 PA PA_COST_DISTRIBUTION_LINES_ALL TABLE2004-6-12 0:34:52 PA PA_EXPENDITURE_TYPE_OUS_ALL TABLE2004-6-12 0:37:05 PA PA_PURGE_BATCHES_ALL TABLE2004-6-12 0:41:41 PA PA_EXPENDITURE_ITEMS_ALL TABLE2004-6-12 0:36:54 PA PA_CC_DIST_LINES_ALL TABLE2004-6-12 0:33:47 PA PA_DRAFT_INVOICES_ALL TABLE2004-6-12 0:35:26 PA PA_EVENT_TYPE_OUS_ALL TABLE2004-6-12 0:36:32 PA PA_CC_TP_SCHEDULES_BG TABLE2004-6-12 0:33:50 PA PA_CC_TP_RULES_BG TABLE2004-6-12 0:33:49 PA PA_DRAFT_INVOICE_DETAILS_ALL TABLE2004-6-12 0:35:36 PA PA_DRAFT_REVENUES_ALL TABLE2004-6-12 0:35:47 PA PA_IND_RATE_SCHEDULES_ALL_BG TABLE2004-6-12 0:38:29 PA PA_CUST_REV_DIST_LINES_ALL TABLE2004-6-12 0:35:14 PA PA_AGREEMENTS_ALL TABLE2004-6-12 0:32:24 PA PA_BILLING_ASSIGNMENTS_ALL TABLE2004-6-12 0:33:13 PA PA_BILL_RATES_ALL TABLE2004-6-12 0:33:17 PA PA_MC_CUST_RDL_ALL TABLE2004-6-12 0:38:56 PA PA_COMPENSATION_DETAILS_ALL TABLE2004-6-12 0:34:30 PA PA_MC_PRJ_AST_LINES_ALL TABLE2004-6-12 0:39:11 PA PA_RESOURCE_LIST_MEMBERS TABLE2004-6-12 0:42:10 PA PA_MC_PRJ_AST_LINE_DTLS TABLE2004-6-12 0:39:11 PA PA_EMPLOYEE_ACCUM_ALL TABLE2004-6-12 0:36:12 PA PA_TXN_ACCUM_DETAILS TABLE2004-6-12 0:43:38 PA PA_EMPLOYEE_ORG_ACCUM_ALL TABLE2004-6-12 0:36:19 PA PA_DRAFT_REVENUE_ITEMS TABLE2004-6-12 0:35:56 PA PA_EXPENDITURE_BATCHES_ALL TABLE2004-6-12 0:36:41 PA PA_MC_DRAFT_REVS_ALL TABLE2004-6-12 0:39:01 PA PA_EXPENDITURE_COST_RATES_ALL TABLE2004-6-12 0:36:50 PA PA_PROJECTS_IT_ALL TABLE2004-6-12 0:40:18 PA PA_EXPENDITURE_GROUPS_ALL TABLE2004-6-12 0:36:52 PA PA_PRJ_TYPES_IT_ALL TABLE2004-6-12 0:40:04 PA PA_MC_COST_DIST_LINES_ALL TABLE2004-6-12 0:38:51 PA PA_TSK_ACT_CMT_IT_ALL TABLE2004-6-12 0:43:34 PA PA_FUNCTION_TRANSACTIONS_ALL TABLE2004-6-12 0:38:21 PA PA_MC_EVENTS TABLE2004-6-12 0:39:02 PA PA_PRJ_ACT_CMT_IT_ALL TABLE2004-6-12 0:39:59 PA PA_MC_TXN_INTERFACE_ALL TABLE2004-6-12 0:39:17 PA PA_PROJECT_ACCUM_ACTUALS TABLE2004-6-12 0:40:25 PA PA_TSK_BGT_LINES_IT_ALL TABLE2004-6-12 0:43:34 PA PA_PRJ_BGT_LINES_IT_ALL TABLE2004-6-12 0:40:01 PA PA_PROJECT_ACCUM_BUDGETS TABLE2004-6-12 0:40:26PA PA_PROJECT_ASSET_LINES_ALL TABLE2004-6-12 0:40:33 PA PA_PROJ_TYPE_DISTRIBUTIONS_ALL TABLE2004-6-12 0:41:39 PA PA_PROJ_TYPE_VERIFICATIONS_ALL TABLE2004-6-12 0:41:39 PA PA_SEGMENT_RULE_PAIRINGS_ALL TABLE2004-6-12 0:42:52 PA PA_PROJECT_ACCUM_COMMITMENTS TABLE2004-6-12 0:40:27 PA PA_STD_BILL_RATE_SCHEDULES_ALL TABLE2004-6-12 0:42:57 PA PA_MC_DRAFT_INV_DETAILS_ALL TABLE2004-6-12 0:38:57 PA PA_CLASS_CATEGORIES TABLE2004-6-12 0:34:19 PA PA_USAGE_COST_RATE_OVR_ALL TABLE2004-6-12 0:43:48 PA PA_MC_DRAFT_INV_ITEMS TABLE2004-6-12 0:38:59 PA PA_RESOURCE_LISTS_ALL_BG TABLE2004-6-12 0:42:09 PA PA_TRANSACTION_XFACE_CTRL_ALL TABLE2004-6-12 0:43:33 PA PA_TASK_HISTORY TABLE2004-6-12 0:43:11 PA PA_PROJECT_TYPES_ALL TABLE2004-6-12 0:41:14 PA PA_MASS_UPDATE_BATCHES_ALL TABLE2004-6-12 0:38:46 PA PA_MC_EXP_ITEMS_ALL TABLE2004-6-12 0:39:04 PA PA_TXN_INTERFACE_AUDIT_ALL TABLE2004-6-12 0:43:44 PA PA_PROJECT_ACCUM_HEADERS TABLE2004-6-12 0:40:28 PA PA_MC_CC_DIST_LINES_ALL TABLE2004-6-12 0:38:50 PA PA_RES_LISTS_IT_ALL_BG TABLE2004-6-12 0:42:22 PA PA_NON_LABOR_RESOURCES TABLE2004-6-12 0:39:21 PA PA_EVENT_TYPES TABLE2004-6-12 0:36:30 PA PA_RESOURCE_TYPES TABLE2004-6-12 0:42:14 PA PA_CLASS_CODES TABLE2004-6-12 0:34:20 PA PA_SEGMENT_VALUE_LOOKUPS TABLE2004-6-12 0:42:53 PA PA_COST_BASE_COST_CODES TABLE2004-6-12 0:34:45 PA PA_PROJECT_ASSETS_ALL TABLE2004-6-12 0:40:30 PA PA_ALLOC_RUNS_ALL TABLE2004-6-12 0:32:37 PA PA_PROJECT_STATUSES TABLE2004-6-12 0:41:11 PA PA_ALLOC_RULES_ALL TABLE2004-6-12 0:32:36 PA PA_AGREEMENT_TYPES TABLE2004-6-12 0:32:25 PA PA_COMMITMENT_TXNS TABLE2004-6-12 0:34:29 PA PA_BUDGET_ENTRY_METHODS TABLE2004-6-12 0:33:30 PA PA_EXPENDITURE_CATEGORIES TABLE2004-6-12 0:36:43 PA PA_CUST_EVENT_RDL_ALL TABLE2004-6-12 0:35:04 PA PA_DRAFT_INVOICE_ITEMS TABLE2004-6-12 0:35:37 PA PA_DISTRIBUTION_RULES TABLE2004-6-12 0:35:19 PA PA_PROJECT_FUNDINGS TABLE2004-6-12 0:40:49 PA PA_TRANSACTION_SOURCES TABLE2004-6-12 0:43:32 PA PA_ALL_ORGANIZATIONS TABLE2004-6-12 0:32:51 PA PA_BIS_PRJ_BY_PRD_DRILLS_ALL TABLE2004-6-12 0:33:20 PA PA_BIS_PRJ_TO_DATE_DRILLS_ALL TABLE2004-6-12 0:33:20 PA PA_BIS_TO_DATE_DRILLS_ALL TABLE2004-6-12 0:33:27 PA PA_BIS_TOTALS_BY_PRD_ALL TABLE2004-6-12 0:33:26 PA PA_BIS_TOTALS_TO_DATE_ALL TABLE2004-6-12 0:33:26 PA PA_BUDGET_LINES TABLE2004-6-12 0:33:32 PA PA_EVENTS TABLE2004-6-12 0:36:22 PA PA_INVOICE_GROUPS TABLE2004-6-12 0:38:32 PA PA_JOB_RELATIONSHIPS TABLE2004-6-12 0:38:39 PA PA_NEXT_ALLOW_STATUSES TABLE2004-6-12 0:39:18 PA PA_WORK_TYPES_B TABLE2004-6-12 0:44:01 PA PA_REP_SEQ_NUMBER TABLE2004-6-12 0:41:52 PA PA_TIMELINE_ROW_LABEL TABLE2004-6-12 0:43:19 PA PA_PROJECT_SUBTEAM_PARTIES TABLE2004-6-12 0:41:13 PA PA_UTIL_CATEGORIES_B TABLE2004-6-12 0:43:50PA PA_TIMELINE_TIME_SCALE TABLE2004-6-12 0:43:20 PA PA_COMPETENCE_PROFILES TABLE2004-6-12 0:34:34 PA PA_PROJECT_CLASSES TABLE2004-6-12 0:40:41 PA PA_RESOURCES_DENORM TABLE2004-6-12 0:42:00 PA PA_FORECAST_ITEMS TABLE2004-6-12 0:37:55 PA PA_FORECASTING_OPTIONS_ALL TABLE2004-6-12 0:37:54 PA PA_UTILIZATION_OPTIONS_ALL TABLE2004-6-12 0:43:50 PA PA_ORG_HIERARCHY_DENORM TABLE2004-6-12 0:39:34 PA PA_PROJECT_ROLE_TYPES_TL TABLE2004-6-12 0:41:01 PA PA_AMOUNT_TYPES_B TABLE2004-6-12 0:32:59 PA PA_BC_COMMITMENTS_ALL TABLE2004-6-12 0:33:04 PA PA_BUDGETARY_CONTROL_OPTIONS TABLE2004-6-12 0:33:27 PA PA_BUDGET_ACCT_LINES TABLE2004-6-12 0:33:29 PA PA_BUDGETARY_CONTROLS TABLE2004-6-12 0:33:27 PA PA_PROBABILITY_MEMBERS TABLE2004-6-12 0:40:06 PA PA_RESOURCE_ASSIGNMENTS TABLE2004-6-12 0:42:02 PA PA_REPORT_TYPES TABLE2004-6-12 0:41:46 PA PA_ACTION_SETS TABLE2004-6-12 0:32:13 PA PA_PROJ_ELEMENTS TABLE2004-6-12 0:41:16 PA PA_PROJ_ELEM_VER_STRUCTURE TABLE2004-6-12 0:41:24 PA PA_OBJECT_RELATIONSHIPS TABLE2004-6-12 0:39:27 PA PA_PROJ_ELEMENT_VERSIONS TABLE2004-6-12 0:41:18 PA PA_PROGRESS_REPORT_VALS TABLE2004-6-12 0:40:11 PA PA_WF_NTF_PERFORMERS TABLE2004-6-12 0:43:59 PA PA_WF_PROCESS_DETAILS TABLE2004-6-12 0:44:00 PA PA_RESOURCE_TXN_ATTRIBUTES TABLE2004-6-12 0:42:13 PA PA_BILLING_EXTENSIONS TABLE2004-6-12 0:33:14 PA PA_OBJECT_PAGE_LAYOUTS TABLE2004-6-12 0:39:26 PA PA_PROJ_PERIODS_DENORM TABLE2004-6-12 0:41:25 PA PA_FIN_PLAN_TYPES_B TABLE2004-6-12 0:37:41 PA PA_PROJ_RETN_BILL_RULES TABLE2004-6-12 0:41:29 PA PA_PROBABILITY_LISTS TABLE2004-6-12 0:40:05 PA PA_MC_RETN_INV_DETAILS TABLE2004-6-12 0:39:13 PA PA_ACTION_SET_LINES TABLE2004-6-12 0:32:14 PA PA_ACTION_SET_LINE_COND TABLE2004-6-12 0:32:19 PA PA_ROLE_LISTS TABLE2004-6-12 0:42:24 PA PA_PROJECT_ASSIGNMENTS TABLE2004-6-12 0:40:36 PA PA_RESOURCES TABLE2004-6-12 0:41:59 PA PA_CI_TYPES_TL TABLE2004-6-12 0:34:18 PA PA_CONTROL_ITEMS TABLE2004-6-12 0:34:42 PA PA_MC_PROJECT_FUNDINGS TABLE2004-6-12 0:39:12 PA PA_MC_SUM_PROJ_FUNDINGS TABLE2004-6-12 0:39:15 PA PA_PROJ_PROGRESS_ATTR TABLE2004-6-12 0:41:27 PA PA_PROJ_ELEM_VER_SCHEDULE TABLE2004-6-12 0:41:19 PA PA_MC_BUDGET_LINES TABLE2004-6-12 0:38:48 PA PA_PROJECT_SETS_B TABLE2004-6-12 0:41:03 PA PA_PROJ_FP_OPTIONS TABLE2004-6-12 0:41:25 PA PA_LIFECYCLE_USAGES TABLE2004-6-12 0:38:42 PA PA_WORK_TYPES_TL TABLE2004-6-12 0:44:02 PA PA_STRUCTURE_TYPES TABLE2004-6-12 0:43:03 PA PA_CI_TYPES_B TABLE2004-6-12 0:34:10 PA PA_PERCENT_COMPLETES TABLE2004-6-12 0:39:45 PA PA_IND_COST_CODES TABLE2004-6-12 0:38:27 PA PA_PURGE_PROJECTS TABLE2004-6-12 0:41:43 PA PA_SUMMARY_PROJECT_FUNDINGS TABLE2004-6-12 0:43:04PA PA_MC_CUST_EVENT_RDL_ALL TABLE2004-6-12 0:38:52 PA PA_ACCUM_COLUMNS TABLE2004-6-12 0:32:11 PA PA_PROJECT_ASSET_ASSIGNMENTS TABLE2004-6-12 0:40:33 PA PA_ROUTINGS TABLE2004-6-12 0:42:28 PA PA_ALLOC_RUN_SOURCE_DET TABLE2004-6-12 0:32:45 PA PA_ALLOC_TXN_DETAILS TABLE2004-6-12 0:32:48 PA PA_ALLOC_EXCEPTIONS TABLE2004-6-12 0:32:32 PA PA_ALLOC_MISSING_COSTS TABLE2004-6-12 0:32:34 PA PA_RESOURCE_LIST_USES TABLE2004-6-12 0:42:11 PA PA_RULES TABLE2004-6-12 0:42:29 PA PA_PROJECT_STATUS_CONTROLS TABLE2004-6-12 0:41:11 PA PA_LOCATIONS TABLE2004-6-12 0:38:43 PA PA_BC_BALANCES TABLE2004-6-12 0:33:03 PA PA_UTIL_CATEGORIES_TL TABLE2004-6-12 0:43:51 PA PA_PAGE_TYPE_REGIONS TABLE2004-6-12 0:39:44 PA PA_BILLING_CYCLES TABLE2004-6-12 0:33:14 PA PA_PROJ_RETN_RULES TABLE2004-6-12 0:41:30 PA PA_VALUE_MAP_DEFS TABLE2004-6-12 0:43:54 PA PA_PROJECT_CUSTOMERS TABLE2004-6-12 0:40:42 PA PA_CI_ACTIONS TABLE2004-6-12 0:33:57 PA PA_CC_ORG_RELATIONSHIPS TABLE2004-6-12 0:33:48 PA PA_PROJECT_ASSET_LINE_DETAILS TABLE2004-6-12 0:40:35 PA PA_OBJECTS TABLE2004-6-12 0:39:22 PA PA_ROLE_CONTROLS TABLE2004-6-12 0:42:23 PA PA_ROLE_LIST_MEMBERS TABLE2004-6-12 0:42:25 PA PA_FCST_PERIODS_TMP TABLE2004-6-12 0:37:22 PA PA_TXN_ACCUM TABLE2004-6-12 0:43:35 PA PA_ACCUM_COLUMN_VALUES TABLE2004-6-12 0:32:12 PA PA_ACCUM_TXN_TIME TABLE2004-6-12 0:32:12 PA PA_ACTION_SETS_AR TABLE2004-6-12 0:32:14 PA PA_ACTION_SET_LINES_AR TABLE2004-6-12 0:32:15 PA PA_ACTION_SET_LINE_AUD TABLE2004-6-12 0:32:15 PA PA_ACTION_SET_REPORT_TEMP TABLE2004-6-12 0:32:20 PA PA_ACTION_SET_TYPES TABLE2004-6-12 0:32:20 PA PA_ACTN_SETLN_AUD_AR TABLE2004-6-12 0:32:21 PA PA_ACTN_SET_LN_COND_AR TABLE2004-6-12 0:32:21 PA PA_ADV_ACTION_LINES_ORDER_TEMP TABLE2004-6-12 0:32:22 PA PA_ADW_DIMENSION_STATUS TABLE2004-6-12 0:32:23 PA PA_AGREEMENTS_EFC TABLE2004-6-12 0:32:25 PA PA_ALLOC_GL_LINES TABLE2004-6-12 0:32:33 PA PA_ALLOC_MISSING_COSTS_EFC TABLE2004-6-12 0:32:34 PA PA_ALLOC_RESOURCES TABLE2004-6-12 0:32:35 PA PA_ALLOC_RULES_ALL_EFC TABLE2004-6-12 0:32:37 PA PA_ALLOC_RUNS_ALL_EFC TABLE2004-6-12 0:32:38 PA PA_ALLOC_RUN_BASIS_DET TABLE2004-6-12 0:32:39 PA PA_ALLOC_RUN_BASIS_DET_EFC TABLE2004-6-12 0:32:40 PA PA_ALLOC_RUN_GL_DET TABLE2004-6-12 0:32:40 PA PA_ALLOC_RUN_GL_DET_EFC TABLE2004-6-12 0:32:41 PA PA_ALLOC_RUN_RESOURCE_DET TABLE2004-6-12 0:32:42 PA PA_ALLOC_RUN_SOURCES TABLE2004-6-12 0:32:42 PA PA_ALLOC_RUN_SOURCE_DET_EFC TABLE2004-6-12 0:32:46 PA PA_ALLOC_RUN_TARGETS TABLE2004-6-12 0:32:46 PA PA_ALLOC_SOURCE_LINES TABLE2004-6-12 0:32:47 PA PA_ALLOC_TARGET_LINES TABLE2004-6-12 0:32:47 PA PA_ALLOC_TXN_DETAILS_EFC TABLE2004-6-12 0:32:49PA PA_ALL_EXP_TYPES_IT TABLE2004-6-12 0:32:49 PA PA_ALL_FINANCIAL_YRS_IT TABLE2004-6-12 0:32:50 PA PA_ALL_PRJ_TYPES_IT TABLE2004-6-12 0:32:53 PA PA_ALL_SRVC_TYPES_IT TABLE2004-6-12 0:32:54 PA PA_AMOUNT_TYPES_TL TABLE2004-6-12 0:32:59 PA PA_ASGMTS_HSTRY_AR TABLE2004-6-12 0:32:59 PA PA_ASGMT_CHANGED_ITEMS TABLE2004-6-12 0:33:00 PA PA_ASGMT_CNFLT_HIST_AR TABLE2004-6-12 0:33:00 PA PA_ASSIGNMENTS_HISTORY TABLE2004-6-12 0:33:01 PA PA_ASSIGNMENT_CONFLICT_HIST TABLE2004-6-12 0:33:01 PA PA_BATCH_SOURCES TABLE2004-6-12 0:33:02 PA PA_BC_PACKETS TABLE2004-6-12 0:33:05 PA PA_BC_PACKET_ARRIVAL_ORDER TABLE2004-6-12 0:33:07 PA PA_BGT_TYPES_IT TABLE2004-6-12 0:33:13 PA PA_BILLING_ASSIGNMENTS_EFC TABLE2004-6-12 0:33:14 PA PA_BILLING_MESSAGES TABLE2004-6-12 0:33:16 PA PA_BILLING_MESSAGES_AR TABLE2004-6-12 0:33:16 PA PA_BILL_RATES_EFC TABLE2004-6-12 0:33:19 PA PA_BUDGETS TABLE2004-6-12 0:33:28 PA PA_BUDGET_ITEMS TABLE2004-6-12 0:33:31 PA PA_BUDGET_LINES_AR TABLE2004-6-12 0:33:38 PA PA_BUDGET_LINES_EFC TABLE2004-6-12 0:33:38 PA PA_BUDGET_VERSIONS_AR TABLE2004-6-12 0:33:40 PA PA_BUDGET_VERSIONS_EFC TABLE2004-6-12 0:33:41 PA PA_BURDEN_COST_CODES TABLE2004-6-12 0:33:42 PA PA_BURDEN_COST_MULTIPLIERS TABLE2004-6-12 0:33:43 PA PA_CAL_GEN_STATUS_TEMP TABLE2004-6-12 0:33:43 PA PA_CANDIDATES TABLE2004-6-12 0:33:44 PA PA_CANDIDATES_AR TABLE2004-6-12 0:33:44 PA PA_CANDIDATES_REV_AR TABLE2004-6-12 0:33:45 PA PA_CANDIDATE_REVIEWS TABLE2004-6-12 0:33:46 PA PA_CC_DIST_LINES_AR TABLE2004-6-12 0:33:47 PA PA_CC_TP_SCHEDULE_LINES TABLE2004-6-12 0:33:56 PA PA_CC_TP_SCHEDULE_LINE_LKP TABLE2004-6-12 0:33:56 PA PA_CI_COMMENTS TABLE2004-6-12 0:34:00 PA PA_CI_IMPACTS TABLE2004-6-12 0:34:07 PA PA_CI_IMPACT_TYPE_USAGE TABLE2004-6-12 0:34:08 PA PA_CI_SUPPLIER_DETAILS TABLE2004-6-12 0:34:09 PA PA_CI_TYPE_USAGE TABLE2004-6-12 0:34:18 PA PA_CLASS_CATGS_IT TABLE2004-6-12 0:34:20 PA PA_CLASS_CODES_IT TABLE2004-6-12 0:34:22 PA PA_COMMITMENT_TXNS_EFC TABLE2004-6-12 0:34:30 PA PA_COMPENSATION_DETAILS_EFC TABLE2004-6-12 0:34:31 PA PA_COMPENSATION_RULE_SETS TABLE2004-6-12 0:34:31 PA PA_COMPETENCE_CRITERIA_TEMP TABLE2004-6-12 0:34:32 PA PA_COMPILED_MULTIPLIERS TABLE2004-6-12 0:34:41 PA PA_COMP_OT_EXP_TYPES TABLE2004-6-12 0:34:41 PA PA_COST_BASES TABLE2004-6-12 0:34:44 PA PA_COST_BASE_EXP_TYPES TABLE2004-6-12 0:34:51 PA PA_COST_DIST_LINES_AR TABLE2004-6-12 0:34:53 PA PA_COST_DIST_LINES_RECVR_EFC TABLE2004-6-12 0:34:54 PA PA_COST_DIST_OVERRIDES TABLE2004-6-12 0:34:56 PA PA_COST_PLUS_STRUCTURES TABLE2004-6-12 0:35:03 PA PA_CREDIT_RECEIVERS TABLE2004-6-12 0:35:04 PA PA_CUST_EVENT_RDL_AR TABLE2004-6-12 0:35:05PA PA_CUST_RDL_AR TABLE2004-6-12 0:35:07 PA PA_DISTRIBUTION_LISTS TABLE2004-6-12 0:35:17 PA PA_DISTRIBUTION_WARNINGS TABLE2004-6-12 0:35:24 PA PA_DIST_LIST_DENORM TABLE2004-6-12 0:35:24 PA PA_DIST_LIST_ITEMS TABLE2004-6-12 0:35:25 PA PA_DIST_WARNINGS_AR TABLE2004-6-12 0:35:25 PA PA_DRAFT_INVOICES_AR TABLE2004-6-12 0:35:34 PA PA_DRAFT_INVOICES_EFC TABLE2004-6-12 0:35:35 PA PA_DRAFT_INV_DETAILS_EFC TABLE2004-6-12 0:35:39 PA PA_DRAFT_INV_DETS_AR TABLE2004-6-12 0:35:45 PA PA_DRAFT_INV_ITEMS_AR TABLE2004-6-12 0:35:46 PA PA_DRAFT_INV_ITEMS_EFC TABLE2004-6-12 0:35:47 PA PA_DRAFT_REVENUES_AR TABLE2004-6-12 0:35:50 PA PA_DRAFT_REVENUE_ITEMS_EFC TABLE2004-6-12 0:35:57 PA PA_DRAFT_REV_INV_TEMP TABLE2004-6-12 0:35:57 PA PA_DRAFT_REV_ITEMS_AR TABLE2004-6-12 0:35:58 PA PA_EARNED_VALUES TABLE2004-6-12 0:35:59 PA PA_EARNED_VALUES_EFC TABLE2004-6-12 0:36:07 PA PA_EI_DENORM TABLE2004-6-12 0:36:08 PA PA_EI_DENORM_AR TABLE2004-6-12 0:36:09 PA PA_EI_DENORM_EFC TABLE2004-6-12 0:36:10 PA PA_EMPLOYEE_ACCUM_EFC TABLE2004-6-12 0:36:18 PA PA_EMPLOYEE_ORG_ACCUM_EFC TABLE2004-6-12 0:36:19 PA PA_EMP_BILL_RATE_OVERRIDES TABLE2004-6-12 0:36:20 PA PA_EMP_BILL_RATE_OVERRIDES_EFC TABLE2004-6-12 0:36:21 PA PA_EVENTS_AR TABLE2004-6-12 0:36:29 PA PA_EVENTS_EFC TABLE2004-6-12 0:36:29 PA PA_EXCEPTION_REASONS TABLE2004-6-12 0:36:39 PA PA_EXPENDITURES_AR TABLE2004-6-12 0:36:40 PA PA_EXPENDITURE_COMMENTS TABLE2004-6-12 0:36:50 PA PA_EXPENDITURE_COST_RATES_EFC TABLE2004-6-12 0:36:51 PA PA_EXPENDITURE_HISTORY TABLE2004-6-12 0:36:53 PA PA_EXPENDITURE_ITEMS_AR TABLE2004-6-12 0:36:59 PA PA_EXPEND_ALIASES TABLE2004-6-12 0:37:05 PA PA_EXPEND_COMMENT_ALIASES TABLE2004-6-12 0:37:05 PA PA_EXPEND_ITEM_ADJ_ACTIVITIES TABLE2004-6-12 0:37:06 PA PA_EXP_BUSINESS_GRPS_IT TABLE2004-6-12 0:37:09 PA PA_EXP_COMMENTS_AR TABLE2004-6-12 0:37:18 PA PA_EXP_HISTORY_AR TABLE2004-6-12 0:37:18 PA PA_EXP_ITEMS_RECVR_EFC TABLE2004-6-12 0:37:19 PA PA_EXP_ITEM_ADJ_ACT_AR TABLE2004-6-12 0:37:19 PA PA_EXP_ORGS_IT TABLE2004-6-12 0:37:20 PA PA_EXP_TYPES_IT TABLE2004-6-12 0:37:21 PA PA_FINANCIAL_QTRS_IT TABLE2004-6-12 0:37:28 PA PA_FINANCIAL_YRS_IT TABLE2004-6-12 0:37:29 PA PA_FIN_PLAN_ADJ_LINES TABLE2004-6-12 0:37:29 PA PA_FIN_PLAN_AMOUNT_SETS TABLE2004-6-12 0:37:30 PA PA_FIN_PLAN_LINES_TMP TABLE2004-6-12 0:37:31 PA PA_FIN_PLAN_TYPES_TL TABLE2004-6-12 0:37:41 PA PA_FIN_VP_AMTS_VIEW_TMP TABLE2004-6-12 0:37:42 PA PA_FIN_VP_PDS_VIEW_TMP TABLE2004-6-12 0:37:51 PA PA_FI_AMOUNT_DETAILS TABLE2004-6-12 0:37:52 PA PA_FI_AMOUNT_DETAILS_AR TABLE2004-6-12 0:37:52 PA PA_FI_AMOUNT_DTLS_TMP TABLE2004-6-12 0:37:53 PA PA_FORECAST_ITEM_DETAILS TABLE2004-6-12 0:37:57PA PA_FP_ADJ_ELEMENTS TABLE2004-6-12 0:37:58 PA PA_FP_BL_MAP_TMP TABLE2004-6-12 0:38:03 PA PA_FP_CPY_PERIODS_TMP TABLE2004-6-12 0:38:04 PA PA_FP_ELEMENTS TABLE2004-6-12 0:38:04 PA PA_FP_MERGED_CTRL_ITEMS TABLE2004-6-12 0:38:05 PA PA_FP_OF_WEBADI_XFACE TABLE2004-6-12 0:38:06 PA PA_FP_PRIOR_PERIODS_TMP TABLE2004-6-12 0:38:07 PA PA_FP_RA_MAP_TMP TABLE2004-6-12 0:38:09 PA PA_FP_ROLLUP_TMP TABLE2004-6-12 0:38:09 PA PA_FP_TXN_CURRENCIES TABLE2004-6-12 0:38:11 PA PA_FP_TXN_LINES_TMP TABLE2004-6-12 0:38:12 PA PA_FP_UPGRADE_AUDIT TABLE2004-6-12 0:38:13 PA PA_FP_UPG_EXCEPTIONS_TMP TABLE2004-6-12 0:38:17 PA PA_FP_WEBADI_XFACE_TMP TABLE2004-6-12 0:38:17 PA PA_FRCST_ITEMS_AR TABLE2004-6-12 0:38:18 PA PA_FRCST_ITEM_DTLS_AR TABLE2004-6-12 0:38:19 PA PA_FUNCTIONS TABLE2004-6-12 0:38:19 PA PA_FUNCTION_PARAMETERS TABLE2004-6-12 0:38:20 PA PA_FUND_MRC_UPG_EXCEP TABLE2004-6-12 0:38:22 PA PA_GL_INTERFACE TABLE2004-6-12 0:38:23 PA PA_GL_PERIODS_IT TABLE2004-6-12 0:38:24 PA PA_IMPLEMENTATIONS_ALL_EFC TABLE2004-6-12 0:38:26 PA PA_IND_COMPILED_SETS TABLE2004-6-12 0:38:26 PA PA_IND_COST_MULTIPLIERS TABLE2004-6-12 0:38:28 PA PA_IND_RATE_SCH_REVISIONS TABLE2004-6-12 0:38:30 PA PA_INVOICE_FORMATS TABLE2004-6-12 0:38:31 PA PA_INVOICE_FORMAT_DETAILS TABLE2004-6-12 0:38:31 PA PA_INVOICE_GROUP_COLUMNS TABLE2004-6-12 0:38:32 PA PA_INVOICE_GROUP_TABLES TABLE2004-6-12 0:38:36 PA PA_INV_GRP_COL_WHR_CLAUSES TABLE2004-6-12 0:38:36 PA PA_INV_GRP_WHR_CLAUSES TABLE2004-6-12 0:38:37 PA PA_JOB_ASSIGNMENT_OVERRIDES TABLE2004-6-12 0:38:37 PA PA_JOB_BILL_RATE_OVERRIDES TABLE2004-6-12 0:38:37 PA PA_JOB_BILL_RATE_OVERRIDES_EFC TABLE2004-6-12 0:38:38 PA PA_JOB_BILL_TITLE_OVERRIDES TABLE2004-6-12 0:38:38 PA PA_LABOR_COST_MULTIPLIERS TABLE2004-6-12 0:38:40 PA PA_LABOR_MULTIPLIERS TABLE2004-6-12 0:38:40 PA PA_LEGAL_ENTITY_IT TABLE2004-6-12 0:38:41 PA PA_LOWEST_RLMEM_IT TABLE2004-6-12 0:38:43 PA PA_LOWEST_TASKS_IT TABLE2004-6-12 0:38:44 PA PA_MAPPABLE_TXNS_TMP TABLE2004-6-12 0:38:45 PA PA_MAP_VALUE_SETS TABLE2004-6-12 0:38:46 PA PA_MASS_UPDATE_DETAILS TABLE2004-6-12 0:38:47 PA PA_MC_BUDGET_LINES_OLD115TABLE2004-6-12 0:38:49 PA PA_MC_CC_DIST_LINES_AR TABLE2004-6-12 0:38:50 PA PA_MC_CDL_AR TABLE2004-6-12 0:38:51 PA PA_MC_CUST_EVENT_RDL_AR TABLE2004-6-12 0:38:53 PA PA_MC_CUST_RDL_AR TABLE2004-6-12 0:38:57 PA PA_MC_DRAFT_INV_DETS_AR TABLE2004-6-12 0:38:58 PA PA_MC_DRAFT_INV_ITMS_AR TABLE2004-6-12 0:39:00 PA PA_MC_DRAFT_REVS_AR TABLE2004-6-12 0:39:02 PA PA_MC_EVENTS_AR TABLE2004-6-12 0:39:03 PA PA_MC_EXP_ITEMS_AR TABLE2004-6-12 0:39:11 PA PA_MC_PRJ_AST_LN_DET_AR TABLE2004-6-12 0:39:12 PA PA_MC_RETN_INV_DETLS_AR TABLE2004-6-12 0:39:14PA PA_MC_UPGRADE_RATES TABLE2004-6-12 0:39:17 PA PA_MRC_UPG_HISTORY TABLE2004-6-12 0:39:18 PA PA_NL_BILL_RATE_OVERRIDES TABLE2004-6-12 0:39:19 PA PA_NL_BILL_RATE_OVERRIDES_EFC TABLE2004-6-12 0:39:20 PA PA_NON_LABOR_RESOURCE_ORGS TABLE2004-6-12 0:39:21 PA PA_OBJECT_DIST_LISTS TABLE2004-6-12 0:39:23 PA PA_OBJECT_REGIONS TABLE2004-6-12 0:39:26 PA PA_OLD_RES_ACCUM_DTLS TABLE2004-6-12 0:39:28 PA PA_ONLINE_EXP_SETTINGS TABLE2004-6-12 0:39:29 PA PA_OPER_UNITS_IT TABLE2004-6-12 0:39:29 PA PA_OPTIONS TABLE2004-6-12 0:39:30 PA PA_ORGS_IT TABLE2004-6-12 0:39:31 PA PA_ORG_FCST_ELEMENTS TABLE2004-6-12 0:39:32 PA PA_ORG_FORECAST_LINES TABLE2004-6-12 0:39:33 PA PA_ORG_LABOR_SCH_RULE TABLE2004-6-12 0:39:34 PA PA_ORG_REPORTING_SESSIONS TABLE2004-6-12 0:39:36 PA PA_PAGE_CONTENTS TABLE2004-6-12 0:39:36 PA PA_PAGE_LAYOUTS TABLE2004-6-12 0:39:43 PA PA_PAGE_LAYOUT_REGIONS TABLE2004-6-12 0:39:43 PA PA_PARALLEL_AUTOINSTALL TABLE2004-6-12 0:39:44 PA PA_PARAMETERS TABLE2004-6-12 0:39:44 PA PA_PERIODS_IT TABLE2004-6-12 0:39:48 PA PA_PJI_PROJ_EVENTS_LOG TABLE2004-6-12 0:39:48 PA PA_PM_CONTROL_ACTIONS TABLE2004-6-12 0:39:49 PA PA_PM_PRODUCT_CONTROL_RULES TABLE2004-6-12 0:39:50 PA PA_PRC_ASSIGNMENTS TABLE2004-6-12 0:39:51 PA PA_PRC_CONVERSION_RULES TABLE2004-6-12 0:39:51 PA PA_PRJ_ACCUM_ACTUALS_AR TABLE2004-6-12 0:39:52 PA PA_PRJ_ACCUM_BUDGETS_AR TABLE2004-6-12 0:39:57 PA PA_PRJ_ACCUM_COMMIT_AR TABLE2004-6-12 0:39:58 PA PA_PRJ_ACCUM_HEADERS_AR TABLE2004-6-12 0:39:58 PA PA_PRJ_ASSET_LN_DETS_AR TABLE2004-6-12 0:40:00 PA PA_PRJ_BUSINESS_GRPS_IT TABLE2004-6-12 0:40:02 PA PA_PRJ_CLASSES_IT TABLE2004-6-12 0:40:03 PA PA_PRJ_ORGS_IT TABLE2004-6-12 0:40:03 PA PA_PRODUCT_FUNCTIONS TABLE2004-6-12 0:40:07 PA PA_PROGRESS_REPORT_VERS TABLE2004-6-12 0:40:12 PA PA_PROGRESS_ROLLUP TABLE2004-6-12 0:40:12 PA PA_PROJECTS_EFC TABLE2004-6-12 0:40:16 PA PA_PROJECTS_FOR_ACCUM TABLE2004-6-12 0:40:17 PA PA_PROJECTS_UPDATE_TEMP TABLE2004-6-12 0:40:19 PA PA_PROJECT_ACCUM_ACTUALS_EFC TABLE2004-6-12 0:40:25 PA PA_PROJECT_ACCUM_BUDGETS_EFC TABLE2004-6-12 0:40:26 PA PA_PROJECT_ACCUM_COMMITS_EFC TABLE2004-6-12 0:40:28 PA PA_PROJECT_ASGMTS_AR TABLE2004-6-12 0:40:29 PA PA_PROJECT_ASSETS_EFC TABLE2004-6-12 0:40:32 PA PA_PROJECT_CONTACTS TABLE2004-6-12 0:40:41 PA PA_PROJECT_COPY_OVERRIDES TABLE2004-6-12 0:40:42 PA PA_PROJECT_CTX_SEARCH TABLE2004-6-12 0:40:42 PA PA_PROJECT_CUSTOMERS_EFC TABLE2004-6-12 0:40:44 PA PA_PROJECT_EVENT_ACCUM TABLE2004-6-12 0:40:44 PA PA_PROJECT_EVENT_ACCUM_EFC TABLE2004-6-12 0:40:45 PA PA_PROJECT_EXPEND_CATEGORIES TABLE2004-6-12 0:40:46 PA PA_PROJECT_EXP_ITEM_ACCUM TABLE2004-6-12 0:40:47 PA PA_PROJECT_EXP_ITEM_ACCUM_EFC TABLE2004-6-12 0:40:48PA PA_PROJECT_FUNDINGS_EFC TABLE2004-6-12 0:40:50 PA PA_PROJECT_OPP_ATTRS TABLE2004-6-12 0:40:50 PA PA_PROJECT_OPTIONS TABLE2004-6-12 0:40:51 PA PA_PROJECT_PARTIES TABLE2004-6-12 0:40:57 PA PA_PROJECT_PARTIES_AR TABLE2004-6-12 0:40:58 PA PA_PROJECT_PLAYERS_OLD TABLE2004-6-12 0:40:58 PA PA_PROJECT_REQUESTS TABLE2004-6-12 0:40:59 PA PA_PROJECT_RETENTIONS TABLE2004-6-12 0:40:59 PA PA_PROJECT_SETS_TL TABLE2004-6-12 0:41:04 PA PA_PROJECT_SET_LINES TABLE2004-6-12 0:41:10 PA PA_PROJECT_SUBTEAMS TABLE2004-6-12 0:41:12 PA PA_PROJ_ASGN_TIME_CHART TABLE2004-6-12 0:41:15 PA PA_PROJ_PERIOD_PROFILES TABLE2004-6-12 0:41:26 PA PA_PROJ_PROGRESS_REPORTS TABLE2004-6-12 0:41:28 PA PA_PROJ_ROLLUP_OBJ_TEMP TABLE2004-6-12 0:41:31 PA PA_PROJ_STRUCTURE_TYPES TABLE2004-6-12 0:41:33 PA PA_PROJ_UPD_WARN_TEMP TABLE2004-6-12 0:41:40 PA PA_PROJ_WORKPLAN_ATTR TABLE2004-6-12 0:41:40 PA PA_PURGE_PRJ_DETAILS TABLE2004-6-12 0:41:42 PA PA_PURGE_PROJECT_ERRORS TABLE2004-6-12 0:41:44 PA PA_REP_UTIL_SCREEN_TMP TABLE2004-6-12 0:41:53 PA PA_REP_UTIL_SCR_U1_TMP TABLE2004-6-12 0:41:54 PA PA_REP_UTIL_SUMM00_TMP TABLE2004-6-12 0:41:54 PA PA_REP_UTIL_SUMM0_TMP TABLE2004-6-12 0:41:55 PA PA_REP_UTIL_SUMM_TMP TABLE2004-6-12 0:41:55 PA PA_REQUEST_ASSOC_TEMP TABLE2004-6-12 0:41:56 PA PA_REQ_CREATE_TEMP TABLE2004-6-12 0:41:57 PA PA_REQ_CREATE_WARN_TEMP TABLE2004-6-12 0:41:58 PA PA_RESOURCE_ACCUM_DETAILS TABLE2004-6-12 0:42:01 PA PA_RESOURCE_ASSIGNMENTS_AR TABLE2004-6-12 0:42:07 PA PA_RESOURCE_FORMATS TABLE2004-6-12 0:42:07 PA PA_RESOURCE_FORMAT_RANKS TABLE2004-6-12 0:42:08 PA PA_RESOURCE_LIST_ASSIGNMENTS TABLE2004-6-12 0:42:10 PA PA_RESOURCE_LIST_PARENTS_TMP TABLE2004-6-12 0:42:11 PA PA_RESOURCE_MAPS TABLE2004-6-12 0:42:12 PA PA_RES_ACCUM_DETAILS_AR TABLE2004-6-12 0:42:15 PA PA_RES_ASGN_TIME_CHART TABLE2004-6-12 0:42:15 PA PA_RES_ASSIGNMENTS_AR TABLE2004-6-12 0:42:16 PA PA_RES_AVAILABILITY TABLE2004-6-12 0:42:21 PA PA_RES_SCH_TIME_CHART TABLE2004-6-12 0:42:22 PA PA_RETN_INVOICE_DETAILS TABLE2004-6-12 0:42:23 PA PA_RETN_INV_DETAILS_AR TABLE2004-6-12 0:42:23 PA PA_ROLE_PROFILES TABLE2004-6-12 0:42:26 PA PA_ROLE_PROFILE_LINES TABLE2004-6-12 0:42:27 PA PA_ROUTINGS_AR TABLE2004-6-12 0:42:28 PA PA_RULE_PARAMETERS TABLE2004-6-12 0:42:30 PA PA_SCHEDULES TABLE2004-6-12 0:42:31 PA PA_SCHEDULES_AR TABLE2004-6-12 0:42:37 PA PA_SCHEDULES_HISTORY TABLE2004-6-12 0:42:37 PA PA_SCHEDULES_HSTRY_AR TABLE2004-6-12 0:42:38 PA PA_SCHEDULE_ELEMENTS TABLE2004-6-12 0:42:39 PA PA_SCHEDULE_EXCEPTIONS TABLE2004-6-12 0:42:39 PA PA_SCHEDULE_EXCEPT_HISTORY TABLE2004-6-12 0:42:40 PA PA_SCHEDULE_OBJECTS TABLE2004-6-12 0:42:41 PA PA_SCH_EXCPT_HSTRY_AR TABLE2004-6-12 0:42:47PA PA_SEARCH_RESULTS_TEMP TABLE2004-6-12 0:42:52 PA PA_SEGMENT_VALUE_LOOKUP_SETS TABLE2004-6-12 0:42:53 PA PA_SET_OF_BOOKS_IT TABLE2004-6-12 0:42:54 PA PA_SPAWNED_PROGRAM_STATUSES TABLE2004-6-12 0:42:54 PA PA_SRVC_TYPES_IT TABLE2004-6-12 0:42:55 PA PA_STATUS_COLUMN_SETUP TABLE2004-6-12 0:42:56 PA PA_STREAMLINE_REQUESTS TABLE2004-6-12 0:42:58 PA PA_SUBBUDGETS TABLE2004-6-12 0:43:04 PA PA_SUMMARY_PROJECT_RETN TABLE2004-6-12 0:43:05 PA PA_SUMMARY_PROJ_FUNDINGS_EFC TABLE2004-6-12 0:43:05 PA PA_SUMM_BALANCES TABLE2004-6-12 0:43:06 PA PA_SYSTEM_NUMBERS TABLE2004-6-12 0:43:07 PA PA_TASK_TYPES TABLE2004-6-12 0:43:12 PA PA_TEAM_TEMPLATES TABLE2004-6-12 0:43:17 PA PA_TEMP_IMPORT_TASKS TABLE2004-6-12 0:43:18 PA PA_TEMP_RES_MAPS_TMP TABLE2004-6-12 0:43:18 PA PA_TIMELINE_COLORS TABLE2004-6-12 0:43:19 PA PA_TIME_CHART_TEMP TABLE2004-6-12 0:43:21 PA PA_TOP_RLMEM_IT TABLE2004-6-12 0:43:23 PA PA_TOP_TASKS_IT TABLE2004-6-12 0:43:24 PA PA_TRANSACTION_CONTROLS TABLE2004-6-12 0:43:25 PA PA_TXN_ACCUM_AR TABLE2004-6-12 0:43:37 PA PA_TXN_ACCUM_DETAILS_AR TABLE2004-6-12 0:43:39 PA PA_TXN_ACCUM_EFC TABLE2004-6-12 0:43:44 PA PA_TXN_INTERFACE_AUDIT_AR TABLE2004-6-12 0:43:45 PA PA_UBR_UER_SUMM_ACCT TABLE2004-6-12 0:43:46 PA PA_UNBILLED_REC_REPORTING TABLE2004-6-12 0:43:47 PA PA_UNIQUE_IDENTIFIER_CONTROL TABLE2004-6-12 0:43:47 PA PA_USAGE_COST_RATE_OVR_EFC TABLE2004-6-12 0:43:49 PA PA_VALID_CATEGORIES TABLE2004-6-12 0:43:52 PA PA_VALUE_MAPS TABLE2004-6-12 0:43:53 PA PA_VERIFICATION_RULES TABLE2004-6-12 0:43:58 PA PA_WF_PROCESSES TABLE2004-6-12 0:43:59 PA PA_WF_PROCESSES_AR TABLE2004-6-12 0:44:00 PA PA_WORK_TYPE_SCHEDULES TABLE2004-6-12 0:44:03 PA PA_ROLE_STATUS_MENU_MAP TABLE2004-10-30 13:02:48 PA PA_CINT_RATE_INFO_ALL TABLE2004-10-30 13:02:48 PA PA_CINT_EXP_TYPE_EXCL_ALL TABLE2004-10-30 13:02:48 PA PA_CINT_RATE_MULTIPLIERS TABLE2004-10-30 13:02:48 PA PA_STANDARD_UNIT_COSTS TABLE2004-10-30 13:02:48 PA PA_CAPITAL_EVENTS TABLE2004-10-30 13:02:48 PA PA_CINT_SOURCE_DETAILS TABLE2004-10-30 13:02:48 PA PA_ASSET_INFO_GTEMP TABLE2004-10-30 13:02:48 PA PA_WF_NTF_PERFORMERS_AR TABLE2004-10-30 13:02:48 PA PA_ASSET_INFO_GTEMP1TABLE2004-10-30 13:02:48 PA PA_WF_PROCESS_DETAILS_AR TABLE2004-10-30 13:02:49 PA PA_AUD_COST_DIST_LINES TABLE2004-10-30 13:02:49 PA PA_GANTT_CONFIG_TL TABLE2004-10-30 13:02:49 PA PA_GANTT_CONFIG_B TABLE2004-10-30 13:02:49 PA PA_GANTT_VIEWS_B TABLE2004-10-30 13:02:49 PA PA_GANTT_BAR_STYLES_TL TABLE2004-10-30 13:02:49 PA PA_GANTT_VIEWS_TL TABLE2004-10-30 13:02:49 PA PA_GANTT_BAR_TYPES TABLE2004-10-30 13:02:49 PA PA_GANTT_BAR_STYLES_B TABLE2004-10-30 13:02:49 PA PA_GANTT_COLUMNS TABLE2004-10-30 13:02:50PA PA_FP_EXCLUDED_ELEMENTS TABLE2004-10-30 13:02:50 PA PA_ROLE_JOB_BGS TABLE2004-10-30 13:02:50 PA PA_TXN_UPGRADE_TEMP TABLE2004-10-30 13:02:50 PA PA_UPGRADE_AUDIT TABLE2004-10-30 13:02:50 PA PA_PROJECTS_ERP_EXT_B TABLE2004-10-30 13:03:54 PA PA_PROJECTS_ERP_EXT_TL TABLE2004-10-30 13:03:59 PA PA_WORK_PATTERN_TEMP_TABLE TABLE2004-10-30 13:04:34 PA PA_GL_REV_XFER_AUDIT_REP TABLE2004-10-30 13:18:23 PA DR$PA_PROJECT_CTX_SEARCH_C1$I TABLE2004-11-1 13:54:49 PA DR$PA_PROJECT_CTX_SEARCH_C1$K TABLE2004-11-1 13:54:49 PA DR$PA_PROJECT_CTX_SEARCH_C1$R TABLE2004-11-1 13:54:49 PA DR$PA_PROJECT_CTX_SEARCH_C1$N TABLE2004-11-1 13:54:49 PA PA_CP_TASK_AMOUNTS_GTEMP TABLE2005-7-16 4:03:42 PA PA_CP_TASK_AMOUNTS_GTEMP1TABLE2005-7-16 4:03:44。

oracle EBS常用表

oracle EBS常用表

ORACLE EBS常用表2009-09-25 11:21call fnd_global.APPS_INITIALIZE(1318,50583,401)select fnd_profile.VALUE('ORG_ID') FROM DUALselect * from hr_operating_units hou where anization_id=204 --fndselect * from fnd_applicationselect * from fnd_application_tl where application_id=101select * from fnd_application_vl where application_id = 101----值集select * from fnd_flex_value_setsselect * from fnd_flex_valuesselect * from fnd_flex_values_vl----弹性域SELECT * FROM FND_ID_FLEX_STRUCTURES_VL—键弹性域select * from fnd_id_flexsselect * from fnd_id_flex_structures where id_flex_code='GL#'select * from fnd_id_flex_segments where id_flex_code='GL#' andid_flex_num=50671select * from fnd_profile_options_vlselect * from fnd_concurrent_programs 程序表select * from fnd_concurrent_requests 请求表select * from fnd_concurrent_processes 进程表--invselect * from org_organization_definitions 库存组织select * from mtl_parameters 组织参数select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表select * from mtl_secondary_inventories 子库存select * from mtl_item_locations 货位select * from mtl_lot_numbers 批次select * from mtl_onhand_quantities 现有量表select * from mtl_serial_numbers 序列select * from mtl_material_transactions 物料事务记录select * from mtl_transaction_accounts 会计分录select * from mtl_transaction_types 事务类型select * from mtl_txn_source_types 事务来源类型select * from mfg_lookups ml where ml.LOOKUP_TYPE ='MTL_TRANSACTION_ACTION'--poselect * from po_requisition_headers_all 请求头select * from po_requisition_lines_all 请求行select * from po_headers_all 订单头select * from po_lines_all 订单行select * from po_line_locations_allselect * from po_distributions_all 分配select * from po_releases_all 发送select * from rcv_shipment_headers 采购接收头select * from rcv_shipment_lines 采购接收行select * from rcv_transactions 接收事务处理select * from po_agentsselect * from po_vendors 订单select * from po_vendor_sites_all--oeselect * from ra_customers 客户select * from ra_addresses_all 地址select * from ra_site_uses_all 用户select * from oe_order_headers_all 销售头select * from oe_order_lines_all 销售行select * from wsh_new_deliveries 发送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments--glselect * from gl_sets_of_books 总帐select * from gl_code_combinations gcc where gcc.summary_flag='Y' 科目组合select * from gl_balances 科目余额select * from gl_je_batches 凭证批select * from gl_je_headers 凭证头select * from gl_je_lines 凭证行select * from gl_je_categories 凭证分类select * from gl_je_sources 凭证来源select * from gl_summary_templates 科目汇总模板select * from gl_account_hierarchies 科目汇总模板层次--arselect * from ar_batches_all 事务处理批select * from ra_customer_trx_all 发票头select * from ra_customer_trx_lines_all 发票行select * from ra_cust_trx_line_gl_dist_all 发票分配select * from ar_cash_receipts_all 收款select * from ar_receivable_applications_all 核销select * from ar_payment_schedules_all 发票调整select * from ar_adjustments_all 会计分录select * from ar_distributions_all 付款计划--apselect * from ap_invoices_all 发票头select * from ap_invoice_distributions_all 发票行select * from ap_payment_schedules_all 付款计划select * from ap_check_stocks_all 单据select * from ap_checks_all 付款select * from ap_bank_branches 银行select * from ap_bank_accounts_all 银行帐号select * from ap_invoice_payments_all 核销========================华丽的分割线=========================INV库存organization 两个含义:1. 经营单位,A/B/C分公司,A下面有A1,A2等工厂,主题目标是为了独立核算此组织ORG,ORG_ID;2. 库存组织,例如制造商的仓库,例如A1,A2等工厂Organization_id;HR_ORGANIZATION_UNITS -Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数(没有用ID,直接用name)MTL_SYSTEM_ITEMS_b -物料信息(同上,应用了库存组织name)MTL_SECONDARY_INVENTORIES -子库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本;ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位现有量汇总历史记录(正负合计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物品 summary可能按照挑库先进先出统计,如果设置了"不允许负库存",这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收-退货/组织间转移/正常状态都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态!例如:接收100个,80个接受入库,20个退回,那么有80个接受事务/20个退回事物select TRANSACTION_TYPE,DESTINATION_TYPE_CODE from RCV_TRANSACTIONS 可以看出以下阶段:A1.RECEIVE – RECEIVINGA2.ACCEPT – RECEIVINGA3.DELIERY – INVETORY(影响库存现有量)如果按照正常模式,最后会触发产生MTL_MATERIAL_TRANSACTIONS销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_TO_ORG_ID和客户结构有关客户 RA_customers客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 siteOE_ORDER_LINEs_allGL凭证gl_je_batches凭证日期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CRgl_je_headers日记账头信息批号: JE_BATCH_ID会计期间: PERIOD_NAME币种: CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率日期: CURRENCY_CONVERSION_DATE帐套: SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCEgl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额AR应收发票RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID 发票编号BILL_TO_SITE_USE_ID 客户收单方编号PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框,但是由于版本问题和长度(<=30),不建议用户使用,如果要使用外部编号,请使用说明性弹性域RA_CUSTOMER_TRX_LINES_ALLLINE_ID 行号INVENTORY_ITEM_ID 可以为空,比如非物料的服务,只在DE script ION中出现 /税行DE script IONQUANTITY_INVOICE 开票数量LINE_TYPE 行类型 (一般/税)EXTEND_PRICE 本行金额注意:税行是隐藏行,所以至少会有两行收款情况AR_CASH_RECEIPTS_ALL(还包含了非收款信息)CASH_RECEIPT_ID 内部codeRECEIPT_NUMBER 收款号RECEIPT_DATE 收款日期AMOUNT 总额RECEIPT_TYPE 现金/杂项 Cash/MiscFUNCTIONAL_AMOUNT 本位币计量金额UI上为RECEIPTS核销关系不是一一对应,也不是一次核销100%,UI上右下方的Application 按钮AR_RECEIVABLE_APPLICATIONS_ALLAPPLIED_CUSTOMER_TRX_ID 发票编号APPLIED_CUSTOMER_TRX_LINE_ID 发票行编号STATUS APP表示核销 /UNAPP表示未核销AMOUNT_APPLIED 匹配金额注意:红冲收款报表时间跨月的问题;必须联查 AR_CASH_RECEIPTS_ALL和 AR_CASH_RECEIPT_HISTORY_ALLAP应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoice AP_INVOICES_ALL实际付款PAYMENTAP_CHECKS_ALL核销关系同AR,右下方的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表,情况比较复杂:比如两个用户合并,应收应付差额,预付款资产信息FA_ADDITIONS名称编号分类数量资产类别FA_CATEGORIES资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系?FA_BOOKSUI中的InquiryMothed是折旧方法(直线法/产量法)FA_DISTRIBUTION_HISTORY分配assignment,给什么部门使用多少LOCATION_ID 部门联查FA_LOCATIONS折旧信息(分摊方法)FA_DEPRN_DETAILperiod_counter 折旧期间编号折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERS========================华丽的分割线=========================fnd_user ---系统用户表po_vendors ---供应商信息表po_vendor_sites ---供应商地点信息表hr_organization_units ---组织及库存组织表per_people_f ---员工表wip_entities ---作业名信息表wip_discrete_jobs ---离散作业表wip_requirement_operations ---作业名物料需求发放表po_headers_all ---采购订单头表po_lines_all ---采购订单行表po_line_locations_all ---采购行地点表rcv_transactions ---接收交易表bom_bill_of_materials ---物料清单表bom_inventory_components ---物料清单构成表mtl_system_items ---物料主表mtl_onhand_quantities ---库存数据表mtl_item_locations ---项目货位表mtl_material_transactions ---出入库记录表mtl_supply ---供应表mtl_demand ---需求表。

关于oracle自带的表

关于oracle自带的表

关于oracle自带的表***********************************8emp:empno:员工编号;ename:员工名字;job:员工工种;mgr: 上司;hiredate:入职时间;sal:基本工资;comm:补贴;deptno:所属部门编号;dept:deptno:部门编号;dname:部门名称;loc:地理位置;salgrade:grade:工资等级;losal:最低限额;hisal:最高限额;dual:系统自带的一张空表;可用于计算数据:select 2*3 from dual;**sql_function1**********************************************************select lower(ename) from emp; 取出的名字全部变成小写。

select ename from emp where lower(ename) like '_a%';取出的名字变成小写后不含字母aselect substr(ename, 2, 3) from emp;从第二个字符截,截取三个字符。

select cha(65) from dual; 将数字转化为字符(显示为a)。

select ascii('A') from dual; 将字符转化为数字。

select round(23.652) from dual; (显示24)select round(23.652, 2) from dual; (显示23.65)select round(23.652, -1) from dual; (显示20)select to_char(sal, '$99,999.9999')from emp;强制转化为指定的格式。

select to_char(sal, 'L0000.0000')from emp;同上。

Oracle系统表大全

Oracle系统表大全

数据字典dict总是属于Oracle用户sys的。

、用户:select username from dba_users;改口令alter user spgroup identified by spgtest;2、表空间:select * from dba_data_files;select * from dba_tablespaces;//表空间select tablespace_name,sum(bytes), sum(blocks)from dba_free_space group by tablespace_name;//空闲表空间select * from dba_data_fileswhere tablespace_name='RBS';//表空间对应的数据文件select * from dba_segmentswhere tablespace_name='INDEXS';3、数据库对象:select * from dba_objects;CLUSTER、DATABASE LINK、FUNCTION、INDEX、LIBRARY、PACKAGE、PAC KAGE BODY、PROCEDURE、SEQUENCE、SYNONYM、TABLE、TRIGGER、TYPE、UNDEFINED、VIEW。

4、表:select * from dba_tables;analyze my_table compute statistics;>dba_tables后6列select extent_id,bytes from dba_extentswhere segment_name='CUSTOMERS' and segment_type='TABLE'order by extent_id;//表使用的extent的信息。

segment_type='ROLLBACK'查看回滚段的空间分配信息列信息:select distinct table_namefrom user_tab_columnswhere column_name='SO_TYPE_ID';5、索引:select * from dba_indexes;//索引,包括主键索引select * from dba_ind_columns;//索引列select i.index_name,i.uniqueness,c.column_namefrom user_indexes i,user_ind_columns cwhere i.index_name=c.index_nameand i.table_name ='ACC_NBR';//联接使用6、序列:select * from dba_sequences;7、视图:select * from dba_views;select * from all_views;text 可用于查询视图生成的脚本8、聚簇:select * from dba_clusters;9、快照:select * from dba_snapshots;快照、分区应存在相应的表空间。

OracleERP系统表结构详细设计

OracleERP系统表结构详细设计
UOM_CLASS DISABLE_DATE DESCRIPTION VARCHAR2(10) DATE VARCHAR2(50)
表名: inv.mtl_uom_class_ 表名: inv.mtl_uom_class_conversions 说明: 单位类别换算 说明:
INVENTORY_ITEM_ID FROM_UNIT_OF_MEASURE FROM_UOM_CODE FROM_UOM_CLASS TO_UNIT_OF_MEASURE TO_UOM_CODE TO_UOM_CLASS CONVERSION_RATE DISABLE_DATE NUMBER VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) VARCHAR2(25) VARCHAR2(3) VARCHAR2(10) NUMBER DATE
INV模块常用表结构 INV模块常用表结构
表名:inv.mtl_system_ 表名:inv.mtl_system_items 说明: 说明: 物料主表
列名 ORGANIZATION_ID INVENTORY_ITEM_ID SEGMENT1 UNIT_OF_ISSUE DESCRIPTION ALLOWED_UNITS_LOOKUP_CODE INVENTORY_ITEM_STATUS_CODE ITEM_TYPE PRIMARY_UNIT_OF_MEASURE BASE_ITEM_ID BOM_ENABLED_FLAG BOM_ITEM_TYPE ENGINEERING_ECN_CODE ENGINEERING_ITEM_ID ENG_ITEM_FLAG COSTING_ENABLED_FLAG COST_OF_SALES_ACCOUNT DEFAULT_INCLUDE_IN_ROLLUP_FLAG INVENTORY_ASSET_FLAG STD_LOT_SIZE ALLOW_ITEM_DESC_UPDATE_FLAG ASSET_CATEGORY_ID BUYER_ID ENCUMBRANCE_ACCOUNT EXPENSE_ACCOUNT HAZARD_CLASS_ID LIST_PRICE_PER_UNIT MARKET_PRICE OUTSIDE_OPERATION_FLAG OUTSIDE_OPERATION_UOM_TYPE PRICE_TOLERANCE_PERCENT PURCHASING_ENABLED_FLAG PURCHASING_ITEM_FLAG ROUNDING_FACTOR TAXABLE_FLAG UNIT_OF_ISSUE ALLOW_EXPRESS_DELIVERY_FLAG ALLOW_SUBSTITUTE_RECEIPTS_FLAG DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED ENFORCE_SHIP_TO_LOCATION_CODE INVOICE_CLOSE_TOLERANCE QTY_RCV_EXCEPTION_CODE QTY_RCV_TOLERANCE RECEIPT_REQUIRED_FLAG RECEIVE_CLOSE_TOLERANCE RECEIVING_ROUTING_ID 类型 NUMBER NUMBER VARCHAR2(40)

oracle ebs 11i 数据表大全(总帐、应收、应付等各模块) 免费

oracle ebs 11i 数据表大全(总帐、应收、应付等各模块) 免费

OWNER OBJECT_NAMEOBJECT_TYPE CREATED PO PO_LOCATION T ABLE##########TABLE########## PO PO_VENDOR_STABLE########## PO PO_LINE_LOCAPO PO_VENDORS T ABLE##########TABLE########## PO RCV_TRANSACPO PO_DOCUMEN T ABLE########## PO PO_HEADERS_TABLE########## PO PO_HEADERS_TABLE########## PO PO_LINES_ALL TABLE########## PO PO_DISTRIBUT TABLE########## PO PO_RELEASES TABLE########## PO PO_REQEXPRETABLE##########TABLE########## PO PO_VENDOR_CTABLE########## PO PO_REQUISITIOPO PO_REQ_DISTRTABLE##########TABLE########## PO PO_REQUISITIOTABLE########## PO PO_UN_NUMBEPO PO_LINE_TYPE TABLE##########TABLE########## PO PO_APPROVEDTABLE########## PO PO_REQEXPREPO PO_LINE_LOCATABLE########## PO PO_ASL_ATTRI TABLE##########TABLE########## PO PO_SUPPLIER_PO PO_ACTION_HI TABLE##########TABLE########## PO PO_MASSCANCPO PO_NOTIFICAT TABLE########## PO PO_DOCUMEN T ABLE##########TABLE########## PO PO_CONTROL_TABLE########## PO PO_EMPLOYEEPO PO_POSITION_TABLE########## PO PO_DISTRIBUT TABLE##########TABLE########## PO PO_LINES_ARCPO PO_RELEASES TABLE##########TABLE########## PO PO_REQUISITIOPO PO_HAZARD_C TABLE##########TABLE########## PO PO_REQ_DIST_PO PO_SYSTEM_P TABLE##########TABLE########## PO PO_HISTORY_PPO PO_UNIQUE_IDTABLE##########TABLE########## PO PO_HISTORY_RPO PO_QUOTATIO TABLE##########TABLE########## PO PO_AUTOSOURTABLE########## PO PO_AUTOSOURTABLE########## PO PO_AUTOSOURPO RCV_SERIAL_T TABLE########## PO PO_ACCRUAL_TABLE########## PO PO_ACCRUAL_TABLE########## PO PO_ACCRUAL_TABLE##########TABLE########## PO RCV_TRANSACTABLE########## PO PO_QUALITY_CPO PO_AGENTS TABLE########## PO RCV_SHIPMEN TABLE########## PO RCV_SHIPMEN TABLE########## PO FND_NOTIFICA TABLE##########PO PO_HEADERS_TABLE########## PO PO_MC_DISTR T ABLE##########TABLE########## PO PO_MC_HEADETABLE########## PO RCV_MC_SHIPMTABLE########## PO RCV_MC_TRANTABLE########## PO POA_BIS_SAVINPO RCV_MC_REC_TABLE########## PO PO_ASL_DOCU TABLE########## PO RCV_RECEIVIN TABLE########## PO PO_VENDOR_L TABLE########## PO PO_VENDOR_L TABLE########## PO RCV_MC_SUB_TABLE##########TABLE########## PO EDW_PO_VENDPO CHV_AUTHORI TABLE########## PO CHV_BUCKET_TABLE########## PO CHV_CUM_ADJ TABLE########## PO CHV_CUM_PERTABLE##########TABLE########## PO CHV_CUM_PERPO CHV_ITEM_OR T ABLE########## PO CHV_ORG_OPTTABLE##########TABLE########## PO CHV_SCHEDULTABLE########## PO CHV_SCHEDULPO PO_ACCEPTANTABLE##########TABLE########## PO PO_ASL_STATUTABLE########## PO PO_CONTROL_PO PO_CONTROL_TABLE########## PO PO_NOTE_REF TABLE########## PO PO_NOTIFICAT TABLE########## PO PO_RFQ_VENDTABLE##########TABLE########## PO RCV_LOTS_INTPO RCV_ROUTING TABLE########## PO PO_RELATED_TABLE##########TABLE########## PO PO_MASSCANCPO RCV_LOT_TRA TABLE##########TABLE########## PO PO_ASL_STATUPO POA_BIS_SAVINTABLE########## PO CHV_HISTORY TABLE########## PO CHV_HISTORY TABLE########## PO CHV_PURGE_CTABLE##########TABLE########## PO CHV_PURGE_STABLE########## PO CHV_SCHEDULTABLE########## PO FND_FUNCTIONTABLE########## PO POA_BIS_SAVINTABLE########## PO POA_BIS_SAVINTABLE########## PO POA_BIS_SUPPTABLE########## PO POA_BIS_SUPPTABLE########## PO POA_CM_DISTRPO POA_CM_EVAL TABLE########## PO POA_CM_EVAL TABLE########## PO PO_ACCRUAL_TABLE########## PO PO_APPROVAL TABLE########## PO PO_APPROVAL TABLE########## PO PO_ATT_TMP_TABLE##########TABLE########## PO PO_CHANGE_RPO PO_DISTRIBUT TABLE########## PO PO_DISTRIBUT TABLE########## PO PO_DISTRIBUT TABLE##########TABLE########## PO PO_GA_ORG_APO PO_HAZARD_C TABLE########## PO PO_HEADERS_TABLE########## PO PO_HEADERS_TABLE##########TABLE########## PO PO_HISTORY_RTABLE########## PO PO_HISTORY_VTABLE########## PO PO_INTERFACEPO PO_LINES_ALL TABLE########## PO PO_LINES_GT TABLE##########TABLE########## PO PO_LINES_INTEPO PO_LINE_LOCATABLE##########TABLE########## PO PO_LINE_LOCAPO PO_LINE_TYPE TABLE########## PO PO_NOTES TABLE########## PO PO_NOTE_ATT TABLE##########TABLE########## PO PO_ONLINE_RETABLE########## PO PO_ONLINE_RETABLE########## PO PO_PURGE_POTABLE########## PO PO_PURGE_REPO PO_PURGE_VETABLE########## PO PO_RELEASES TABLE########## PO PO_RELEASES TABLE########## PO PO_REQUISITIOTABLE##########TABLE########## PO PO_REQUISITIOTABLE########## PO PO_REQ_DISTRTABLE########## PO PO_REQ_DISTRTABLE########## PO PO_REQ_HEADTABLE########## PO PO_REQ_LINESTABLE########## PO PO_REQ_SPLITTABLE########## PO PO_RESCHEDUPO PO_RETROPRI TABLE########## PO PO_RULE_EXP TABLE########## PO PO_SUPPLIER_TABLE##########TABLE########## PO PO_UN_NUMBEPO PO_USAGES TABLE########## PO PO_USAGE_AT TABLE##########TABLE########## PO PO_VENDORS_TABLE########## PO PO_VENDOR_SPO PO_WF_CANDI TABLE##########TABLE########## PO PO_WF_DEBUGTABLE########## PO RCV_HEADERSPO RCV_LOTS_SU TABLE########## PO RCV_PARAMETTABLE##########TABLE########## PO RCV_SERIALS_TABLE########## PO RCV_SERIALS_PO RCV_SHIPMEN TABLE########## PO RCV_SUB_LED TABLE########## PO RCV_SUPPLY TABLE##########TABLE########## PO RCV_UPGRADETABLE########## PO PO_COMMODITTABLE########## PO PO_COMMODITPO RCV_GAPLESS TABLE##########TABLE########## PO PO_COMMODITPO PO_JOB_ASSO TABLE########## PO PO_JOB_ASSO TABLE##########TABLE########## PO PO_RETRIEVEDPO RCV_FTE_TRA TABLE########## PO PO_GA_ORG_ATABLE########## PO PO_PRICE_DIF TABLE##########TABLE########## PO RCV_ACCOUNTTABLE########## PO RCV_ACCOUNTPO RCV_ROUTING TABLE########## PO PO_REQUISITIOTABLE########## PO PO_PRICE_DIF TABLE########## PO PO_ADDRESS_TABLE########## PO PO_PRICE_DIF TABLE##########TABLE########## PO PO_COMMUNICTABLE########## PO PO_ENCUMBRATABLE########## PO PO_SESSION_GPO MLOG$_PO_VE TABLE########## PO MLOG$_PO_VE TABLE##########TABLE########## PO MLOG$_PO_CO。

ORACLEEBS常用表

ORACLEEBS常用表

ORACLEEBS常⽤表call fnd_global.APPS_INITIALIZE(1318,50583,401)select fnd_profile.VALUE('ORG_ID') FROM DUALselect * from hr_operating_units hou where anization_id=204--fndselect * from fnd_applicationselect * from fnd_application_tl where application_id=101select * from fnd_application_vl where application_id = 101----值集select * from fnd_flex_value_setsselect * from fnd_flex_valuesselect * from fnd_flex_values_vl----弹性域select * from fnd_id_flexsselect * from fnd_id_flex_structures where id_flex_code='GL#'select * from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num=50671select * from fnd_profile_options_vlselect * from fnd_concurrent_programs 程序表select * from fnd_concurrent_requests 请求表select * from fnd_concurrent_processes 进程表--invselect * from org_organization_definitions 库存组织select * from mtl_parameters 组织参数select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表select * from mtl_secondary_inventories ⼦库存select * from mtl_item_locations 货位select * from mtl_lot_numbers 批次select * from mtl_onhand_quantities 现有量表select * from mtl_serial_numbers 序列select * from mtl_material_transactions 物料事务记录select * from mtl_transaction_accounts 会计分录select * from mtl_transaction_types 事务类型select * from mtl_txn_source_types 事务来源类型select * from mfg_lookups ml where ml.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'--poselect * from po_requisition_headers_all 请求头select * from po_requisition_lines_all 请求⾏select * from po_lines_all 订单⾏select * from po_line_locations_allselect * from po_distributions_all 分配select * from po_releases_all 发送select * from rcv_shipment_headers 采购接收头select * from rcv_shipment_lines 采购接收⾏select * from rcv_transactions 接收事务处理select * from po_agentsselect * from po_vendors 订单select * from po_vendor_sites_all--oeselect * from ra_customers 客户select * from ra_addresses_all 地址select * from ra_site_uses_all ⽤户select * from oe_order_headers_all 销售头select * from oe_order_lines_all 销售⾏select * from wsh_new_deliveries 发送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments--glselect * from gl_sets_of_books 总帐select * from gl_code_combinations gcc where gcc.summary_flag='Y' 科⽬组合select * from gl_balances 科⽬余额select * from gl_je_batches 凭证批select * from gl_je_headers 凭证头select * from gl_je_lines 凭证⾏select * from gl_je_categories 凭证分类select * from gl_je_sources 凭证来源select * from gl_summary_templates 科⽬汇总模板select * from gl_account_hierarchies 科⽬汇总模板层次--arselect * from ar_batches_all 事务处理批select * from ra_customer_trx_all 发票头select * from ra_customer_trx_lines_all 发票⾏select * from ra_cust_trx_line_gl_dist_all 发票分配select * from ar_cash_receipts_all 收款select * from ar_receivable_applications_all 核销select * from ar_payment_schedules_all 发票调整select * from ar_distributions_all 付款计划--apselect * from ap_invoices_all 发票头select * from ap_invoice_distributions_all 发票⾏select * from ap_payment_schedules_all 付款计划select * from ap_check_stocks_all 单据select * from ap_checks_all 付款select * from ap_bank_branches 银⾏select * from ap_bank_accounts_all 银⾏帐号select * from ap_invoice_payments_all 核销========================华丽的分割线=========================INV库存organization 两个含义:1. 经营单位,A/B/C分公司,A下⾯有A1,A2等⼯⼚,主题⽬标是为了独⽴核算此组织ORG,ORG_ID;2. 库存组织,例如制造商的仓库,例如A1,A2等⼯⼚Organization_id;HR_ORGANIZATION_UNITS -Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数(没有⽤ID,直接⽤name)MTL_SYSTEM_ITEMS_b -物料信息(同上,应⽤了库存组织name)MTL_SECONDARY_INVENTORIES -⼦库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本;ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位现有量汇总历史记录(正负合计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/⼦库存/货位/物品 summary可能按照挑库先进先出统计,如果设置了"不允许负库存",这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all⾏表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收-退货/组织间转移/正常状态都需要使⽤这个模块RCV_TRANSACTIONS1. 接收100单位货物,放⼊“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态!例如:接收100个,80个接受⼊库,20个退回,那么有80个接受事务/20个退回事物select TRANSACTION_TYPE,DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段:A1.RECEIVE – RECEIVINGA2.ACCEPT – RECEIVINGA3.DELIERY – INVETORY(影响库存现有量)如果按照正常模式,最后会触发产⽣MTL_MATERIAL_TRANSACTIONS销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_TO_ORG_ID和客户结构有关客户 RA_customers客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 siteOE_ORDER_LINEs_allGL凭证gl_je_batches凭证⽇期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷⽅汇总: RUNNING_TOTAL_DR/CR ⽐如美元本位币凭证批借贷⽅汇总: RUNNING_TOTAL_ACCOUNTED_DR/CRgl_je_headers⽇记账头信息批号: JE_BATCH_ID会计期间: PERIOD_NAME币种: CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率⽇期: CURRENCY_CONVERSION_DATE帐套: SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCEgl_je_lines⽇记账体信息CODE_COMBINATION_ID 科⽬组合编号GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额AR应收发票RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID 发票编号BILL_TO_SITE_USE_ID 客户收单⽅编号PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输⼊框,但是由于版本问题和长度(<=30),不建议⽤户使⽤,如果要使⽤外部编号,请使⽤说明性弹性域RA_CUSTOMER_TRX_LINES_ALLLINE_ID ⾏号INVENTORY_ITEM_ID 可以为空,⽐如⾮物料的服务,只在DE script ION中出现 /税⾏DE script IONQUANTITY_INVOICE 开票数量LINE_TYPE ⾏类型 (⼀般/税)EXTEND_PRICE 本⾏⾦额注意:税⾏是隐藏⾏,所以⾄少会有两⾏收款情况AR_CASH_RECEIPTS_ALL(还包含了⾮收款信息)CASH_RECEIPT_ID 内部codeRECEIPT_NUMBER 收款号RECEIPT_DATE 收款⽇期AMOUNT 总额RECEIPT_TYPE 现⾦/杂项 Cash/MiscFUNCTIONAL_AMOUNT 本位币计量⾦额UI上为RECEIPTS核销关系不是⼀⼀对应,也不是⼀次核销100%,UI上右下⽅的Application 按钮APPLIED_CUSTOMER_TRX_ID 发票编号APPLIED_CUSTOMER_TRX_LINE_ID 发票⾏编号STATUS APP表⽰核销 /UNAPP表⽰未核销AMOUNT_APPLIED 匹配⾦额注意:红冲收款报表时间跨⽉的问题;必须联查 AR_CASH_RECEIPTS_ALL和 AR_CASH_RECEIPT_HISTORY_ALL AP应付帐款(是我⽅⼈员按照供应商提供的纸张发票信息录⼊)UI 上的invoiceAP_INVOICES_ALL实际付款PAYMENTAP_CHECKS_ALL核销关系同AR,右下⽅的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表,情况⽐较复杂:⽐如两个⽤户合并,应收应付差额,预付款资产信息FA_ADDITIONS名称编号分类数量资产类别FA_CATEGORIES资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系?FA_BOOKSUI中的InquiryMothed是折旧⽅法(直线法/产量法)FA_DISTRIBUTION_HISTORY分配assignment,给什么部门使⽤多少LOCATION_ID 部门联查FA_LOCATIONS折旧信息(分摊⽅法)FA_DEPRN_DETAILperiod_counter 折旧期间编号折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERS========================华丽的分割线=========================fnd_user ---系统⽤户表po_vendors ---供应商信息表po_vendor_sites ---供应商地点信息表hr_organization_units ---组织及库存组织表per_people_f ---员⼯表wip_entities ---作业名信息表wip_discrete_jobs ---离散作业表wip_requirement_operations ---作业名物料需求发放表po_headers_all ---采购订单头表po_lines_all ---采购订单⾏表po_line_locations_all ---采购⾏地点表rcv_transactions ---接收交易表bom_bill_of_materials ---物料清单表bom_inventory_components ---物料清单构成表mtl_system_items ---物料主表mtl_onhand_quantities ---库存数据表mtl_item_locations ---项⽬货位表mtl_material_transactions ---出⼊库记录表mtl_supply ---供应表mtl_demand ---需求表----=====================-下⾯的是⽤于修改表单注册情况========-------select * from FND_FORM_VL where form_name='出货信息' order by last_update_date descupdate FND_FORM set form_name='OUTINVINFO' where form_id=58864select * from fnd_form where form_name='出货信息'commit;-------===========================-----------select item as 物料,subinventory as ⼦库存,locator as 货位,results_transaction_uom as 单位 from MTL_TXN_REQUEST_HEADERS_V select lot_number as 批次,LOT_EXPIRATION_DATE as 到期⽇,pimary_quantity as 数量 from MTL_TXN_REQUEST_LINES_V/*==================物料发送请求⾏视图==================================*/select * from MTL_TXN_REQUEST_LINES_Vselect * from MTL_TXN_REQUEST_HEADERS_V-----其他信息从OE上取---------organization_id = :_id ----------select * from MTL_ONHAND_LOCATOR_Vselect * from MTL_MATERIAL_TRANSACTIONS_TEMPselect * from MTL_SERIAL_NUMBERS_TEMPselect * from MTL_TRANSACTION_LOTS_TEMP---------------------------------------------------------通过PO, 找点收单号:===========================================================通过PO, 找点收单号:作者: moonsoft()发表于: 2006.05.08 16:20分类: 分销出处: /post/15182/86513---------------------------------------------------------------select rsh.receipt_numfrom po_headers_all poh,rcv_shipment_headers rsh,rcv_shipment_lines rsl,po_lines_all pol,po_line_locations_all pollwherepoh.segment1='20600021'andpoh.po_header_id=pol.po_header_idandpol.po_line_id=poll.po_line_idandpoll.line_location_id=rsl.po_line_location_idandrsh.SHIPMENT_HEADER_ID=rsl.shipment_header_id/*--------------------------//接收事务处理------------------------************/select * from RCV_TRANSACTIONS_Vselect * from RCV_TRANSACTIONS_INTERFACEselect * from MTL_TRANSACTION_LOTS_TEMPselect * from MTL_SERIAL_NUMBERS_TEMP ----------条码-----------select * from QA_RESULTS_Vselect * from ic_lots_mstselect * from mtl_serial_numbers ----------条码表-----------select * from wms_license_plate_numbersselect * from rcv_lots_supplyselect * from oe_lot_serial_numbers ----------销售订单批次条码---------------select * from rcv_transactions -----//接收事务处理----select * from sy_reas_cdsselect * from mtl_serial_numbers_all_vselect * from qa_plan_char_value_lookupsselect * from mtl_lot_numbersselect * from mtl_serial_numbers-------------序列号select * from wip_operations_all_vselect * from cs_counter_valuesselect * from wip_discrete_jobs_all_vselect * from cs_incidentsselect * from qa_ahl_mrselect * from cs_countersselect * from qa_csi_item_instancesselect * from mtl_system_items_kfvselect * from wms_lpn_contentsselect * from ic_item_mstselect * from ic_tran_pndselect * from ic_loct_invselect * from ic_loct_mstselect * from hr_employees------------⼈事⼈员select * from pjm_projects_all_vselect * from PA_TASKS_EXPEND_Vselect * from wip_osp_jobs_val_vselect * from mtl_kanban_cardsselect * from hr_locations_all --------⼈事组织档案-----select * from hr_locations_all_tl -------同上select * from mtl_serial_numbers_all_v ---------序列视图select * from hz_parties----------select * from po_pos_val_vselect * from rcv_transactions_interfaceselect * from PO_LINE_LOCATIONSselect * from PO_REQUISITION_LINESselect * from wip_discrete_jobs_all_vselect * from oke_k_headers_lov_vselect * from oke_k_lines_full_vselect * from oke_k_deliverables_vlselect * from OE_SOLD_TO_ORGS_V ------------select * from cst_cost_groups --------select * from rcv_shipment_headers ----------发运头select * from rcv_shipment_lines --------发运体select * from rcv_transactions_interfaceselect * from oe_order_lines_all -----------订单select * from oe_order_headers_all ---------订单select * from oe_transaction_types_all ------订单处理\交易类型select * from MTL_TRANSACTION_TYPES-------交易的类型--select * from oe_transaction_types_tl -------订单处理类型select * from rcv_transactions ------接收事务处理select * from rcv_supply -----------select * from oe_transaction_typesselect * from oe_po_enter_receipts_vselect * from mtl_customer_items_all_vselect * from mtl_lot_issues_val_v ------------select * from mtl_uom_conversions -----------select * from mtl_uom_class_conversions --------------select * from po_lines_supplier_items_vselect * from per_all_people_f ---------------select * from financials_system_parametersselect * from org_freight ------运输组织--------select * from mtl_supply -------------物料供给select * from org_organization_definitions --------------库存组织定义select * from rcv_sources_both_val_v ----------------select * from rcv_suppliers_val_v -----------select * from hr_locations_all ---------select * from hr_locations_all_tl ------------select * from mtl_item_revisions -----------select * from mtl_system_items_kfv ----正规ID编码,------select * from po_requisition_linesselect * from financials_system_parametersselect * from po_lookup_codes ----------------select * from po_requisition_headersselect * from rcv_shipment_lines---------select * from rcv_transactions------------select * from po_line_locationsselect * from hr_locations_all_tl -----------select * from po_releasesselect * from po_pos_all_vselect * from po_pos_val_vselect * from per_all_people_f ------------select * from rcv_transactions_interfaceselect * from mtl_serial_numbers ------------------SERIAL----------select * from mtl_transaction_lots_tempselect * from mtl_employees_view ----------select * from po_suppliers_val_v ---------------select * from mtl_employees_current_view -------------select * from mtl_item_status -------------------物料项状态基础表---------select * from org_organization_definitions ------------select * from mtl_secondary_inventories -----⼦库存组织---------select * from mtl_transaction_types ------------select * from mtl_txn_source_types -----------select * from mtl_system_items_vl ------------select * from mtl_system_items_kfv --------select * from mtl_category_sets_vl ---------select * from mtl_physical_inventories_v ----------select * from mtl_kanban_cardsselect * from mtl_item_sub_inventoriesselect * from fnd_folders -------select * from fnd_user --------系统⽤户select * from so_order_types_all ----------销售订单类型select * from oe_order_headers_all ---------select * from qa_customers_lov_v ---------select * from qa_sales_orders_lov_v-----------select * from PO_VENDORS -----采购供货⽅-----select * from po_shipments_all_vselect * from po_lines_val_vselect * from po_pos_val_vselect * from mtl_task_vselect * from pjm_projects_all_vselect * from qa_customers_lov_v ---select * from mtl_item_revisions ----select * from mtl_category_sets----select * from wip_operations_all_vselect * from wip_first_open_schedule_vselect * from wip_discrete_jobs_all_vselect * from wip_lines_val_vselect * from mtl_item_uoms_view -----select * from bom_resources_val_vselect * from bom_departments_val_vselect * from qa_plan_char_value_lookups ---------select * from qa_plans-------select * from qa_specs_vselect * from qa_specs_val_vselect * from po_lookup_codes -----select * from hr_employees_current_v --------select * from po_quality_codesselect * from mtl_transaction_reasons --库存相关接转信息----select * from mtl_uom_conversions_val_v ----select * from hr_locations_all --------select * from hr_locations_all_tl --------select * from hz_locations -------select * from hz_party_sites ---------select * from hz_cust_site_uses_all --------select * from hz_cust_acct_sites_all ---------select * from hz_cust_accounts -----------select * from oe_order_lines_all -----------select * from oe_drop_ship_sourcesselect * from rcv_trx_int_lots_vselect * from mtl_rma_serial_tempselect * from rcv_trx_int_serials_vselect * from po_distributionsselect * from pjm_projects_all_vselect * from po_distributionsselect * from hr_locations_all_tl-----------select * from hr_employees_current_v -------select * from po_lookup_codes -----------select * from pjm_projects_all_vselect * from pa_tasks_expend_vselect * from mtl_kanban_cardsselect * from qa_plans_val_v ---------------------------------------------------签证分类select t.meaning from fnd_lookup_values_vl t Where t.lookup_type='CUX_FC_QZYY' -- 任务IDSelect Distinct A.Task_Number,A.Task_Name From pa_tasks A---------------------------//发运------------------------------select * from wsh_new_deliveries_vselect * from mtl_txn_request_lines_vselect * from oe_order_headers_vselect * from wsh.wsh_delivery_details-------------------------//出货信息--------------------------select * from oe_lot_serial_numbers ----订单批次与序列号select * from ic_lots_mstselect * from mtl_serial_numbers---------序列号select * from rcv_transactions ---------接收处理select * from gml_recv_trans_mapselect * from ic_tran_pndselect * from ic_loct_invselect reason_code,reason_desc1 from sy_reas_cds order by 1select * from MTL_MATERIAL_TRANSACTIONS--是物料交易表,---------它存放着相关库存物料的每⼀笔交易,或库存更新的每⼀笔数据----物料处理,(库存)物料事物表select * from MTL_CONSUMPTION_TXN_TEMPselect * from hr_locations_all -------------收货地点档案----------------select * from hz_locations------交货地点select * from wms_lpn_contentsselect * from mtl_subinventories_val_v ------------⼦库----------------select * from mtl_object_genealogyselect * from mtl_lot_numbers-----------物料批号select * from mtl_lot_issues_val_v -----------物料批号发出select * from wms_license_plate_numbersselect * from cst_cost_groupsselect * from mtl_item_sub_val_vselect * from mtl_subinventories_trk_val_v----------select * from mtl_item_sub_trk_val_vselect * from mtl_item_sub_exp_val_vselect * from mtl_sub_exp_val_vselect * from mtl_so_rma_interfaceselect * from mtl_system_items-------库存、⼯程和采购物料的明细-物料信息--select * from bom_departmentsselect * from wip_lines_all_vselect * from wip_entitiesselect * from wip_discrete_jobs_all_vselect * from wsh_inv_delivery_details_v---------库存存货发放明细select * from mtl_txn_request_lines--------请求select * from mtl_material_transactions_tempselect * from mtl_transaction_types------物料处理类型select * from pjm_unit_numbers_lov_vselect * from mtl_sales_orders----------------销售订单select * from mtl_secondary_inventories ---------select * from mtl_lot_numbers----------select * from pjm_tasks_vselect * from pjm_projects_vselect * from pjm_project_parametersselect * from fnd_user --------------系统⽤户select * from mtl_txn_request_headers-------------头select * from mtl_txn_request_lines------------体select * from mtl_onhand_quantities_detail----物料的库存明细--------select * from fnd_folders------------select * from mtl_item_sub_inventoriesselect * from mtl_kanban_cards-------物料看板select * from mtl_physical_inventories_v------物理库存select * from mtl_category_sets_vl---物料类别select * from mtl_system_items_vlselect * from mtl_txn_source_typesselect * from mtl_transaction_types---处理类型select * from org_organization_definitions------库存组织 where orselect * from mtl_item_status-----物料状态select * from mtl_employees_current_view------员⼯select * from po_suppliers_val_v--------------采购供应商视图select * from mtl_employees_view-----------------员⼯select * from mtl_transaction_lots_tempselect * from pa_projects_expend_vselect * from pa_tasks_expend_vselect * from pa_organizations_expend_vselect * from mtl_onhand_quantities_detail---------物料现存量明细select * from mtl_lot_numbers----物料批号select * from mtl_transaction_reasons------------物料处理原因select * from mtl_item_uoms_view--------------物料单位mtl_units_of_measure select * from mtl_so_rma_interfaceselect * from mtl_system_items------------物料项select * from mtl_item_sub_ast_trk_val_vselect * from mtl_lot_issues_val_v-------------批次-select * from mtl_so_rma_interfaceselect * from mtl_sub_ast_trk_val_v ---------------⼦库select * from pa_expenditure_typesselect * from MTL_TXN_REQUEST_LINES_V--------------发送请求select * from MTL_SERIAL_NUMBERS_TEMPselect * from MTL_TRANSACTION_LOTS_TEMPselect * from MTL_MATERIAL_TRANSACTIONS_TEMPselect * from MTL_ITEM_LOCATTIONS---------------货位Select * from Po_Requisition_Headers_all------------请购单头表Select * from Po_Requisition_lines_all----------体表Select * from PO_HEADER_ALL---------采购订单头Select * from PO_LINES_ALL---采购订单体select * from wsh_pick_slip_vselect * from mtl_system_items_vl msi -- bug# 3306781select * from wsh_delivery_details wddselect * from mtl_txn_request_lines mtrlselect * from mtl_txn_request_headers mtrhselect * from wsh_delivery_assignments wdaselect * from wsh_new_deliveries wndselect * from oe_order_lines_all oolaselect * from oe_sets osselect * from hz_locations -------交货位置表select * from hr_locations_all-------收貨位置表Select flex_value_set_id From apps.fnd_flex_value_setsselect * from MTL_TXN_REQUEST_LINES_V --查找物料搬运单SELECTTRANSACTION_TYPE_NAME,TRANSACTION_TYPE_ID,TRANSACTION_ACTION_ID,TRANSACTION_SOURCE_TYPE_ID,LINE_ID,REQUEST_NUMBER,HEADER_ID,MOVE_ORDER_TYPE,MOVE_ORDER_TYPE_NAME,LINE_NUMBER,ORGANIZATION_ID,INVENTORY_ITEM_ID,REVISION,FROM_SUBINVENTORY_CODE,FROM_LOCATOR_ID,TO_SUBINVENTORY_CODE,FROM_SUB_LOCATOR_TYPE,TO_LOCATOR_ID,TO_ACCOUNT_ID,LOT_NUMBER,SERIAL_NUMBER_START,SERIAL_NUMBER_END,UNIT_NUMBER,UOM_CODE,QUANTITY,REQUIRED_QUANTITY,QUANTITY_DELIVERED,QUANTITY_DETAILED,DATE_REQUIRED,REASON_ID,REFERENCE,REFERENCE_ID,REFERENCE_TYPE_CODE,PROJECT_ID,TASK_ID,TRANSACTION_HEADER_ID,LINE_STATUS,STATUS_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,CREATED_BY,REQUEST_ID,CREATION_DATE,PROGRAM_APPLICATION_ID,PROGRAM_ID,PROGRAM_UPDATE_DATE,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,ATTRIBUTE_CATEGORY,TO_SUB_LOCATOR_TYPE,FROM_SUB_ASSET,FROM_SUB_QUANTITY_TRACKED,FROM_SUB_MATERIAL_ACCOUNT, TXN_SOURCE_ID,TXN_SOURCE_LINE_ID,TXN_SOURCE_LINE_DETAIL_ID,PRIMARY_QUANTITY,TO_ORGANIZATION_ID,PICK_STRATEGY_ID,PUT_AWAY_STRATEGY_ID,SHIP_TO_LOCATION_IDFROM MTL_TXN_REQUEST_LINES_VWHERE organization_id = '117' AND -1=-1and ( mtl_txn_request_lines_v.move_order_type != 6AND mtl_txn_request_lines_v.request_number between '4009' AND '4009'AND mtl_txn_request_lines_v.line_status in (3,7,9) ) and (REQUEST_NUMBER='4009')order by REQUEST_NUMBER,MOVE_ORDER_TYPE_NAME,LINE_NUMBER------哪个⽤户锁定了哪个表的SQL----SELECT c.owner,c.object_name,c.object_type,er_name locking_fnd_user_name,fl.start_time locking_fnd_user_login_time,vs.module,vs.machine,vs.osuser,vlocked.oracle_username,vs.SID,vp.pid,vp.spid AS os_process,vs.serial#,vs.status,vs.saddr,vs.audsid,vs.processFROM fnd_logins fl,fnd_user fu,v$locked_object vlocked,v$process vp,v$session vs,dba_objects cWHERE vs.SID = vlocked.session_idAND vlocked.object_id = c.object_idAND vs.paddr = vp.addrAND vp.spid = fl.process_spid(+)AND vp.pid = fl.pid(+)AND er_id = er_id(+)--AND c.object_name LIKE '%' || UPPER('&tab_name_leaveblank4all') || '%' AND NVL(vs.status,'XX') != 'KILLED';--------------select * from oe_ra_cust_trx_hdr_vselect * from ar_payment_schedules_allselect * from oe_ra_customers_v-----------客户名称select * from OE_PO_REQUISITION_LINES_V------------==================selectfyhzt.delivery_detail_id,fyhzt.source_code as 源单类,fyhzt.source_line_id as 源单⾏号,fyhzt.source_header_id as 源单头号,fyhzt.header_number as 单据号,fyhzt.line_number as ⾏号,fyhzt.ship_method_code as 发运⽅式,fyhzt.inventory_item_id as 物料ID,fyhzt.requested_quantity as 请求数量,fyhzt.shipped_quantity_uom as 发运单位,fyhzt.shipped_quantity as 已发运,fyhzt.requested_quantity_uom as 请求单位,fyhzt.ship_set_id,fyhzt.line_number as 批次号,fyhzt.serial_number as 序列号从,fyhzt.pick_status as 挑库状态,fyhzt.pick_meaning as 挑库状态名称,fyhzt.delivery_id,fyhzt.delivery_name,fyhzt.delivery_status,fyhzt.delivery_status_meaning as 发运状态,anization_id as 公司,fyhzt.initial_pickup_location_id as 地点ID,fyhzt.initial_pickup_location as 地点,fyhzt.ultimate_dropoff_location_id,fyhzt.ultimate_dropoff_location,fyhzt.date_shipped,fyhzt.date_received,fyhzt.to_serial_number as 序列号⽌from WSH_DELIVERY_LINE_STATUS_V fyhzt-------发运⾏状态-------------------------select * from OE_ORDER_HEADERS_V-------付款⽅式select distinct , t.description from ra_terms t order by --------收单地点select * from hz_cust_site_uses_all-------业务员select * from JTF_RS_DEFRESOURCES_VL-----------公司名称select * from HR_ALL_ORGANIZATION_UNITS where organization_id=103。

oracle系统表格大全整理

oracle系统表格大全整理

oracle系统表查询 2005-4-29 网络数据字典dict总是属于Oracle用户sys的。

******************************************************************************* *******************************************1、用户:select username from dba_users;创建用户CREATE USER jzmis PROFILE DEFAULT IDENTIFIED BY jzmisDEFAULTTABLESPACE USERS TEMPORARYTABLESPACE TEMP ACCOUNT UNLOCK;GRANT DBA TO jzmis WITH ADMIN OPTION;commit;改口令alter user spgroup identified by spgtest;2、表空间:select * from dba_data_files;select * from dba_tablespaces;//表空间select tablespace_name,sum(bytes), sum(blocks)from dba_free_space group by tablespace_name;//空闲表空间select * from dba_data_fileswhere tablespace_name='RBS';//表空间对应的数据文件select * from dba_segmentswhere tablespace_name='INDEXS';删除表空间drop TABLESPACE XNMIS INCLUDING CONTENTS;创建表空间CREATE TABLESPACE "XNMIS"LOGGINGDATAFILE ‘E:\oracle\product\10.2.0\oradata\jzmis\xnmis.dbf’ SIZE 2048M EXTENTMANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTOAUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITEDCREATE TABLESPACE "XNMIS"LOGGINGDATAFILE 'E:\oracle\product\10.2.0\oradata\jzmis\XNMIS.dbf' SIZE 2048M REUSE AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;'E:\oracle\admin\cmid\JTAIS.ora' (path)"CTAIS" (表空间名)3、数据库对象:select * from dba_objects;CLUSTER、DATABASE LINK、FUNCTION、INDEX、LIBRARY、PACKAGE、PACKAGE BODY、PROCEDURE、SEQUENCE、SYNONYM、TABLE、TRIGGER、TYPE、UNDEFINED、VIEW。

(word完整版)Oracle ebs 常用数据表

(word完整版)Oracle ebs 常用数据表

Oracle EBS常用数据表EBS常用数据表:(未整理)INV库存organization 两个含义:1。

经营单位,A/B/C分公司,A下面有A1,A2等工厂,主题目标是为了独立核算此组织ORG,ORG_ID;2. 库存组织,例如制造商的仓库,例如A1,A2等工厂Organization_id;HR_ORGANIZATION_UNITS -Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS —库存组织参数(没有用ID,直接用name)MTL_SYSTEM_ITEMS_b —物料信息(同上,应用了库存组织name)MTL_SECONDARY_INVENTORIES —子库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本;ACTUAL_COST是通过成本算法计算出来的实际成本,主计量单位现有量汇总历史记录(正负合计)Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表,组织/子库存/货位/物品 summary可能按照挑库先进先出统计,如果设置了"不允许负库存”,这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收-退货/组织间转移/正常状态都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入“待质检"货位2。

接受/拒绝3。

库存/退回有三个不同的状态!例如:接收100个,80个接受入库,20个退回,那么有80个接受事务/20个退回事物select TRANSACTION_TYPE,DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段:A1。

Oracle常用表

Oracle常用表

Oracle常用表ORACLE的数据字典是数据库的重要组成部分之一,它随着数据库的产生而产生, 随着数据库的变化而变化, 体现为sys用户下的一些表和视图。

数据字典名称是大写的英文字符。

数据字典里存有用户信息、用户的权限信息、所有数据对象信息、表的约束条件、统计分析数据库的视图等。

我们不能手工修改数据字典里的信息。

很多时候,一般的ORACLE用户不知道如何有效地利用它。

dictionary全部数据字典表的名称和解释,它有一个同义词dictdict_column全部数据字典表里字段名称和解释如果我们想查询跟索引有关的数据字典时,可以用下面这条SQL语句:SQL>select * from dictionary where instr(comments,'index')>0;如果我们想知道user_indexes表各字段名称的详细含义,可以用下面这条SQL语句:SQL>select column_name,comments from dict_columns where table_name='USER_INDEXES';依此类推,就可以轻松知道数据字典的详细名称和解释,不用查看ORACLE的其它文档资料了。

下面按类别列出一些ORACLE用户常用数据字典的查询使用方法。

一、用户查看当前用户的缺省表空间SQL>select username,default_tablespace from user_users;查看当前用户的角色SQL>select * from user_role_privs;查看当前用户的系统权限和表级权限SQL>select * from user_sys_privs;SQL>select * from user_tab_privs;二、表查看用户下所有的表SQL>select * from user_tables;查看名称包含log字符的表SQL>select object_name,object_id from user_objects where instr(object_name,'LOG')>0;查看某表的创建时间SQL>select object_name,created from user_objects where object_name=upper('&table_name');查看某表的大小where SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segments segment_name=upper('&table_name');查看放在ORACLE的内存区里的表SQL>select table_name,cache from user_tables where instr(cache,'Y')>0;三、索引查看索引个数和类别SQL>select index_name,index_type,table_name from user_indexes order by table_name;查看索引被索引的字段SQL>select * from user_ind_columns where index_name=upper('&index_name');查看索引的大小SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segmentswhere segment_name=upper('&index_name');四、序列号查看序列号,last_number是当前值SQL>select * from user_sequences;五、视图查看视图的名称SQL>select view_name from user_views;查看创建视图的select语句SQL>select view_name,text_length from user_views;SQL>set long 2000;说明:可以根据视图的text_length值设定set long 的大小SQL>select text from user_views where view_name=upper('&view_name');六、同义词查看同义词的名称SQL>select * from user_synonyms;七、约束条件查看某表的约束条件SQL>select constraint_name, constraint_type,search_condition, r_constraint_name from user_constraints where table_name = upper('&table_name');SQL>select c.constraint_name,c.constraint_type,cc.column_namefrom user_constraints c,user_cons_columns ccwhere c.owner = upper('&table_owner') and c.table_name = upper('&table_name')and c.owner = cc.owner and c.constraint_name = cc.constraint_nameorder by cc.position;八、存储函数和过程查看函数和过程的状态SQL>select object_name,status from user_objects where object_type='FUNCTION';SQL>select object_name,status from user_objects where object_type='PROCEDURE';查看函数和过程的源代码SQL>select text from all_source where owner=user and name=upper('&plsql_name');九、触发器查看触发器set long 50000;set heading off;set pagesize 2000;select'create or replace trigger "' ||trigger_name || '"' || chr(10)||decode( substr( trigger_type, 1, 1 ),'A', 'AFTER', 'B', 'BEFORE', 'I', 'INSTEAD OF' ) ||chr(10) ||triggering_event || chr(10) ||'ON "' || table_owner || '"."' ||table_name || '"' || chr(10) ||decode( instr( trigger_type, 'EACH ROW' ), 0, null,'FOR EACH ROW' ) || chr(10) ,trigger_bodyfrom user_triggers;。

oracle系统表详解(中文)

oracle系统表详解(中文)
线程信息
v$datafile_header
数据文件头所记载的信息
v$archived_log
归档日志信息
v$archive_dest
归档日志的设置信息
v$logmnr_contents
归档日志分析的DML DDL结果信息
v$logmnr_dictionary
日志分析的字典文件信息
v$logmnr_logs
DATA_OBJECT_ID
NUMBER
Dictionary object number of the segment that contains the object
Note:OBJECT_IDandDATA_OBJECT_IDdisplay data dictionary metadata. Do not confuse these numbers with the unique 16-byte object identifier (object ID) that the Oracle Database assigns to row objects in object tables in the system.
OBJECT_TYPE
VARCHAR2(19)
Type of the object (such asTABLE,INDEX)
CREATED
DATE
NOT NULL
Timestamp for the creation of the object
LAST_DDL_TIME
DATE
NOT NULL
Timestamp for the lastmodification of the object resulting from a DDL statement (including grants and revokes)

Oracle系统表大全

Oracle系统表大全

[返回上一页]↓该Blog续文信息↓1.查询oracle表空间的使用情形select b.file_id 文件ID,b.tablespace_name 表空间,b.file_name 物理文件名,b.bytes 总字节数,(b.bytes-sum(nvl(a.bytes,0))) 已使用,sum(nvl(a.bytes,0)) 剩余,sum(nvl(a.bytes,0))/(b.bytes)*100 剩余百分比from dba_free_space a,dba_data_files bwhere a.file_id=b.file_idgroup by b.tablespace_name,b.file_name,b.file_id,b.bytes order by b.tablespace_name2.查询oracle系统用户的默认表空间和临时表空间select default_tablespace,temporary_tablespace from dba_users3.查询单张表的使用情形select segment_name,bytes from dba_segments where segment_name = 'RE_STDEVT_F ACT_DAY' and owner = USERRE_STDEVT_FACT_DAY是您要查询的表名称4.查询所有用户表使用大小的前三十名select * from (select segment_name,bytes from dba_segments where owner = USER or der by bytes desc ) where rownum <= 305.查询当前用户默认表空间的使用情形select tablespacename,sum(totalContent),sum(usecontent),sum(sparecontent),avg(spareper cent)from(SELECT b.file_id as id,b.tablespace_name as tablespacename,b.bytes as totalContent,(b. bytes-sum(nvl(a.bytes,0))) as usecontent,sum(nvl(a.bytes,0)) as sparecontent,sum(nvl(a.byt es,0))/(b.bytes)*100as sparepercentFROM dba_free_space a,dba_data_files bWHERE a.file_id=b.file_id and b.tablespace_name = (select default_tablespace from dba_ users where username = user)group by b.tablespace_name,b.file_name,b.file_id,b.bytes)GROUP BY tablespacename6.查询用户表空间的表select*from user_tablesPosted by puppy at 2018-11-06 11:09:07select * from (select bytes,segment_name,segment_type,owner from dba_segmentswhere tablespace_name = 'SYSTEM'order by bytes desc) where rownum < 10Posted by puppy at 2018-11-07 19:44:33 SQL> select tablespace_name,(bytes/1024/1024) M from dba_data_files;TABLESPACE_NAME M ------------------------------------------------------------ ----------USERS 5 SYSAUX310 UNDOTBS130 SYSTEM490 EXAMPLE100Posted by puppy at 2018-11-07 19:45:16 system表空间增大是正常的,但急剧增大是不合理的。

ORACLE常见用系统视图及系统表大全,可以帮助你管理数据库

ORACLE常见用系统视图及系统表大全,可以帮助你管理数据库

ORACLE常见用系统视图及系统表大全,可以帮助你管理数据库总结ORACLE系统视图及表大全:dba_开头.....dba_users 数据库用户信息dba_segments 表段信息dba_extents 数据区信息dba_objects 数据库对象信息dba_tablespaces 数据库表空间信息dba_data_files 数据文件设置信息dba_temp_files 临时数据文件信息dba_rollback_segs 回滚段信息dba_ts_quotas 用户表空间配额信息dba_free_space数据库空闲空间信息dba_profiles 数据库用户资源限制信息dba_sys_privs 用户的系统权限信息dba_tab_privs用户具有的对象权限信息dba_col_privs用户具有的列对象权限信息dba_role_privs用户具有的角色信息dba_audit_trail审计跟踪记录信息dba_stmt_audit_opts审计设置信息dba_audit_object 对象审计结果信息dba_audit_session会话审计结果信息dba_indexes用户模式的索引信息user_开头user_objects 用户对象信息user_source 数据库用户的所有资源对象信息user_segments 用户的表段信息user_tables 用户的表对象信息user_tab_columns 用户的表列信息user_constraints 用户的对象约束信息user_sys_privs 当前用户的系统权限信息user_tab_privs 当前用户的对象权限信息user_col_privs 当前用户的表列权限信息user_role_privs 当前用户的角色权限信息user_indexes 用户的索引信息user_ind_columns用户的索引对应的表列信息user_cons_columns 用户的约束对应的表列信息user_clusters 用户的所有簇信息user_clu_columns 用户的簇所包含的内容信息user_cluster_hash_expressions 散列簇的信息v$开头v$database 数据库信息v$datafile 数据文件信息v$controlfile控制文件信息v$logfile 重做日志信息v$instance 数据库实例信息v$log 日志组信息v$loghist 日志历史信息v$sga 数据库SGA信息v$parameter 初始化参数信息v$process 数据库服务器进程信息v$bgprocess 数据库后台进程信息v$controlfile_record_section 控制文件记载的各部分信息v$thread 线程信息v$datafile_header 数据文件头所记载的信息v$archived_log归档日志信息v$archive_dest 归档日志的设置信息v$logmnr_contents 归档日志分析的DML DDL结果信息v$logmnr_dictionary 日志分析的字典文件信息v$logmnr_logs 日志分析的日志列表信息v$tablespace 表空间信息v$tempfile 临时文件信息v$filestat 数据文件的I/O统计信息v$undostat Undo数据信息v$rollname 在线回滚段信息v$session 会话信息v$transaction 事务信息v$rollstat 回滚段统计信息v$pwfile_users 特权用户信息v$sqlarea 当前查询过的sql语句访问过的资源及相关的信息v$sql 与v$sqlarea基本相同的相关信息v$sysstat 数据库系统状态信息all_开头all_users 数据库所有用户的信息all_objects 数据库所有的对象的信息all_def_audit_opts 所有默认的审计设置信息all_tables 所有的表对象信息all_indexes所有的数据库对象索引的信息session_开头session_roles 会话的角色信息session_privs 会话的权限信息index_开头index_stats 索引的设置和存储信息伪表dual 系统伪列表信息Oracle常用动态视图介绍:2.1.1 v$lock给出了锁的信息,如type字段, user type locks有3种:TM,TX,UL,system type locks有多种,常见的有:MR,RT,XR,TS 等。

Oracle常用试图列表

Oracle常用试图列表

oracle数据字典总结下面按类别列出一些ORACLE用户常用数据字典的查询使用方法。

一、用户查看当前用户的缺省表空间SQL>SELECT username,default_tablespace FROM user_users;查看当前用户的角色SQL>SELECT * FROM user_role_privs;查看当前用户的系统权限和表级权限SQL>SELECT * FROMuser_sys_privs;SQL>SELECT * FROM user_tab_privs;二、表查看用户下所有的表SQL>SELECT* FROM user_tables;查看名称包含log字符的表SQL>SELECT object_name,object_id FROM user_objects WHERE INSTR(object_name,'LOG')>0;查看某表的创建时间SQL>SELECT object_name,created FROMuser_objects WHERE object_name=UPPER('&table_name');查看某表的大小SQL>SELECT SUM(bytes)/(1024*1024)AS size(M)FROM user_segments WHERE segment_name=UPPER('&table_name');查看放在ORACLE的内存区里的表SQL>SELECT table_name,cache FROM user_tables WHERE INSTR(cache,'Y')>0;三、索引查看索引个数和类别SQL>SELECT index_name,index_type,table_name FROM user_indexes ORDER BY table_name;查看索引被索引的字段SQL>SELECT * FROM user_ind_columns WHERE index_name=UPPER('&index_name');查看索引的大小SQL>SELECT SUM(bytes)/(1024*1024)AS size(M)FROM user_segments WHERE segment_name=UPPER('&index_name');四、序列号查看序列号,last_number是当前值SQL>SELECT * FROMuser_sequences;五、视图查看视图的名称SQL>SELECT view_name FROM user_views;查看创建视图的select语句SQL>SELECT view_name,text_length FROM user_views;SQL>SET long 2000;//说明:可以根据视图的text_length值设定set long 的大小SQL>SELECT text FROM user_views WHERE view_name=UPPER('&view_name');六、同义词查看同义词的名称SQL>SELECT * FROM user_synonyms;七、约束条件查看某表的约束条件SQL>SELECT constraint_name,constraint_type,search_condition,r_constraint_name2 FROM user_constraints WHERE table_name = UPPER('&table_name');//注意,表名一定是大写才行SQL>SELECT c.constraint_name,c.constraint_type,cc.column_name2 FROM user_constraints c,user_cons_columns cc3 WHERE c.owner = upper('&table_owner')4 AND c.table_name = UPPER('&table_name')5 AND c.owner = cc.owner and c.constraint_name = cc.constraint_name6 ORDER BY cc.position;八、存储函数和过程查看函数和过程的状态SQL>SELECT object_name,status FROMuser_objects WHERE object_type='FUNCTION';SQL>SELECT object_name,status FROM user_objects WHERE object_type='PROCEDURE';查看函数和过程的源代码SQL>SELECT text from all_source WHERE owner=user AND name=UPPER('&plsql_name');九、触发器查看触发器SET long 50000;SET heading off;SET pagesize 2000;SELECT'create or replace trigger ' ||trigger_name || '' || chr(10)||DECODE( SUBSTR( trigger_type, 1, 1 ),'A', 'AFTER', 'B', 'BEFORE', 'I', 'INSTEAD OF' ) ||chr(10) ||triggering_event || chr(10) ||'ON ' || table_owner || '.' ||table_name || '' || chr(10) ||DECODE( instr( trigger_type, 'EACH ROW' ), 0, null,'FOR EACH ROW' ) || chr(10) ,trigger_bodyFROM user_triggers;Oracle常用数据字典表Oracle常用数据字典表查看当前用户的缺省表空间SQL>select username,default_tablespace from user_users;查看当前用户的角色SQL>select * from user_role_privs;查看当前用户的系统权限和表级权限SQL>select * from user_sys_privs;SQL>select * from user_tab_privs;查看用户下所有的表SQL>select * from user_tables;查看用户下所有的表的列属性SQL>select * from USER_TAB_COLUMNS where table_name=:table_Name;显示用户信息(所属表空间)select default_tablespace,temporary_tablespacefrom dba_users where username='GAME';1、用户查看当前用户的缺省表空间SQL>select username,default_tablespace from user_users;查看当前用户的角色SQL>select * from user_role_privs;查看当前用户的系统权限和表级权限SQL>select * from user_sys_privs;SQL>select * from user_tab_privs;显示当前会话所具有的权限SQL>select * from session_privs;显示指定用户所具有的系统权限SQL>select * from dba_sys_privs where grantee='GAME';显示特权用户select * from v$pwfile_users;显示用户信息(所属表空间)select default_tablespace,temporary_tablespacefrom dba_users where username='GAME';显示用户的PROFILEselect profile from dba_users where username='GAME';2、表查看用户下所有的表SQL>select * from user_tables;查看名称包含log字符的表SQL>select object_name,object_id from user_objectswhere instr(object_name,'LOG')>0;查看某表的创建时间SQL>select object_name,created from user_objects where object_name=upper('&table_name');查看某表的大小SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segmentswhere segment_name=upper('&table_name');查看放在Oracle的内存区里的表SQL>select table_name,cache from user_tables where instr(cache,'Y')>0;3、索引查看索引个数和类别SQL>select index_name,index_type,table_name from user_indexes order by table_name;查看索引被索引的字段SQL>select * from user_ind_columns where index_name=upper('&index_name');查看索引的大小SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segmentswhere segment_name=upper('&index_name');4、序列号查看序列号,last_number是当前值SQL>select * from user_sequences;5、视图查看视图的名称SQL>select view_name from user_views;查看创建视图的select语句SQL>set view_name,text_length from user_views;SQL>set long 2000; 说明:可以根据视图的text_length值设定set long 的大小SQL>select text from user_views where view_name=upper('&view_name');6、同义词查看同义词的名称SQL>select * from user_synonyms;7、约束条件查看某表的约束条件SQL>select constraint_name, constraint_type,search_condition, r_constraint_namefrom user_constraints where table_name = upper('&table_name');SQL>select c.constraint_name,c.constraint_type,cc.column_name from user_constraints c,user_cons_columns ccwhere c.owner = upper('&table_owner') and c.table_name = upper('&table_name')and c.owner = cc.owner and c.constraint_name = cc.constraint_nameorder by cc.position;8、存储函数和过程查看函数和过程的状态SQL>select object_name,status from user_objects where object_type='FUNCTION';SQL>select object_name,status from user_objects where object_type='PROCEDURE';查看函数和过程的源代码SQL>select text from all_source where owner=user and name=upper('&plsql_name');oracle常用数据字典说明和含义解释,可作为手册或者工具书使用!以下表格中收集了Oracle数据字典中几乎所有的视图或别名,至于每个视图或别名的字段请用‘Describe’语句来查询。

oracle系统表详解

oracle系统表详解
回滚段信息
dba_ts_quotas
用户表空间配额信息
dba_free_space
数据库空闲空间信息
dba_profiles
数据库用户资源限制信息
dba_sys_privs
用户的系统权限信息
dba_tab_privs
用户具有的对象权限信息
dba_col_privs
用户具有的列对象权限信息
dba_role_privs
日志分析的日志列表信息
v$tablespace
表空间信息
v$tempfile
临时文件信息
v$filestat
数据文件的I/O统计信息
v$undostat
Undo数据信息
v$rollname
在线回滚段信息
v$session
会话信息
v$transaction
事务信息
v$rollstat
回滚段统计信息
v$pwfile_users
all_tables
所有的表对象信息
all_indexes
所有的数据库对象索引的信息
session_开头
session_roles
会话的角色信息
session_privs
会话的权限信息
index_开头
index_stats
索引的设置和存储信息
伪表
dual
系统伪列表信息
dba_users
Column
Datatype
EXPIRED(GRACE) & LOCKED
LOCK_DATE
DATE
Date the account was locked if account statuDATE
Date of expiration of the account

oracle常用表

oracle常用表

Oracle常用系统信息表系统表描述ALL_ARGUMENTSArguments in object accessible to the user用户可访问的对象参数ALL_CATALOGAll tables, views, synonyms, sequences accessible to the user 用户可访问的所有表、视图、同义词、序列ALL_COL_COMMENTSComments on columns of accessible tables and views可访问的表和视图的列的注释ALL_CONSTRAINTSConstraint definitions on accessible tables可访问的表的约束定义ALL_CONS_COLUMNSInformation about accessible columns in constraint definitions 与约束定义有关的可访问列的信息ALL_DB_LINKSDatabase links accessible to the user用户可访问的数据库链接ALL_ERRORSCurrent errors on stored objects that user is allowed to create 允许用户创建的存储对象的当前错误信息ALL_INDEXESDescriptions of indexes on tables accessible to the user用户可访问的表上创建的索引描述ALL_IND_COLUMNSCOLUMNs comprising INDEXes on accessible TABLES可访问的表上的索引的列ALL_LOBSDescription of LOBs contained in tables accessible to the user 用户可访问的表包含的大型数据对象的描述ALL_OBJECTSObjects accessible to the user用户可访问的对象ALL_OBJECT_TABLESDescription of all object tables accessible to the user用户可访问的对象的描述ALL_SEQUENCESDescription of SEQUENCEs accessible to the user用户可访问的序列的描述ALL_SNAPSHOTSSnapshots the user can access用户可访问的快照ALL_SOURCECurrent source on stored objects that user is allowed to create 允许用户创建的当前存储对象的原始资料ALL_SYNONYMSAll synonyms accessible to the user用户可访问的所有同义词ALL_TABLESDescription of relational tables accessible to the user用户可访问的所有关系表的描述ALL_TAB_COLUMNSColumns of user's tables, views and clusters与用户有关的表、视图和簇的列ALL_TAB_COL_STATISTICSColumns of user's tables, views and clusters与用户有关的表、视图和簇的列的统计信息ALL_TAB_COMMENTSComments on tables and views accessible to the user用户可访问的表和视图的注释ALL_TRIGGERSTriggers accessible to the current user当前用户可访问的触发器ALL_TRIGGER_COLSColumn usage in user's triggers or in triggers on user's tables 用户的触发器或用户表上的触发器的列的用途ALL_TYPESDescription of types accessible to the user用户可访问的类型描述ALL_UPDATABLE_COLUMNSDescription of all updatable columns所有可更新列的描述ALL_USERSInformation about all users of the database与数据库相关的所有用户信息ALL_VIEWSDescription of views accessible to the user用户可访问的视图的描述DATABASE_COMPATIBLE_LEVELDatabase compatible parameter set via init.ora通过init.ora设置的数据库兼容参数DBA_DB_LINKSAll database links in the database数据库中所有的数据库链接DBA_ERRORSCurrent errors on all stored objects in the database 数据库中所有对象当前的错误信息DBA_OBJECTSAll objects in the database数据库中所有的对象DBA_ROLESAll Roles which exist in the database数据库中存在的所有角色DBA_ROLE_PRIVSRoles granted to users and roles授予用户和角色权限的角色DBA_SOURCESource of all stored objects in the database数据库中所有的存储对象的原始信息DBA_TABLESPACESDescription of all tablespaces所有表空间的描述DBA_TAB_PRIVSAll grants on objects in the database数据库中所有对象的授权DBA_TRIGGERSAll triggers in the database数据库中所有的触发器DBA_TS_QUOTASTablespace quotas for all users所有用户的表空间限额DBA_USERSInformation about all users of the database数据库中所有用户的相关信息DBA_VIEWSDescription of all views in the database数据库中所有视图的描述DICTIONARYDescription of data dictionary tables and views数据字典的表和视图的描述DICT_COLUMNSDescription of columns in data dictionary tables and views 数据字典的表和视图的列的描述GLOBAL_NAMEGlobal database name全局数据库名NLS_DATABASE_PARAMETERSPermanent NLS parameters of the database数据库中永久国家语言参数NLS_INSTANCE_PARAMETERSNLS parameters of the instance实例的国家语言参数NLS_SESSION_PARAMETERSNLS parameters of the user session会话的国家语言参数PRODUCT_COMPONENT_VERSIONVersion and status information for component products产品的版本和状态信息ROLE_TAB_PRIVSTable privileges granted to roles授权给角色的表权限SESSION_PRIVSPrivileges which the user currently has set用户当前被设定的权限SESSION_ROLESRoles which the user currently has enabled用户当前有效的角色SYSTEM_PRIVILEGE_MAPDescription table for privilege type codes. Maps privilege type numbers to type names系统权限类型编码表描述。

  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。

数据字典dict总是属于Oracle用户sys的。

1、用户:selectusernamefromdba_users;改口令alteruserspgroupidentifiedbyspgtest;2、表空间:select*fromdba_data_files;select*fromdba_tablespaces;//表空间selecttablespace_name,sum(bytes),sum(blocks)fromdba_free_spacegroupbytablespace_name;//空闲表空间select*fromdba_data_fileswheretablespace_name='RBS';//表空间对应的数据文件select*fromdba_segmentswheretablespace_name='INDEXS';3、数据库对象:select*fromdba_objects;CLUSTER、DATABASELINK、FUNCTION、INDEX、LIBRARY、PACKAGE、PACKA GEBODY、PROCEDURE、SEQUENCE、SYNONYM、TABLE、TRIGGER、TYPE、UNDEFINED、VIEW。

4、表:select*fromdba_tables;analyzemy_tablecomputestatistics;->dba_tables后6列selectextent_id,bytesfromdba_extentswheresegment_name='CUSTOMERS'andsegment_type='TABLE'orderbyextent_id;//表使用的extent的信息。

segment_type='ROLLBACK'查看回滚段的空间分配信息列信息:selectdistincttable_namefromuser_tab_columnswherecolumn_name='SO_TYPE_ID';5、索引:select*fromdba_indexes;//索引,包括主键索引select*fromdba_ind_columns;//索引列selecti.index_name,i.uniqueness,c.column_namefromuser_indexesi,user_ind_columnscwherei.index_name=c.index_nameandi.table_name='ACC_NBR';//联接使用6、序列:select*fromdba_sequences;7、视图:select*fromdba_views;select*fromall_views;text可用于查询视图生成的脚本8、聚簇:select*fromdba_clusters;9、快照:select*fromdba_snapshots;快照、分区应存在相应的表空间。

10、同义词:select*fromdba_synonymswheretable_owner='SPGROUP';//ifownerisPUBLIC,thenthesynonymsisapublicsynonym.ifownerisoneofusers,thenthesynonymsisaprivatesynonym.11、数据库链:select*fromdba_db_links;在spbase下建数据库链createdatabaselinkdbl_spnewconnecttospnewidentifiedbyspnewusing'jhhx';insertintoacc_nbr@dbl_spnewselect*fromacc_nbrwherenxx_nbr='237'andline_nbr='8888';12、触发器:select*fromdba_trigers;存储过程,函数从dba_objects查找。

其文本:selecttextfromuser_sourcewherename='BOOK_SP_EXAMPLE';建立出错:select*fromuser_errors;oracle总是将存储过程,函数等软件放在SYSTEM表空间。

13、约束:(1)约束是和表关联的,可在createtable或altertabletable_nameadd/drop/modify 来建立、修改、删除约束。

可以临时禁止约束,如:altertablebook_exampledisableconstraintbook_example_1;altertablebook_exampleenableconstraintbook_example_1;(2)主键和外键被称为表约束,而notnull和unique之类的约束被称为列约束。

通常将主键和外键作为单独的命名约束放在字段列表下面,而列约束可放在列定义的同一行,这样更具有可读性。

(3)列约束可从表定义看出,即describe;表约束即主键和外键,可从dba_constraints 和dba_cons_columns查。

select*fromuser_constraintswheretable_name='BOOK_EXAMPLE';selectowner,CONSTRAINT_NAME,TABLE_NAMEfromuser_constraintswhereconstraint_type='R'orderbytable_name;(4)定义约束可以无名(系统自动生成约束名)和自己定义约束名(特别是主键、外键)如:createtablebook_example(identifiernumbernotnull);createtablebook_example(identifiernumberconstranitbook_example_1notnull);14、回滚段:在所有的修改结果存入磁盘前,回滚段中保持恢复该事务所需的全部信息,必须以数据库发生的事务来相应确定其大小(DML语句才可回滚,create,drop,truncate等DDL不能回滚)。

回滚段数量=并发事务/4,但不能超过50;使每个回滚段大小足够处理一个完整的事务;createrollbacksegmentr05tablespacerbs;createrollbacksegmentrbs_cvttablespacerbsstorage(initial1Mnext500k);使回滚段在线alterrollbacksegmentr04online;用dba_extents,v$rollback_segs监测回滚段的大小和动态增长。

回滚段的区间信息select*fromdba_extentswheresegment_type='ROLLBACK'andsegment_name='RB1';回滚段的段信息,其中bytes显示目前回滚段的字节数select*fromdba_segmentswheresegment_type='ROLLBACK'andsegment_name='RB1';为事物指定回归段settransactionuserollbacksegmentrbs_cvt针对bytes可以使用回滚段回缩。

alterrollbacksegmentrbs_cvtshrink;selectbytes,extents,max_extentsfromdba_segmentswheresegment_type='ROLLBACK'andsegment_name='RBS_CVT';回滚段的当前状态信息:select*fromdba_rollback_segswheresegment_name='RB1';比多回滚段状态status,回滚段所属实例instance_num查优化值optimal,s.optsizefromv$rollnamen,v$rollstatsn=n;回滚段中的数据settransactionuserollbacksegmentrb1;/*回滚段名*/,s.writesfromv$rollnamen,v$rollstatsn=n;当事务处理完毕,再次查询$rollstat,比较writes(回滚段条目字节数)差值,可确定事务的大小。

查询回滚段中的事务columnrrheading'RBSegment'formata18columnusheading'Username'formata15columnosheading'OsUser'formata10columnteheading'Terminal'formata10rr,nvl(ername,'notransaction')us,s.osuseros,s.terminaltefromv$lockl,v$sessions,v$rollnamerwherel.sid=s.sid(+)andtrunc(l.id1/65536)=Nandl.type='TX'andl.lmode=6;15、作业查询作业信息selectjob,broken,next_date,interval,whatfromuser_jobs;selectjob,broken,next_date,interval,whatfromdba_jobs;查询正在运行的作业select*fromdba_jobs_running;使用包execdbms_job.submit(:v_num,'a;',sysdate,'sysdate+(10/(24*60*60))')加入作业。

间隔10秒钟execdbms_job.submit(:v_num,'a;',sysdate,'sysdate+(11/(24*60))')加入作业。

间隔11分钟使用包execdbms_job.remove(21)删除21号作业。

........................Postedby puppy in[玩吧]at2008-11-0610:10:03|访问891次|续文:4 [返回上一页]↓该Blog续文信息↓1.查询oracle表空间的使用情况selectb.file_id 文件ID,b.tablespace_name 表空间,b.file_name 物理文件名,b.bytes 总字节数,(b.bytes-sum(nvl(a.bytes,0))) 已使用,sum(nvl(a.bytes,0)) 剩余,sum(nvl(a.bytes,0))/(b.bytes)*100 剩余百分比fromdba_free_spacea,dba_data_filesbwherea.file_id=b.file_idgroupbyb.tablespace_name,b.file_name,b.file_id,b.bytesorderbyb.tablespace_name2.查询oracle系统用户的默认表空间和临时表空间selectdefault_tablespace,temporary_tablespacefromdba_users3.查询单张表的使用情况selectsegment_name,bytesfromdba_segmentswheresegment_name='RE_STDEVT_FACT _DAY'andowner=USERRE_STDEVT_FACT_DAY是您要查询的表名称4.查询所有用户表使用大小的前三十名select*from(selectsegment_name,bytesfromdba_segmentswhereowner=USERorderbyb ytesdesc)whererownum<=305.查询当前用户默认表空间的使用情况selecttablespacename,sum(totalContent),sum(usecontent),sum(sparecontent),avg(spar epercent)from(SELECTb.file_idasid,b.tablespace_nameastablespacename,b.bytesastotalContent,(b.byte s-sum(nvl(a.bytes,0)))asusecontent,sum(nvl(a.bytes,0))assparecontent,sum(nvl(a.bytes, 0))/(b.bytes)*100assparepercentFROMdba_free_spacea,dba_data_filesbWHEREa.file_id=b.file_idandb.tablespace_name=(selectdefault_tablespacefromdba_use rswhereusername=user)groupbyb.tablespace_name,b.file_name,b.file_id,b.bytes)GROUPBYtablespacename6.查询用户表空间的表select*fromuser_tablesPostedby puppy at2008-11-0611:09:07select*from(selectbytes,segment_name,segment_type,ownerfromdba_segments wheretablespace_name='SYSTEM'orderbybytesdesc)whererownum<10Postedby puppy at2008-11-0719:44:33SQL>selecttablespace_name,(bytes/1024/1024)Mfromdba_data_files; TABLESPACE_NAMEM----------------------------------------------------------------------USERS5SYSAUX310UNDOTBS130SYSTEM490EXAMPLE100Postedby puppy at2008-11-0719:45:16system表空间增大是正常的,但急剧增大是不合理的。

相关文档
最新文档