Teradata VS Oracle

It is not wise to compare an apple with a orange, so below comparison is just for knowledge since Oracle is best in its own space and Teradata in other.

Blog is Open for comments and suggestion!!

	Oracle	Teradata
Design Goals	Generic purpose either can be as OLTP or OLAP	Used widely for OLAP not designed for OLTP
Architectural  Wise	Shared everything architecture which means all instances can see data in database	Shared nothing architecture which is each amp owns its data in database
Operating  system	Oracle can be installed in almost all OS like windows, Linux, Mac OS X, Unix, Z/OS,HP-UX etc.	Teradata supports only Linux, windows and Unix
Parallelism	Supports Parallel processing but limited to resource like partitioning, users, tables,system etc.	Designed for parallel processing and it is never conditional/Limited
Utilities	SQL*LOADER & Data Pump	Multiload, Fastload, Tpump, FastExport & Teradata parallel transporter(TPT)
Transactional  management	Rollback	Transient Journal
Default Perm  Space	Tablespace – i.e. tables are created at tablespace	Database- i.e. tables are created at database
Temporary  Space	Temp Space	Spool Space
Monitoring  tool	Oracle Enterprise Manager	Teradata viewpoint and previously Teradata manager and PMON
Partitioning	Range, Hash, Composite Range, List, Composite List, Range-Range, Range-Hash, range-list, list-range, list-hash, list-list interval, reference	Teradata Partitioned Primary Index and Teradata Multilevel Partitioned Primary Index
Ordered Analytical/ Aggregate Function	Supports more Analytical / Aggregate function than teradata	New Analytical function like DENSE_RANK, CUME_DIST, FIRST_VALUE, LAST_VALUE and New  Aggregate function like PERCENTILE_CONT, PERCENTILE_DISC, MEDIAN to compete  oracle from TD 14
Duplicate  rows in Table	Any table without primary key can own a duplicates	Table need be MULTISET to hold duplicate
Data Back up	Not as flexible as Teradata but has online backup	Can do data back up and still jobs can insert and read data from table without going offline
Null  Manipulation	Concatenation of a null with a strings gives string as result	Concatenation of a null with a strings gives Null as result
Handling Null	NVL	COALESCE
Database  Management  tool	Preferred tool is sqldeveloper	Preferred tool is SQL Assistant
Dummy table	DUAL	No Dummy table
Data types	VARCHAR2, NVARCHAR2, NUMBER ,  FLOAT , LONG, DATE , BINARY_FLOAT,  BINARY_DOUBLE,   TIMESTAMP, TIMESTAMP  [(fractional_seconds)]  WITH TIMEZONE,  TIMESTAMP  [(fractional_seconds)]  WITH LOCALTIME ZONE, INTERVAL YEAR  [(year_precision)]  TO MONTH, INTERVAL  DAY  [(day_precision)]  TO SECOND [(fractional_seconds)], RAW(size), LONG RAW, ROWID, UROWID  [(size)], CHAR  [(size [BYTE | CHAR])], NCHAR[(size)], CLOB, NCLOB, BLOB, BFILE	NUMERIC(n,p), BIGINT FLOAT, REAL,DOUBLE PRECISION, BYTE(n),  VARBYTE(n), BLOB, CHAR(n), VARCHAR(n), LONG VARCHAR, GRAPHIC(n), VARGRAPHIC(n), LONG VARGRAPHIC , DATE, TIME(n), TIMESTAMP(n),  PERIOD(DATE), PERIOD(TIME(n)), PERIOD (TIMESTAMP(n)), ST_GEOMETRY, MBR,CLOB TIME(n) WITH TIMEZONE, TIMESTAMP(n) WITH TIMEZONE, PERIOD(TIME(n) WITH TIMEZONE),PERIOD TIMESTAMP(n) WITH TIMEZONE), INTERVAL YEAR TO MONTH , INTERVAL YEAR, INTERVAL DAY TO HOUR,INTERVAL MONTH,INTERVAL DAY TO INUTE, INTERVAL DAY , INTERVAL DAY TO COND,INTERVAL HOUR, INTERVAL HOUR TO MINUTE, INTERVAL MINUTE, INTERVAL HOUR TO SECOND, INTERVAL SECOND, INTERVAL MINUTE TO SECOND