New answers tagged oracle-11g-r2
1
You can do this directly from SQL Server Management Studio.
Within SSMS, just right click the database, select Tasks -> Import Data, select an Oracle typed data source and set up your connection to the Oracle database.
Here's a really good description of the full procedure, including setting up an Oracle client on the machine doing the migration.
...
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 ...
0
ALTER USER <user> QUOTA 100M ON <user>;
GRANT UNLIMITED TABLESPACE TO <user>
0
WEST_EUROPEAN would seem to be the obvious choice, but there is no default that lets you avoid setting it on an individual language basis.
1
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.
1
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
We use oracle-ddl2svn set of tools for automatization storing of oracle DDL schema in SVN.
0
3
In case of the oldskool manual duplicate
on the target server ( where you want the duplication )
you can do rman target /
catalog start with '<path to backup>';
Then it'll print out all the backups, don't worry if you have other files in here. He'll give a couldn't read header something.
After this you should do crosscheck backup;
So it will be ...
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 ...
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.
...
0
First change the parameter at the system level:
alter system set nls_timestamp_format = 'dd/mm/yyyy' scope='both';
This will also update the spfile so even if you bounce the db you'll keep your definition.
Second, check for any specific definitions in your client.
If you're using windows go to
the registry - check if you have the nls_timestamp_format ...
0
Red Gate have a tool call Data Compare for Oracle that will help you.
The software can sync your two schemas for you, or you can generate a script and and run it through SQL Developer, Toad etc.
(Disclaimer: I work for Red Gate)
0
FRA will be purged automatically when free space is needed
Put the archived logs in FRA as well
Use RMAN to make the backups and use RMAN commands (REPORT OBSOLETE / DELETE OBSOLETE) to manage the purging of backup pieces + archived logs from FRA
From docs: (http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm)
The Oracle Flashback ...
0
I think that what you need to use is a Nonequi join
select *
from
table_a,
table_b
where
table_a.id1 = table_b.id1
and table_a.id2 = table_b.id2
and table_a.evnt_sec BETWEEN table_b.evnt_sec -2 and table_b.evnt_sec +2
0
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) := ...
0
It seems you have run one of cat*.sql scripts as SYSTEM instead of SYS. Not cool.
Alternatives:
Contact support.
...or determine what exactly has been done, and then having the SQL script(s) revert the actions one by one. There is nothing in Oracle to help you, you need to determine by your own means (some old notes? old screenlogs? clues in old ...
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 ...
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 ...
1
Your problem is almost certainly that you are entering an email address into the installer to receive information about updates. However this functionality will only work correctly if you also have a valid Oracle Support account.
Since you are in a home environment, I would leave the email address empty. The installer should then proceed without generating ...
0
You do not use a proxy, you likely have a network problem that prevents connection to the internet or a general lack of networking knowledge. I would suggest you try some ping tests to establish connectivity and take your problem to a networking forum.
Top 50 recent answers are included
