why do we give pctfree and pctused in create table statement?
Answer / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
| Is This Answer Correct ? | 2 Yes | 2 No |
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How do you open a cluster administrator? : sql server DBA
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
what is the use of recording information about current session?
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
What is the difference between online backup & offline backup?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
What are the different ways of moving data or databases between servers and databases in SQL Server?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What types of replication are supported in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)