A table is classified as a parent table and you want to drop
and re-create it. How would you do this without affecting
the children tables?
- 0 Answers
- 1994 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
how do see how much space is used and free in a tablespace
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is blocking and how would you troubleshoot it?
Why would you use sql agent? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you force a log switch?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
which background process will run @ the time of creation of catalog database
What is the difference between Datapump & export/import?
How can you gather statistics on a table?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
