sgfx外匯

Ⅰ 如何手動創建oracle資料庫

創建資料庫前，要做的工作：
1.收集要設置的ORACLE_HOME路徑 ORACLE_SID
2.創建資料庫需要的目錄
按照下面的步驟創建：（以AIX系統為例，Linux差不多，但有些文件的路徑和文件名不一樣）
1.編輯系統參數文件（AIX系統參數文件：.profile） :vi .profile文件 若是以前已添加過資料庫的，則只需修改下ORACLE_SID=sg186fx(以我創建的資料庫名為例)；若是沒有添加過關於數據的參數，則需要添加ORACLE_HOME,ORACLE_BASE等的路徑。
我的「.profile」文件中設置的路徑：
ORACLE_BASE=/oracle;export ORACLE_BASE
ORACLE_HOME=/oracle/proct/10.2.0/db_1; export ORACLE_HOME
#ORA_CRS_HOME=/oracle/proct/10.2.0/crs; export ORA_CRS_HOME
SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$SHLIB_PATH
export SHLIB_PATH
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$LIBPATH
export LIBPATH
PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH:/oradata/quest/splex/bin; export PATH
export ORACLE_SID=sg186fx（這是在創建多個資料庫，啟動不同數據實例時需要修改的地方）
2.修改完系統參數文件，可以退出登錄，重新登錄進來就可以生效了，或者使用「export ORACLE_SID=sg186fx」在當前會話中生效。
3.創建資料庫需要的目錄
創建目錄腳本：
su – oracle
cd /oradata
rm –rf sg186fx
mkdir sg186fx
cd /oracle/admin
rm –rf sg186fx
mkdir sg186fx
cd sg186fx
mkdir amp bmp cmp dpmp ump pfile
這個腳本可以不斷進行測試創建資料庫目錄的時候使用。
4.創建oracle的啟動參數文件——pfile或spfile
db_cache_size=4026531840
java_pool_size=16777216
large_pool_size=16777216
shared_pool_size=855638016
streams_pool_size=0
audit_file_dest='/oracle/admin/sg186fx/amp'
background_mp_dest='/oracle/admin/sg186fx/bmp'
compatible='10.2.0.2.0'
control_files='/oradata/sg186fx/control01.ctl','/oradata/sg186fx/control02.ctl','/oradata/sg186fx/control03.ctl'
core_mp_dest='/oracle/admin/sg186fx/cmp'
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=16
db_name='sg186fx'
dispatchers='(PROTOCOL=TCP) (SERVICE=sg186fxdb)'
job_queue_processes=10
open_cursors=300
pga_aggregate_target=1639972864
processes=250
remote_login_passwordfile='EXCLUSIVE'
sessions=280
sga_target=4920967168
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
user_mp_dest='/oracle/admin/sg186fx/ump'
使用上面設置的參數文件創建pfile的文件名問initsg186fx.ora
5.創建密碼文件
orapwd file=』orapwd$ORACLE_SID』 password=sys entries=20 force=y
file的參數需要指定路徑的，他的創建位置應該在$ORACLE_HOME/dbs中，若是在當前目錄下創建就不需要寫上路徑了。
password設置是資料庫的sys用戶的密碼。
entries:DBA和操作員的最大用戶數
force=y 等號中間不能有空格的，這是表示存在該文件則進行強制重寫。
6.編寫創建資料庫腳本（非常重要的一步）
創建腳本請看腳本代碼
查看創建資料庫的必備的參數模板
在這個創建資料庫腳本編寫中可能會出現需要錯誤，將會在下篇重點分析，我在創建的過程中，出現過很多錯誤。
7.使用命令登錄：
sqlplus /nolog
connect / as sysdba(注意：在這一步連接的時候，資料庫要創建一些跟蹤文件：alert文件等，若是在第三步創建目錄的時候使用的不是oracle用戶角色創建的用戶，則在這一步登錄的時候，由於許可權不夠會出現錯誤：ORA-09925：Unable to create audit trail file，此時需要去檢查下手動創建的目錄的許可權對不對)
startup nomount pfile=』$ORACLE_HOME/dbs/initsg186fx.ora』 這一步啟動資料庫只載入啟動參數文件的狀態，並沒有裝載控制文件和數據文件
@/createdatabase.sql 執行創建資料庫腳本。
這一步很容易出錯，出現最多的是：
2
alert日誌顯示的錯誤信息：
3
這個錯誤提示看不出有什麼錯誤，因為他只是說腳本有錯誤，導致實例強制被終止。雖然報這個錯誤，但其他的文件將會正常的被創建，資料庫還是不能運行的。所以要排除這個錯誤，重新創建資料庫。必須去看alert日誌來看哪個地方出現的錯誤。（我建議，在執行創建腳本的時候，重新打開一個窗口來監控alert日誌，跟蹤創建過程，很容易發現哪句話出現的錯誤。）
8.創建 user表空間和索引表空間
9 若創建沒有出現錯誤，則可以執行rdbms裡面的一些創建數據字典的腳本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
10.重啟資料庫。
到此，資料庫的基本創建工作完成。
簡單的資料庫建成後，如果需要使用全文檢索功能，則還需要執行幾個腳本。
請查看：全文檢索配置方法
若想了解各種oracle自帶的腳本，根據需要執行哪些腳本，請查看：oralce自帶腳本說明

