Skip to main content

Posts

Showing posts from February, 2012

Solution to Looping Chain of Synonyms Problem During Export(EXPDP)

Solution to Looping Chain of Synonyms Problem During Export(EXPDP) While I was trying to export using data pump i found the following error. Later I found a solution that worked. The expdp command was: bash-3.00$ expdp user/pass schemas=schema_name directory=db_back dumpfile=test_27022012.dmp VERSION=10.2 Export: Release 11.2.0.1.0 - Production on Tue Feb 28 10:27:07 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39001: invalid argument value ORA-01775: looping chain of synonyms The Solution: Issue the following query to find the synonyms with status valid. Select owner, object_name, object_type, status   from dba_objects  where object_name like '%SYS_EXPORT%'; Drop all the synonyms that have Status Valid: DROP PUBLIC SYNONYM SYS_EXPORT_SCHEMA_01

Changing DATE or TIME on UNIX

Changing DATE or TIME on UNIX The Command: bash# date mm dd hh mm yy The date command takes the syntax mmddhhmmyy, or “month day hour minute year” . You have to be superuser to set the time. Example:     # date 1201010106     Fri Dec  1 01:01:00 PST 2006 _________________________________________________________________________________

All Dictionary View Tables:

All Dictionary View Tables: TABLE_NAME COMMENTS ALL_ALL_TABLES Description of all object and relational tables accessible to the user ALL_APPLY Details about each apply process that dequeues from the queue visible to the current user ALL_APPLY_CONFLICT_COLUMNS Details about conflict resolution on tables visible to the current user ALL_APPLY_DML_HANDLERS Details about the dml handler on tables visible to the current user ALL_APPLY_ENQUEUE Details about the apply enqueue action for user accessible rules where the destination queue exists and is visible to the user ALL_APPLY_ERROR Error transactions that were generated after dequeuing from the queue visible to the current user ALL_APPLY_EXECUTE Details about the apply execute action for all rules visible to the user ALL_APPLY_KEY_COLUMNS Alternative key columns for a STREAMS table visible to the current user ALL_APPLY_PARAME