Index_T

T

tables. See also columns; rows

creating, 202–210

CREATE statement and, 35–37, 36

Create Table As Select (CTAS), 203–205

CREATE TABLE statement and, 202, 203, 208, 234–236, 253

external tables, 205–207, 205

relational tables, 202–203

temporary tables, 208

data integrity between parent and child tables. See FOREIGN KEY constraints

DUAL tables, 46–48, 47

eliminating, with DROP statement, 38

relational databases and, 4

renaming, with RENAME statement, 38–39

using multiple. See joins

TABLES keyword, 269, 270

tablespaces

basics of, 158, 159, 161

checking, 170, 170

transportable, 276–280, 277

Technet Web site, 301

temporary tables, creating, 208

thin clients, defined, 18

tiers, 14

TKPROF, 300–301, 301

TOAD. See Tool for Oracle Application Developers (TOAD)

TO_CHAR numeric formatting, 62

Tool for Oracle Application Developers (TOAD), 22, 22

Top SQL tool, 256–257, 256–257

totals, and report formatting, 191–192

trace files

system trace files, 296–297, 297

user trace files, 297–301

converting trace files, 300–301, 301

enabling tracing, 298

locating, 298–300, 300

transaction processing, 151–154

COMMIT statement and, 152–153, 153

read consistency, defined, 151

ROLLBACK statement and, 153–154

SAVEPOINT statement and, 154

transactions, defined, 151

transportable tablespaces, 276–280, 277

troubleshooting, 289–302

alert log files and, 290–293, 291

OEM’s Event Manager and, 293–296, 293–295

system trace files and, 296–297, 297

user trace files and, 297–301

converting, 300–301, 301

enabling tracing, 298

locating, 298–300, 300

TRUNCATE statement, 39

TTITLE command, 186–187