New answers tagged

1

I know I'm late for party, but someone else with similiar issue may find it useful so anyways: I would say that you don't have AUDIT_TRAIL set to DB,EXTENDED but perhaps only to DB or something. If you want SQLTEXT to be populated it is mandatory to have AUDIT_TRAIL set to DB,EXTENDED. Check your current AUDIT_TRAIL status: select * from v$parameter ...


0

Short answer - No. You could do this by handing out massively overpowered sets of permissions - don't. If I understand correctly, your MAIN schema exists in the production database, holds all your production tables, packages and procedures. If you were to do "something stupid" in there, you'd make one H*** of a mess. Currently, you are using the ...


0

Here is the list of changes: Behavior Changes, Deprecated and Desupported Features for Oracle Database 12c Release 2 (12.2) Such basic functionality that you mentioned (table joins, stored procedures, JDBC connections) should of course work. Sure, there are new features, and some changes, but I can not recall anything significant related to those areas ...


1

You can migrate the password file with the input_file option of orapwd. Example: [oracle@o71 ~]$ orapwd file=test format=12 Enter password for SYS: [oracle@o71 ~]$ orapwd describe file=test Password file Description : format=12 [oracle@o71 ~]$ orapwd file=test2 input_file=test format=12.2 [oracle@o71 ~]$ orapwd describe file=test2 Password file ...


0

One way to do this is to create a custom role. Many places use the DBA role out of the box but this often grants way more permissions than are really needed such as "DROP DATABASE". Create a role, for example, LIMITED_PRODUCTION_DBA_ROLE, and grant select, insert, update, delete any table; This allows "Query tables, views, or materialized views in any ...


0

The DEGREES function you refer to is not in the Oracle database code. It is in the JavaDB which is also known as Derby. There is a construct in MySQL called DEGREES so this may be what you were thinking of. You can make your own function like this CREATE OR REPLACE FUNCTION radians_to_degree(p_radian IN NUMBER) RETURN NUMBER IS BEGIN RETURN ...


2

Are you sure about the target and source version? I did here and worked right. My source DB version was 12.1.0.2.0 and the target was 12.2.0.1.0. Please, see my example below: $ cat myfile.par directory=DUMP dumpfile=MYFILE.DMP logfile=MYFILE.LOG content=ALL schemas="DIEGO","HR","USER" $ expdp user@mypdb parfile=myfile.par Exporting and Importing Between ...


0

You should use direct path INSERT. You can get a more detail insight on direct path INSERT from http://www.thisissanjeeva.com. For select you can use PARALLEL hint in the same statement. you may use PARALLEL without any parameter or use PARALLEL(n) with n number of thread. Let me know if you need more explanation on this.


1

I figured it out - PURGE DBA_RECYCLEBIN; - CREATE SPFILE FROM PFILE = '$ORACLE_HOME/dbs/initorcl.ora'; - SHUTDOWN IMMEDIATE; - startup mount; - ALTER SYSTEM SET MAX_STRING_SIZE=EXTENDED SCOPE=SPFILE; - shutdown; - STARTUP UPGRADE; - @?/rdbms/admin/utl32k.sql -show parameter MAX_STRING_SIZE NAME TYPE VALUE ------------------ -----...


0

There is an Oracle bug for version 12.1 which should have been fixed but may be applicable. It can occur when you are using the DBCA or database creation tool. Bug 15845247 If you change the MAX_STRING_SIZE initialization parameter while creating a database using DBCA with a template that includes data files, the database creation fails with the ...


0

You need to create the user that you imported, and if you want to change the name of your schema; set in the configuration: remapremap_schema remap_tablespace I hope those optiones are useful for you, regards!


2

The error message is self-explanatory: ORA-01918: user 'XXXXXX' does not exist Look at the log output for your expdp execution. If it does not contain the following: Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE ....


1

You can rewrite it as a normal C or PL/Java function in PostgreSQL. If it is important for you to run the function in a separate process, give PL/Container a try.


1

Based on your sample data and revised question: id=4 result 100.00 Table: Create Table #tbl ( id Int, [data] xml ) Insert Into #tbl Values (1,'<field id="0" value="2200"/> <field id="2" value="9048001001234567890"/> <field id="3" value="000000"/> <field id="4" currency="356" type="amount" value="100.00"/> <field id="7" value="...


0

If the following (SQL SERVER) does not hit the mark, please include your sample data and expected output. I'm not sure what you reference with [Branch data Finance]. Based on your second sentence, I created a table with 2 columns where the 1st column is your id and the second is your xml data. The query retrieves the 'data' where the id=26 Table: Create ...


0

You need to create a system service pointing to start and shutdown shell scripts. See Automating Database Startup and Shutdown on Linux on Oracle Base. Another option is to download an Oracle Developer VM and explore how auto start was setup along with a system service (one of the options from the link) – Kumar


0

With Modified JDBC parameter Both WAS & Jetty are working as expected and DB connection count are balanced on the both nodes. On RAC nodes, i have changed the tnsnames.ora -> to include the fully qualified global service name (including domain name) and it fixed sql connectivity issues.


2

These calls are all part of loading the Oracle OleDb provider. Not sure why they would block instead of failing, but it suggests that your Oracle client setup is still not not right. The 11g OraOLEDB.Oracle provider not only needs to access the correct TNSNAMES.ORA file. It also needs to load the correct OCI.DLL, which it does through the path. ...


0

I figured it out, its due to file permission issue under $GRID_HOME ls -l $GRID_HOME/bin/oracle chmod 6751 $GRID_HOME/bin/oracle Once permissions are fixed, try restarting db services.


0

Below worked for me: Checked services using services.msc Restarted the services OracleOraDB12Home1TNSListener and OracleServiceORCL After that connected using SQL developer. It worked!


Top 50 recent answers are included