Ⅱ 威綸觸摸屏電纜USB-MT500連接觸摸屏MT506MV 5WV怎麼也連不上

1.看你的電腦上有沒正確安裝觸摸屏的驅動。

2.數據線的驅動安裝是不是正確。

3，軟體埠設置是否正確。（桌面-右鍵-屬性-設備管理器-看你的數據線埠顯示是多少）。

4，檢查通訊線有沒問題。

威綸/USB-MT500纜型號是USB-MT500，適用於威綸通(Weinview)EB500系列和人機(EasyView) MT500系列，符合iso9002產品認證，它的正常工作電壓是12V，輸出頻率50kHz。

(2)sgfx外匯擴展閱讀

觸摸屏MT506MV的規格

處理器是Intel PXA255 200MHz，內存是2MB，DRAM是4MB，串口是1 RS-232 (HMI-PC) 1 RS232/485 (HMI-PLC)，配方是內建(配方卡 128kB)；

自我診斷是電源異常偵測，輸入電壓是24 VDC, 0.5A maximum，人機尺寸(WxHxD)是204x150x48mm，開孔尺寸(WxH)是192x138mm，重量是Approx:0.85 kg。

Ⅲ SG$,CHF,EUR,JPY分別是什麼貨幣單位,摺合多少RMB

SG$ :新加坡元
CHF ：瑞士法郎
EUR ：歐元
JPY ：日元

具體的即時外匯報價（中國銀行）可與參考一下網址：
中文：http://www.bank-of-china.com/cn/common/service.jsp
英文：http://www.bank-of-china.com/en/common/service.jsp

Ⅳ 《三國第一軍師》最新章節全文閱讀免費下載百度網盤資源,誰有

《三國第一軍師》網路網盤txt最新全集下載:
鏈接:https://pan..com/s/1RI29UMkjHvZhsg9fX1UjyQ

Ⅳ oracle資料庫實現全文檢索

Oracle全文檢索配置方法：

1.檢查資料庫是否具有全文檢索功能（這是針對已經建成使用的資料庫）

查看用戶中是否存在ctxsys用戶，查詢角色里是否存在ctxapp角色。以上兩個中的1個不滿足（不存在），則說明沒有裝過全文檢索功能。

使用contains函數的時候，若沒有全文檢索則會報錯的。

2.若沒有，則需要手動建立，先建立全文檢索要使用的空間

sqlplus / as sysdba --進入控制台

createtablespaceIdx_ctxsysdatafile'/oradata/sg186fx/ctxsys01.;--創建全文檢索使用的表空間

3.創建全文檢索使用的用戶和角色及相應的包，則需要執行oracle自帶的一個腳本：cd $ORACLE_HOME/ctx/admin/catctx.sql

還是在sqlplus中執行：

@?/ctx/admin/catctx.sql ctxsys Idx_ctxsys temp nolock

在執行這個腳本的時候，輸入了幾個參數，第一個參數ctxsys為ctxsys用戶的密碼

第二個參數Idx_ctxsys為ctxsys用戶要使用的表空間

第三個參數temp為ctxsys用戶使用的臨時表空間

第四個參數nolock為ctxsys用戶處於解鎖狀態。

4.創建完成後，要登錄ctxsys用戶

connect ctxsys/ctxsys

執行以下腳本：@?/ctx/admin/defaults/drdefus.sql(這是個很重要的腳本，後面創建索引會使用該腳本創建的信息)

5.創建全文索引語法分析器

先要明確使用全文索引的用戶，我要使用全文索引的是sgpm用戶

