What would you use to improve performance on an insert statement that places millions of rows into that table?
1 3715If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
2149How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1915You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
1 8964I 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?
1 4018You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
1927Post New Oracle General Questions
How to drop a stored procedure in oracle?
What are ddl statements in oracle?
How to create a table in a specific tablespace?
How to create an oracle database?
defination of bitmap index
What is the disadvantage of User defind function?
How to define a variable of a specific record type?
Why do we need integrity constraints in a database?
What is the minimum client footprint required to connect c# to an oracle database?
How to handle a single quote in oracle sql?
What is oracle sid?
How to drop a stored function?
How to delete a column in an existing table?
How to omit columns with default values in insert statement in oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?