Hot answers tagged oracle-11g-r2
5
Use expdp and impdp, in combination with the remap_schema option.
For example...
Firstly, make sure the target user/schema is already created. It may also temporarily need the IMP_FULL_DATABASE role, but I haven't tested this.
Create a directory object to hold the dump files and logs (make sure this exists on your filesystem):
create directory DUMPDIR as ...
4
If my source database uses SPFILE then do I have create a PFILE from the SPFILE?
Yes, you need to create a temporary PFILE to use while duplicating the database. You will later switch the new instance to use the SPFILE.
Use
CREATE PFILE = 'path/to/pfile' FROM SPFILE;
You only need to create directories that are referenced in the PFILE or SPFILE.
...
2
You'll need to execute your SQL statement. Use execute immediate for this. And because you're selecting a value you'll need to execute immediate ... into it, something like this (replacing 3 > 2 with your own where condition:
CREATE OR REPLACE PROCEDURE test(p_table IN varchar2) IS
v_sqltxt varchar2(4000);
v_count integer;
BEGIN
v_sqltxt:='select ...
2
No, you don't have to reinstall the Oracle software. According to the section "Oracle Database 11g Release 2 (11.2.0.1) New Features" in the Database Installation Guide 11g Release 2:
Oracle Universal Installer no longer provides the custom installation
option of individual components. Use the chopt tool, a command-line
utility that is located in ...
2
You'd need to add IS_SPECIFIED (or ISSPECIFIED) to the where clause, as some hidden parameters may be set by... other things.
A parameter can be removed from an spfile by issuing:
ALTER SYSTEM RESET "_some_hidden_parameter" scope = spfile;
You will likely have to stop and start the instance(s) to have the changes take effect.
2
Create a pfile from the spfile:
CREATE PFILE FROM SPFILE;
Edit the generated pfile and remove the parameters, then recreate the spfile from the edited pfile. Bounce the database & all should be well.
The database might need to be down when you recreate the spfile from the pfile.
1
You should use export/import. On your side do:
expdp system/systempawwdord SCHEMAS=YOURSCHEMA
This will produce a file. Take it manually to you customer using CD, DVD, Pendrive. On customer site do:
impdp system/systempassword SCHEMAS=YOURSCHEMA
If the customer is using a different Oracle version, this is not a problem. You probably need to manually ...
1
Log file sync occurs when a commit is made and the redo buffer needs to be flushed to disk. The session has to wait for that to happen.
An increase in the number of log file syncs generally means that one of your developers has gone commit-happy, and is committing far too frequently -- every row, for example.
Here you probably have a process that performs ...
1
The APEX administrator accounts are not linked to a database schema. Reciprocally, creating a database schema won't create an APEX account.
You'll have to create the administrator account via the web interface.
Connect to the administration page:
If your setup uses the embedded PL/SQL gateway, go to:
http://hostname:port/apex/apex_admin
If ...
1
Have you looked at the DBMS_METADATA option? http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_metada.htm#i1019414
This gives you the schema for objects. It is fairly easy to take the results of this and do what you want with it. An example to get the tables and views of a user would be:
set serveroutput on;
declare
theSchema VARCHAR2(30) := ...
Only top voted, non community-wiki answers of a minimum length are eligible