因此

grantexecuteonctxsys.ctx_ddltosgpmwithgrantoption;

connect sgpm/sgpm

設置語法分析器：

execctx_ddl.drop_preference('chinalexer');
execctx_ddl.create_preference('chinalexer','chinese_lexer');

設置詞法屬性：

execctx_ddl.drop_preference('idx_c_store');

begin
ctx_ddl.create_preference('idx_c_store','BASIC_STORAGE');
ctx_ddl.set_attribut('idx_c_store','I_TABLE_CLAUSE','tablespacesIdx_ctxsy');
ctx_ddl.set_attribute('idx_c_store','I_INDEX_CLAUSE','tablespaceIdx_ctxsycompress2');
end;
/

6.創建索引

createindexsgpm.idx_c_cons_nameonsgpm.c_cons(cons_name)indextypeisctxsys.contextparameters('lexerchinalexerstorageidx_c_store');

7.同步索引

variablejobnonumber;
begin
dbms_job.submit(:jobno,'pkg_sp_tools.p_cont_sys_index();',sysdate,'trunc(sysdate)+19/24+1');--執行的是個性化方法。
end;
/

普通的就是用：

execctx_ddl.sync_index('idx_c_cons_name');

到此，全文檢索創建成功，contains函數就可以正常使用了。

注意：創建的過程中會出現ORA-29879:cannot create multiple domain index on a column listusing same indextype ,這說明在其他用戶下已經建立了該索引。

Ⅵ 匯率方面的英文參考文獻 最少來3個 謝謝 ！~！！！

Exchange rate
In finance, the exchange rates (also known as the foreign-exchange rate, forex rate or FX rate) between two currencies specifies how much one currency is worth in terms of the other. For example an exchange rate of 102 Japanese yen (JPY, ¥) to the United States dollar (USD, $) means that JPY 102 is worth the same as USD 1. The foreign exchange market is one of the largest markets in the world. By some estimates, about 2 trillion USD worth of currency changes hands every day.

The spot exchange rate refers to the current exchange rate. The forward exchange rate refers to an exchange rate that is quoted and traded today but for delivery and payment on a specific future date.

Quotations
An exchange rate quotation is given by stating the number of units of "term currency" or "price currency" that can be bought in terms of 1 unit currency (also called base currency). For example, in a quotation that says the EURUSD exchange rate is 1.3 (1.3 USD per EUR), the term currency is USD and the base currency is EUR.

There is a market convention that determines which is the base currency and which is the term currency. In most parts of the world, the order is:
EUR - GBP - AUD - USD - *** (where *** is any other currency).
Thus if you are doing a conversion from EUR into AUD, EUR is the base currency, AUD is the term currency and the exchange rate tells you how many Australian dollars you would pay or receive for 1 euro. Cyprus and Malta which were quoted as the base to the USD and *** were recently removed from this list when they joined the euro. In some areas of Europe and in the non-professional market in the UK, EUR and GBP are reversed so that GBP is quoted as the base currency to the euro. In order to determine which is the base currency where both currencies are not listed (i.e. both are ***), market convention is to use the base currency which gives an exchange rate greater than 1.000. This avoids rounding issues and exchange rates being quoted to more than 4 decimal places. There are some exceptions to this rule e.g. the Japanese often quote their currency as the base to other currencies.

Quotes using a country's home currency as the price currency (e.g., EUR 1.00 = $1.45 in the US) are known as direct quotation or price quotation (from that country's perspective) ([1]) and are used by most countries.

Quotes using a country's home currency as the unit currency (e.g., £0.4762 = $1.00 in the US) are known as indirect quotation or quantity quotation and are used in British newspapers and are also common in Australia, New Zealand and the eurozone.

direct quotation: 1 foreign currency unit = x home currency units
indirect quotation: 1 home currency unit = x foreign currency units
Note that, using direct quotation, if the home currency is strengthening (i.e., appreciating, or becoming more valuable) then the exchange rate number decreases. Conversely if the foreign currency is strengthening, the exchange rate number increases and the home currency is depreciating.

When looking at a currency pair such as EURUSD, the first component (EUR in this case) will be called the base currency. The second is called the term currency. For example : EURUSD = 1.33866, means EUR is the base and USD the term, so 1 EUR = 1.33866 USD.

