分类存档: My Diary

Error ORA-01775: looping chain of synonyms when export

C:\Documents and Settings\nai3119>expdp ‘/ as sysdba’ DIRECTORY=DMPDIR schemas=DOW_USER DUMPFILE=JVL
PS04P_RELEASE31_EXP0211.DMP LOGFILE=JVLPS04P_RELEASE31_EXP0211.LOG

Export: Release 11.2.0.2.0 – Production on Fri Feb 10 06:06:30 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Automatic Storage Management, Oracle Label Security, OLAP, Oracle Database Vault
and Real Application Testing options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms

*************************************************************************

solution: query in database with below sql,

SELECT owner, object_name, object_type, status from dba_objects where object_name like ‘%SYS_EXPORT%’;

if you get a record like with type SYNONYM

OWNER                     OBJECT_NAME                  OBJECT_TYPE         STATUS
————————- —————————- ——————- ——-
PUBLIC                    SYS_EXPORT_SCHEMA_01         SYNONYM             VALID 

drop this SYNONYM manually,

DROP PUBLIC SYNONYM SYS_EXPORT_SCHEMA_01 ;

and try the export again.

 

Reason: Oracle will create a SYNONYM for datapump job when the job starts, once the job completes successfully the SYNONYM will be dropped as well, but if the job fails, the SYNONYM be dropped and you will get above error message.

 

Oracle REMAP_TABLE in data pump

I tried to use REMAP_TABLE in Oracle 10.2.0.5, but it doesn’t work at all. finally I found out there is a bug and this parameter doesn’t work, check here for detail,
http://yangtingkun.itpub.net/post/468/473037

To make sure that we can use this, we can also refer the step in this link,

http://yangtingkun.itpub.net/post/468/473311

 

SSIS Service default instance

you can find that default instance of SSIS here,

%ProgramFiles%\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml

this file is XML format.

also make sure that your service account of your instance (the job in which the SSIS package is called) can access the default instance of the SSIS if your SSIS package is stored in MSDB.

 

Oracle 11g New Feature – password case sensitive

##Case Sensitive Passwords in Oracle Database 11g Release 1
Case sensitive passwords (and auditing) are a default feature of newly created Oracle 11g databases. The Database Configuration Assistant (DBCA) allows you to revert these settings back to the pre-11g functionality during database creation.

SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

–when case sensitive passwords are not enabled, the original case of the password is retained so it can be used if case sensitivity is subsequently enabled.

终于好了,放心了

终于好了,放心了

不要生病了,快点好起来

你都发烧39.8C了,全身滚热,我好担心,好害怕。
不要生病了,快点好起来吧。

好累

最近老是觉得好累啊,腰板直不起来, 干什么都没有精神。

看到网上有人说,不能让生活把你累垮了,要学会驾驭它。而对于我,感觉生活驾驭了我。

我想把自己从家务中解脱出来,特别是做饭;

我想每年去一个向往的地方;

我想每天能有时间学习英语和业务知识;

我想热爱生活,每天都开开心心,而不是每天都在抱怨周围;

好想快乐起来,但是就是快乐不起来。

请了解:

请了解,我不是你的保姆!!
请了解,当你下班很累回到家的时候,我同样累了一天,下班去菜场买菜,然后还要做饭!
请了解,当你回家翘起二郎腿看电视,玩电脑的时候,我还在做饭,我还在拖地!
请了解,当你想要下载,而我要求关闭的时候,我是在工作,你是在娱乐,所以,请不要给我脸色看!!
请了解,如果有需要,我更愿意一个人生活!!
请了解,如果有必要,即使现在我不习惯一个人生活,我也会学会一个人生活!!
请了解,如果你觉得你一个可以过的更好,可以不需要有人在旁边唠叨, 不需要被别人指导做家务,不需要和比人分享网络资源,那么请不要犹豫,告诉我,我相信我们可以找到一个很好的方法解决问题!!
请了解,我也赚钱的,我也在养家,并且,我并不比你差!
请了解,尊重对方是我们最好的选择!!
请了解,现在的你一点都不可爱,所以,很难让人继续爱下去!

不想上班

好累, 好烦, 却还得坚持.
是不是这个环境真的不适合我?
谁来回答?!!
好想休息一下…

蜗牛

今天在朋友那听到一个故事,觉得很好,特别适合我现在的情况,写下来让自己记得吧。

小蜗牛问妈妈 为什么我们要背着重重的壳 艰难的前行 妈妈告诉小蜗牛说 因为有重重的壳 能够保护自己不受伤害 那小蜗牛又问了 为什么小毛虫没有壳呢?

妈妈说小毛虫 最后会变成蝴蝶 有天空保护它
小蜗牛又问说 为什么蚯蚓不要背重重的壳呢?
妈妈说 蚯蚓姐姐能转入地下,它有大地的保护
我们虽然艰辛 有重重的壳 但是我们不靠天不靠地 只靠我们自己

这就是生活在大城市里面的蜗牛,他们艰辛 但是他们也很幸福。
为了身上的房子,努力做一个好的房奴!!!