h****u
发帖数: 31 | 1 I want to dump huge amount of data to oracle without writing redo log.
What I do is: change table to nologging mode, then use insert /*+ append */
into table nologging values (....).
But it STILL write the redo log. The log eventually halts the oracle. What
should I do? I don't want to use SQL*loader, either.
Help, please |
|
w********2
发帖数: 632 | 2 Gene transfer refers to the movement of genes within or between individual
organisms. HGT is often used to refer to all forms of gene transfer that do
not involve parent- to-offspring transfer (sexual or asexual). It can occur
ei- ther naturally or by human intervention (e.g. gene tech- nology, embryo
rescue, in vitro fertilization, protoplast fusion, self-cloning). In some
cases, HGT may be tran- sient, and not perpetuated in the offspring. Each
form of HGT comes with different considerations o... 阅读全帖 |
|
m*r
发帖数: 37612 | 3 nothing else is intereted
Hello Laoda,
We're writing to thank you for your loyalty. As you know, we think our best
customers deserve the very best in return. We want to remind you of all of t
he great benefits you get, and introduce you to all the exciting new Premier
Silver member benefits you get to take advantage of:
? FREE House Call from Geek Squad. We'll help you make the most of your tec
hnology with your choice of one of the following services per calendar year:
home network setup, TV ca... 阅读全帖 |
|
L***s
发帖数: 9258 | 4 To summarize, the original contribution of this work is still questionable a
nd has major flaws. The authors should be honest and should not ignore the p
rior art in which lots of techniques are generic and applicable to many tech
nologies.
老子气坏了，写了封email回给editor:
We feel very disappointed and strongly disagree the criticism raised by revi
ewer on our academic ethics. We believe we have already given a fair judgeme
nt on the difference between our work and all prior-art works at the maximum
exte... 阅读全帖 |
|
l**a
发帖数: 43 | 5 Title: Project Electrical Engineer
Location: Pittsburgh,PA
Duration: Permanent
Outcomes: The successful candidate will:
. Lead in the discovery, adaptation and integration of new and existing tech
nologies and create innovative, reliable and quality new product designs for
the treatment of OSA (Obstructive Sleep Apnea) and other sleep disorders.
. Be a highly motivated, self disciplined, open minded, individual possessin
g hands-on skills.
. Successfully interact with other key group members in |
|
m****s
发帖数: 18160 | 6 【 以下文字转载自 JobHunting 讨论区 】
发信人: lyca (BUDDHA), 信区: JobHunting
标 题: Job opening
发信站: BBS 未名空间站 (Mon Nov 16 11:17:47 2009, 美东)
Title: Project Electrical Engineer
Location: Pittsburgh,PA
Duration: Permanent
Outcomes: The successful candidate will:
. Lead in the discovery, adaptation and integration of new and existing tech
nologies and create innovative, reliable and quality new product designs for
the treatment of OSA (Obstructive Sleep Apnea) and other sleep disorders.
. Be a highly motivated, s |
|
n*****c
发帖数: 54 | 7 【 以下文字转载自 Boston 讨论区 】
发信人: nologic (No Logic), 信区: Boston
标 题: Boston现在哪些公司比较好？
发信站: BBS 未名空间站 (Thu Jul 14 14:53:17 2011, 美东)
做软件的在找工。
有什么好建议吗？ |
|
n*****c
发帖数: 54 | 8 http://www.mitbbs.com/article_t0/Carolinas/31282379.html
【 以下文字转载自 Carolinas 讨论区 】
发信人: nologic (No Logic), 信区: Carolinas
标 题: 求教Raleigh的交通（car service、taxi、公交）
发信站: BBS 未名空间站 (Tue Jan 31 16:18:36 2012, 美东)
我下月要去从未去过的Raleigh市访问NCSU，住在Marriot里。
在Marriot跟NCSU之间的交通怎么样？
早上8点前要去到Varsity Dr.的visitor building。
因为不熟路，不大想开车。
小妹人生地不熟，拜托大哥哥大姐姐们帮帮忙。 |
|
|
s**n
发帖数: 156 | 10 保龄球的心理技巧
主题：Teach Your Mind How to Win
出处：Bowling Digest, August 2000
作者：Jeri Edwards（现为美国队教练）
译者：nolog（青竹）
与练习身体（体格）技术（physical techiniques）比如步法，释球等一样，你也
需要练习一些心理技巧（mental skills），以便使你更强大。
Yogi Berra曾经说棒球90% 比的是心理，这个数字虽然可以存疑，但是心理的重要
性是毫无疑问的，保龄球就是一面镜子。
发展并强化你打保龄球的心理技术，可以提高分数，增加乐趣，能使你获得更多的
成功机会。这些技术有很多，比如自我交流，肯定言词，心态调整，专注，目标设定，
形象化以及准备例程(pre-shot routine)等。
如果你对这些心理技术能多加练习，那么不仅能提高你的球技，而且对你的生活也
会有所裨益。保龄球不过是宏观世界的微观缩影——在打球中发展出来的应对挑战的技
巧也能使你从容面对生活的挑战：你要学会鉴别什么是你需要改进的；你也要处理好快
乐和悲伤；你还要做出决断和寻找平衡。 |
|
c***k
发帖数: 4349 | 11 http://www.popjolly.com/woman-says-she-became-pregnant-after-watching-porn-i
n-3d-365
A white American woman who had a black baby claims she fell pregnant whilst
watching a porn movie in 3D. According to reports, the childs father , who i
s white was serving in the military in Iraq when she became pregnant.
His wife Jennifer told him the child was conceived whilst watching a porn mo
vie in 3D.
“I see it as suspicious. The films in 3-D are very real. With today’s tech
nology, anything is possible |
|
n********a
发帖数: 68 | 12 sqlplus /nolog @blabal
then
connect sys/****** as sysdba; |
|
s*******e
发帖数: 151 | 13 after you log in to the oralce,
you can try this:
sqlplus /nolog
and you can connect as sysdba. |
|
s***m
发帖数: 28 | 14
You may want to create a database first before you create any user. Login as
dba create database, then create user with proper privilege in your database.
On Orace machine
sqlplus /nolog;
connect system as sysdba;
######Then create your user#############3
create user yourusername identified by 'password';
grant connect to yourusername;
grant resource to yourusername;
You need to setup appropriate tablespace for your user so user will not put
junk into system tablespace. |
|
s*******e
发帖数: 151 | 15 when "oracle not avaible" happens, it could be a lot of situations.
I met one error like you last week, you can try to do that,
sqlplus /nolog
connect /as sysdba
shutdown immediate;
startup;
maybe last time, you or sb else shutdown the database. |
|
a**m
发帖数: 17 | 16 system/manager
or login as oracle OS user:
sqlplus /nolog
SQL plus prompt>connect /as sysdba |
|
c*****d
发帖数: 6045 | 17 我的意思是在你学校的机器上用sqlplus测试一下
$> sqlplus /nolog
sqlplus> conn scott/tiger@Oracle10g
1521) |
|
y********o
发帖数: 2565 | 18 测试如下：
sqlplus /nolog
SQL> connect scott/tiger@Oracle10g
Connected.
SQL> desc user_tables;
Name Null? Type
------------------------ -------- -----------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLESPACE_NAME VARCHAR2(30)
CLUSTER_NAME VARCHAR2(30)
IOT_NAME VARCHAR2(30)
[snip]
SQL> |
|
c*****d
发帖数: 6045 | 19 你的结果说明你学校的机器1521端口没问题
service_name是Oracle10g.my.univ.edu
然后在你家里的机器tnsnames.ora上添加
Oracle10g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.my.univ.edu)(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oracle10g.my.univ.edu)
)
)
然后做同样的测试
$> sqlplus /nolog
sqlplus> conn scott/tiger@Oracle10g |
|
w*r
发帖数: 2421 | 20 use ODBC based tool or fast export to write data into file (named pipe under
unix) and import to Oracle using build loader such as SQLLoader.
The benefit of using ODBC tool is it is simple and easy to migrate. Fast
export for Teradata is very very fast.
SQLLoader for oracle need some tuning of the table and infrastructure
parameter.
You can also use build insert (nolog no redo no undo) mode for oracle stack
tables (not index organized) .
easist way to do it is to use informatica to build a direc |
|
B*****g
发帖数: 34098 | 21 猜一个Direct-path INSERT to Nologging table？
finally |
|
F***7
发帖数: 884 | 22 在create那些intermediate tables的时候用nologging就可以减少redo size了，不过
如果你的db用了force logging，这招就不好使了
archive mode是用来replication和recovery的，不支持你说的那种selective mode
DML |
|
c*****d
发帖数: 6045 | 23 在Oracle里普通的dml必然产生log
nologging只是对direct load等特殊操作才有效
为什么这个manager要求intermediate table不能是global temp table?
难道他要保留这些表中的数据？
DML |
|
b*****r
发帖数: 239 | 24 It is doable for Insert, but not for update/delete.
you can setup table level nologging, and use INSERT /*+APPEND*/ ...
DML |
|
w*********r
发帖数: 2095 | 25 Thank you for the reply.
When I start up sqlplus, I
1) su - oracle,
2) input the password when asked
3) Oracle $: sqlplus /nolog,
4) conn / as sysdba
5) startup.
I tried to use the Oracle account username and password and they do not work
either. |
|
n****f
发帖数: 905 | 26 你這樣做， 理論上可以， 現實面臨問題太多。
比如， 你需要很大的 UNDO， TEMP TBS， 其次， 假如是在線， 你不可能鎖住一個表
太長時間。
用建立新的表來代替在原有表上進行修改試試， 肯定很快。
CREATE TABLE XYZ NOLOGGING AS SELECT C1， C2， C1× OPQ AS C3 。。。。 FROM
ORG_TABLE WHERE ......
THEN DROP ORG TABLE, RENMAE XYZ BACK TO ORG.
底線是， 非要 UPDATE 的地方， 也要在清除大部分存檔數據之後進行
*PLEASE BACKUP ALL TABLES FIRST* |
|
n****f
发帖数: 905 | 27 Some updates can be replaced by SELECT statement. For example:
UPDATE A SET COL1 = COL1 + 100
CAN BE REPLACED BY:
CREATE TABLE B NOLOGGING AS SELECT COL1 + 100 AS NEW_COL1 FROM A;
But some updates can't be done by this way for some reason.
YES. it will take time to create indexes.
And you should use partition tables. |
|
n*****c
发帖数: 54 | 28 【 以下文字转载自 Boston 讨论区 】
发信人: nologic (No Logic), 信区: Boston
标 题: 唉！老房子搞不定Verizon DSL
发信站: BBS 未名空间站 (Sat Aug 6 00:49:10 2011, 美东)
我住在Arlington一间multifamily其中一个单位，order了Verizon DSL，今天收到
modem，plug进phone jack里完全没反应，拆开来才发觉里面的电话线全坏了。再看另
一个jack，居然连plug都没了，就一个空洞。没办法，只好剪开电话线直接接上去。电
话线里面的电线实在太小，我没工具，弄了几个小时才勉强弄出一厘米左右的两股电线
。从屋子外通到屋子内的电话线是一条比较粗的铜线。我那条电话线是普通电话线，里
面有一红一绿两条用胶套着的两股细铜线，每股是4条细细的铜线。我没装电话线方面
的经验，就按照颜色来接。我将红色的铜线接到红色的电话线上，绿色的铜线接到绿色
的电话线上，但依然完全没信号。这是怎一回事？这样接对吗? |
|
|
B******y
发帖数: 9065 | 30 汇报一下使用结果：options nolog;似乎不起作用，我调试了几遍都没有成功，只好放
弃。proc printto没有问题，flyerr的例子里面有个New，不知道有什么用，反正我没
有加也是可以的。就是SAS运行起来和从前一样巨慢。 |
|
f****o
发帖数: 4067 | 31
# begin build properties # autogenerated by buildinfo.sh ro.build.id=KOT49I.
LS740ZV6 ro.build.display.id=KOT49I.LS740ZV6 ro.build.version.incremental=
LS740ZV6.1440117223 ro.build.version.sdk=19 ro.build.version.codename=REL ro
.build.version.release=4.4.2 ro.build.date=Fri Aug 21 09:36:06 KST 2015 ro.
build.date.utc=1440117366 ro.build.type=user ro.build.user=jenkins ro.build.
host=LGEACI5R6 ro.build.tags=release-keys ro.product.model=LGLS740 ro.
product.brand=lge ro.product.name=x5_spr_us ro... 阅读全帖 |
|
B*Z
发帖数: 7062 | 32 来自主题: _Auto_Fans版 - 新款MDX Refreshed 2017 Acura MDX Makes World Debut in New York with Bold New Styling
, Upgraded Features and Sport Hybrid Powertrain
? 2017 MDX showcases new diamond pentagon grille first seen on the Acura Pre
cision Concept
? New Sport Hybrid powertrain delivers the ultimate in power and control whi
le gaining 35 horsepower and anticipated to add 7 mpg to city fuel economy r
ating
? AcuraWatch? safety and driver assist technology to be offered as standard
equipment on all 2017 MDX models
NEW YORK (Mar.... 阅读全帖 |
|