Currency pairs are often incorrectly quoted with a "/" (forward slash). In fact if the slash is inserted, the order of the currencies should be reversed. This gives the exchange rate. e.g. if EUR1 is worth USD1.35, euro is the base currency and dollar is the term currency so the exchange rate is stated EURUSD or USD/EUR. To get the exchange rate divide the USD amount by the euro amount e.g. 1.35/1.00 = 1.35

Market convention from the early 1980s to 2006 was that most currency pairs were quoted to 4 decimal places for spot transactions and up to 6 decimal places for forward outrights or swaps. (The fourth decimal place is usually referred to as a "pip.") An exception to this was exchange rates with a value of less than 1.000 which were usually quoted to 5 or 6 decimal places. Although there is no fixed rule, exchange rates with a value greater than around 20 were usually quoted to 3 decimal places and currencies with a value greater than 80 were quoted to 2 decimal places. Currencies over 5000 were usually quoted with no decimal places (e.g. the former Turkish Lira). e.g. (GBPOMR : 0.765432 - EURUSD : 1.3386 - GBPBEF : 58.234 - EURJPY : 165.29). In other words, quotes are given with 5 digits. Where rates are below 1, quotes frequently include 5 decimal places.

In 2006 Barclays Capital broke with convention by offering spot exchange rates with 5 or 6 decimal places. The contraction of spreads (the difference between the bid and offer rates) arguably necessitated finer pricing and gave the banks the ability to try and win transaction on multibank trading platforms where all banks may otherwise have been quoting the same price. A number of other banks have now followed this.

Free or pegged
Main article: Exchange rate regime
If a currency is free-floating, its exchange rate is allowed to vary against that of other currencies and is determined by the market forces of supply and demand. Exchange rates for such currencies are likely to change almost constantly as quoted on financial markets, mainly by banks, around the world. A movable or adjustable peg system is a system of fixed exchange rates, but with a provision for the devaluation of a currency. For example, between 1994 and 2005, the Chinese yuan renminbi (RMB) was pegged to the United States dollar at RMB 8.2768 to $1. China was not the only country to do this; from the end of World War II until 1966, Western European countries all maintained fixed exchange rates with the US dollar based on the Bretton Woods system. [2]

Nominal and real exchange rates
The nominal exchange rate e is the price in domestic currency of one unit of a foreign currency.
The real exchange rate (RER) is defined as , where P is the domestic price level and P * the foreign price level. P and P * must have the same arbitrary value in some chosen base year. Hence in the base year, RER = e.
The RER is only a theoretical ideal. In practice, there are many foreign currencies and price level values to take into consideration. Correspondingly, the model calculations become increasingly more complex. Furthermore, the model is based on purchasing power parity (PPP), which implies a constant RER. The empirical determination of a constant RER value could never be realised, e to limitations on data collection. PPP would imply that the RER is the rate at which an organization can trade goods and services of one economy (e.g. country) for those of another. For example, if the price of a good increases 10% in the UK, and the Japanese currency simultaneously appreciates 10% against the UK currency, then the price of the good remains constant for someone in Japan. The people in the UK, however, would still have to deal with the 10% increase in domestic prices. It is also worth mentioning that government-enacted tariffs can affect the actual rate of exchange, helping to rece price pressures. PPP appears to hold only in the long term (3–5 years) when prices eventually correct towards parity.

More recent approaches in modelling the RER employ a set of macroeconomic variables, such as relative proctivity and the real interest rate differential.

Bilateral vs effective exchange rate
Bilateral exchange rate involves a currency pair, while effective exchange rate is weighted average of a basket of foreign currencies, and it can be viewed as an overall measure of the country's external competitiveness. A nominal effective exchange rate (NEER) is weighted with trade weights. a real effective exchange rate (REER) adjust NEER by appropriate foreign price level and deflates by the home country price level. Compared to NEER, a GDP weighted effective exchange rate might be more appropriate considering the global investment phenomenon.

Uncovered interest rate parity
See also: Interest rate parity#Uncovered interest rate parity
Uncovered interest rate parity (UIRP) states that an appreciation or depreciation of one currency against another currency might be neutralized by a change in the interest rate differential. If US interest rates exceed Japanese interest rates then the US dollar should depreciate against the Japanese yen by an amount that prevents arbitrage. The future exchange rate is reflected into the forward exchange rate stated today. In our example, the forward exchange rate of the dollar is said to be at a discount because it buys fewer Japanese yen in the forward rate than it does in the spot rate. The yen is said to be at a premium.

