steloflute

http://www.dba-oracle.com/oracle_news/2005_12_16_sql_syntax_differences.htm SQL Syntax differences between Oracle and MS-SQL Here is a great reference page that shows the syntax differences between Oracle SQL and Microsoft SQL Server SQL syntax: http://www.bristle.com/Tips/SQL.htm#Differences%20Between%20Oracle%20and%20MS%20SQL%20Server There is also a great comparison page on SQL built-in funct..

http://www.w3schools.com/sql/sql_autoincrement.asp Auto-increment allows a unique number to be generated when a new record is inserted into a table. AUTO INCREMENT a Field Very often we would like the value of the primary key field to be created automatically every time a new record is inserted. We would like to create an auto-increment field in a table. Syntax for MySQL The following SQL statem..

http://www.dba-oracle.com/t_ora_39087_directory_name_invalid.htm ORA-39087: directory name is invalid tips Expert Oracle Tips by Burleson Consulting December 23, 2010 Question: I am getting the ORA-39087 error when running expdp: $ expdp myschema/mypass DIRECTORY=MY_DATA_PUMP_DIRECTORY DUMPFILE=Test1.dmp logfile=Test1.log SCHEMAS=myschema Export: Release xx.x.x.x.x - xxbit Production on Tuesday,..

http://stackoverflow.com/questions/61963/howto-import-an-oracle-dump-in-an-different-tablespace If you're using Oracle 10g and datapump, you can use the REMAP_TABLESPACE clause. example:REMAP_TABLESPACE=A_TBLSPACE:NEW_TABLESPACE_GOES_HERE

http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htm Question: I understand that there are times that you need to force a log switch for backups, but I have noted that Oracle has two ways to force a logfile switch, ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ARCHIVELOG CURRENT. What is the difference between ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ..

-- 현재 flashback 가능 기간 보기(분) select value from v$parameter where name='db_flashback_retention_target'; http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams056.htm http://www.oracleclub.com/lecture/1876 Oracle Flashback 기능 이란? DB 관리중에 실수로 데이타를 삭제하거나 데이타의 값을 잘못 변경 하는 실수가 가끔 발생을 합니다. 이러한 오류를 바로 인식할 경우는 Rollback이라는 명령으로 바로 전에 수행한 작업을 원상복귀시킬 수 있지만, COMMIT을 한 이후 시점이나, 한참 시간이 지난 후에 알았다면 간단하게..

수동으로 table을 reorg하는 방법 (공간 재조직) 테이블2에 데이터를 복사 원본 테이블을 truncate하여 공간 확보 테이블2의 내용을 원본 테이블에 복사 drop 테이블2 -- manual reorg create table tbl2 as select * from tbl; truncate table tbl; insert into tbl select * from tbl2; drop table tbl2 purge; commit;

http://stackoverflow.com/questions/233870/how-can-i-create-a-copy-of-an-oracle-table-without-copying-the-data I know the statement:create table xyz_new as select * from xyz; Which copies the structure and the data, but what if I just want the structure? Just use a where clause that won't select any rows:create table xyz_new as select * from xyz where 1=0;

http://www.oncalldba.com.au/node/37 Compile Invalid Public Synonyms 22. April 2010 - 9:40 — Scott Hollows This article shows how to recompile public synonyms in an Oracle database that are currently invalid Public synonyms may show as invalid in DBA_OBJECTS even though they are actually valid and working correctly. This often occurs after the target object is modified or dropped and recreated. W..

http://venkat-freetutorials.blogspot.kr/2009/10/data-pump-export-expdp-and-data-pump.html Data Pump Export (expdp) and Data Pump Import(impdp) Oracle introduced Data Pump in Oracle Database 10g Release 1. This new oracle technology enables very high transfer of data from one database to another. The oracle Data Pump provides two utilities namely: Data Pump Export which is invoked with the expdp ..