Answer Posted / prasanna

Hi Innocent,

Appreciate for your answer.

But one small correction is that tablename and database name columns are present in DBC.indices itself where as you had went for a join condition with dbc.tablesize.

so without join condition we can take both tablename and database  from dbc.indices table.

Thanks
Prasanna.

How is the teradata different from oracle?

1117

---

What are the different functions included in the server software?

1034

---

How is MLOAD Client System restarted after execution?

1157

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

989

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1204

---

What are the uses of client software involved in teradata?

984

---

Explain the term 'tables' related to relational database management system?

1055

---

what is object level locking ? where do appear this type of locking ?

3502

---

How is MLOAD Teradata Server restarted after execution?

1268

---

What are the enhanced features in teradata v2r5 and v2r6?

1138

---

Explain and compare pros and cons of snow flake schemas?

1035

---

Which is faster fastload or multiload?

1119

---

Can we collect statistics on table level?

1037

---

How would you load a very large file in teradata in general?

1034

---

what is sysdba and sysdbc ? which has high priority ?

3832

---