UIRP showed no proof of working after 1990s. Contrary to the theory, currencies with high interest rates characteristically appreciated rather than depreciated on the reward of the containment of inflation and a higher-yielding currency.

Balance of payments model
This model holds that a foreign exchange rate must be at its equilibrium level - the rate which proces a stable current account balance. A nation with a trade deficit will experience rection in its foreign exchange reserves which ultimately lowers (depreciates) the value of its currency. The cheaper currency renders the nation's goods (exports) more affordable in the global market place while making imports more expensive. After an intermediate period, imports are forced down and exports rise, thus stabilizing the trade balance and the currency towards equilibrium.

Like PPP, the balance of payments model focuses largely on tradable goods and services, ignoring the increasing role of global capital flows. In other words, money is not only chasing goods and services, but to a larger extent, financial assets such as stocks and bonds. Their flows go into the capital account item of the balance of payments, thus, balancing the deficit in the current account. The increase in capital flows has given rise to the asset market model.

Asset market model
See also: Capital asset pricing model
The explosion in trading of financial assets (stocks and bonds) has reshaped the way analysts and traders look at currencies. Economic variables such as economic growth, inflation and proctivity are no longer the only drivers of currency movements. The proportion of foreign exchange transactions stemming from cross border-trading of financial assets has dwarfed the extent of currency transactions generated from trading in goods and services.

The asset market approach views currencies as asset prices traded in an efficient financial market. Consequently, currencies are increasingly demonstrating a strong correlation with other markets, particularly equities.

Like the stock exchange, money can be made or lost on the foreign exchange market by investors and speculators buying and selling at the right times. Currencies can be traded at spot and foreign exchange options markets. The spot market represents current exchange rates, whereas options are derivatives of exchange rates.

Fluctuations in exchange rates
A market based exchange rate will change whenever the values of either of the two component currencies change. A currency will tend to become more valuable whenever demand for it is greater than the available supply. It will become less valuable whenever demand is less than available supply (this does not mean people no longer want money, it just means they prefer holding their wealth in some other form, possibly another currency).

Increased demand for a currency is e to either an increased transaction demand for money, or an increased speculative demand for money. The transaction demand for money is highly correlated to the country's level of business activity, gross domestic proct (GDP), and employment levels. The more people there are unemployed, the less the public as a whole will spend on goods and services. Central banks typically have little difficulty adjusting the available money supply to accommodate changes in the demand for money e to business transactions.

The speculative demand for money is much harder for a central bank to accommodate but they try to do this by adjusting interest rates. An investor may choose to buy a currency if the return (that is the interest rate) is high enough. The higher a country's interest rates, the greater the demand for that currency. It has been argued that currency speculation can undermine real economic growth, in particular since large currency speculators may deliberately create downward pressure on a currency in order to force that central bank to sell their currency to keep it stable (once this happens, the speculator can buy the currency back from the bank at a lower price, close out their position, and thereby take a profit).

In choosing what type of asset to is officially pegged, synthetic markets have emerged that can behave as if the yuan were floating).

匯率
在經濟學上，匯率定義為兩國貨幣之間兌換的比例。通常會將某一國的貨幣設為基準，以此換算金額價值他國幾元的貨幣。在英文使用方面，有時簡寫為FX，此為外國貨幣Foreign Exchange的簡寫。

通俗的說，是一國貨幣單位兌換他國貨幣單位的比率，也可以說是用一國貨幣表示的另一國貨幣的價格。

匯率的特性在於它多半是浮動的比率。只要貨幣能夠透過匯率自由交換，依交換量的多寡，就會影響隔天的匯率，因此，有人也以賺匯差營利，今日以較低的比率購進某一外幣，隔日等到較高的比率出現時，再轉手賣出。

所以有時匯率也能看出一個國家的經濟狀況。了解外匯也能看出這個國家的出口貿易狀況。

交叉匯率
所謂交叉匯率是指兩種不同貨幣之間的價格關系，兩個國家之間的貨幣匯兌是利用各自對美元的匯率套算得出。

舉例來看，若一美元可分別兌換0.8112歐元、109.28日圓，則歐元兌日圓的交叉匯率為134.71（= 109.28/0.8112）。

Ⅶ 匯客MT4軟體在哪裡進行下載免費的外匯行情軟體，聽說是不需要安裝的。

下載匯客MT4軟體需要在匯客論壇注冊的，而且還要回復貼子才可以下載。

你要下就到這個網址去下吧。http://www.onefx.net/bbs/thread-40588-1-1.html

Ⅷ 諾德外匯開戶送金那個是怎麼回事

其實目前諾德Nordfx所有的歡迎賬戶4在注冊後是不w能立刻獲得贈金的。你必須先登錄《交易辦7公3室》對賬戶5進行實名認1證。然後需要在《交易辦8公0室》內4上w傳以8下x兩種證件，一w個u是你的個q人a身份證明，比1如護照、身份證或駕駛執照，另一e個i就是你的地址證明，其中0地址證明是必須包含你的姓名和所在地址。當然你在注冊賬戶3時填寫的個u人s資料務必准確填寫，否則一m旦出現錯誤，賬戶2資料不u予1修改，且該帳號將不s能獲得認3證！最後歡迎賬戶7在完成實名認2證的同時，系統將自動將4美金充入s賬戶0！認3證工y作在5～3個s工l作日7內0完成。 sgjv幄υ場a岌k泰rv幄υ場b暢тzε

Ⅸ 如何實現Oracle資料庫Text全文檢索

Oracle全文檢索配置方法：
1.檢查資料庫是否具有全文檢索功能（這是針對已經建成使用的資料庫）
查看用戶中是否存在ctxsys用戶，查詢角色里是否存在ctxapp角色。以上兩個中的1個不滿足（不存在），則說明沒有裝過全文檢索功能。
使用contains函數的時候，若沒有全文檢索則會報錯的。
2.若沒有，則需要手動建立，先建立全文檢索要使用的空間
sqlplus / as sysdba --進入控制台

1

create tablespace Idx_ctxsys datafile '/oradata/sg186fx/ctxsys01.dbf size 10240M autoextend on next 32M maxsize 20480M;--創建全文檢索使用的表空間

3.創建全文檢索使用的用戶和角色及相應的包，則需要執行oracle自帶的一個腳本：cd $ORACLE_HOME/ctx/admin/catctx.sql
還是在sqlplus中執行：
@?/ctx/admin/catctx.sql ctxsys Idx_ctxsys temp nolock
在執行這個腳本的時候，輸入了幾個參數，第一個參數ctxsys為ctxsys用戶的密碼
第二個參數Idx_ctxsys為ctxsys用戶要使用的表空間
第三個參數temp為ctxsys用戶使用的臨時表空間
第四個參數nolock為ctxsys用戶處於解鎖狀態。
4.創建完成後，要登錄ctxsys用戶
connect ctxsys/ctxsys
執行以下腳本：@?/ctx/admin/defaults/drdefus.sql(這是個很重要的腳本，後面創建索引會使用該腳本創建的信息)
5.創建全文索引語法分析器
先要明確使用全文索引的用戶，我要使用全文索引的是sgpm用戶
因此

1

grant execute on ctxsys.ctx_ddl to sgpm with grant option;

connect sgpm/sgpm
設置語法分析器：

1
2

exec ctx_ddl.drop_preference('chinalexer');
exec ctx_ddl.create_preference('chinalexer','chinese_lexer');

設置詞法屬性：

1

exec ctx_ddl.drop_preference('idx_c_store');

1
2
3
4
5
6

begin
ctx_ddl.create_preference('idx_c_store','BASIC_STORAGE');
ctx_ddl.set_attribut('idx_c_store','I_TABLE_CLAUSE','tablespaces Idx_ctxsy');
ctx_ddl.set_attribute('idx_c_store','I_INDEX_CLAUSE','tablespace Idx_ctxsy compress 2');
end;
/

6.創建索引

1

create index sgpm.idx_c_cons_name on sgpm.c_cons(cons_name) indextype is ctxsys.context parameters('lexer chinalexer storage idx_c_store');

7.同步索引

1
2
3
4
5

variable jobno number;
begin
dbms_job.submit(:jobno,'pkg_sp_tools.p_cont_sys_index();',sysdate,'trunc(sysdate)+19/24+1'); --執行的是個性化方法。
end;
/

普通的就是用：

1

exec ctx_ddl.sync_index('idx_c_cons_name');

到此，全文檢索創建成功，contains函數就可以正常使用了。
注意：創建的過程中會出現ORA-29879:cannot create multiple domain index on a column listusing same indextype ,這說明在其他用戶下已經建立了該索引。

Ⅹ 求《三國第一軍師》全本txt完結小說,謝謝~

《三國第一軍師》網路網盤txt最新全集下載:
鏈接:https://pan..com/s/1RI29UMkjHvZhsg9fX1UjyQ