As you know, Oracle Cloud runs Apex 4.1..In my premises I am running Apex 4.2...Normally, we cannot import apps exported from apex 4.2 into Apex 4.1. I am planing to move to Oracle Cloud... Can I import Apex app, which were exported from apex 4.2, into Oracle Cloud ??
If it is not compatible, then that means, I cannot move to the cloud now. When can I expect Oracle Cloud to upgrade to APEX 4.2 ??
I am testing the Oracle Cloud in a trial mode.. I have created the Oracle user and would like to restore my existing (non Oracle Cloud) database from the standard DMP file (import dmp). In all references that I could find [URL}... and that was given to me by the Oracle Cloud support service I couldn't find the definite answer on a simple question: if I have a DMP file of my own database, can I and if yes, then how I can import this DMP file to my new Oracle Cloud database? some link on "step by step" instruction, if such exists. If there is no such a way, then what way should I use?
View 1 Replies View RelatedI followed the "Loading data into your database cloud service from SQLDeveloper" tutorial, and I cannot upload a table that contains a column of type SDO_GEOMETRY. I get an error message that reads: "Unsupported Cart Object: Unable to deploy some objects to the cloud. These objects have been deleted from inclusion. Review Cart contents before redeploying. The following have an unsupported data type: SPATIAL.FLIGHT_TRACK." I can load any table that does not contain a n SDO_GEOMETRY column.
View 1 Replies View Related1. I have for example my-custom-domain.com and want that my customers use this domain to login at APEX Application at Oracle Cloud. I don't want that my customers see
[URL]........
and see instead of my-custom-domain.com :)
How I can do it? Don't find any technical information about it...
2. Can I use my ssl certificates for my domain for Oracle Cloud Instance?
We have an application which is built on top of mysql DB. Now we are planning to move into Oracle DB cloud share some documents for this migration.
View 1 Replies View RelatedI can configure in trial account interactive report for print but Print attribute section contains message: Report printing is currently not available, there is no print server configured.It will be possible to use this option in non-trial version? If yes which type of print server is configured in this version (FOP or BI Publisher)?
View 7 Replies View RelatedI would like to develop an APEX cloud app locally and offline (my PC). Later, I'll deploy it to the cloud for testing when finished. I understand that the APEX/DB in the cloud only provides a sub-set of the features of a local APEX/DB installation. To make sure I develop a solution that will run in the cloud and not depending on features not supported, I would like to set up my local PC with the same limitations as the cloud instance. Is there a script/patch etc. that can be run to limit local features (or privs to them) to mimic the same premises and enviroment as when running in the cloud? (I know such exists for MS Azure local development).
View 6 Replies View Related if APEX hosting allows access to the file system so that access to javascript, css and images files can be passed to a webserver?
What webserver comes with hosting - is this the Apache 1.3 that comes with 11g?
have created a cart in SQL Developer with all the tables from HR schema. If I apply the cart to my database cloud service the tables and data are there but most of the constraints are missing.
In log I can see error messages like:
Error starting at line 5 in command:
ALTER TABLE "EMPLOYEES" ADD CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY ("DEPARTMENT_ID") REFERENCES "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE
Error report: SQL Error: ORA-02270: no matching unique or primary key for this column-list
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE
[code]...
what is the recommended "LINUX" version for 12c cloud controller installation?
View 0 Replies View RelatedI am really wondering about data loading to the cloud, I've just read the documentation, but regarding the packages, I have more than 100 package and I have to "add to cart" one by one the problem is that the package body is not added by default, so you have to expand the packages one by one then select the package body right click and add to cart. This task is very tedious, is there any other options.”
View 8 Replies View RelatedI am trying to connect to a cloud account for the first time.BUT I get this error here...This webpage has a redirect loop The webpage at[URL]... has resulted in too many redirects. Clearing your cookies for this site or allowing third-party cookies may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer.
Here are some suggestions:
Reload this webpage later.
Error occurred, While installing the agent in 11g database.
Error is listed below
[oracle@grid agent]$./agentDeploy.sh AGENT_BASE_DIR=/ebiz/oracle RESPONSE_FILE= agent.rsp
AGENT_BASE_DIR=/ebiz/oracle
Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /ebiz/oracle/core/12.1.0.1.0/jdk/bin/java -classpath /ebiz/o
[code]./..
Executing agent install prereqs... Executing command: /ebiz/oracle/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSys rereqs -prereqchecker -silent -ignoreSysPrereqs -waitForCompletion -prereqlogl c /ebiz/oracle/core/12.1.0.1.0/cfgtoollogs/agentDeploy -entryPoint oracle.sysma .top.agent_Complete -detailedExitCodes PREREQ_CONFIG_LOCATION=/ebiz/oracle/core 12.1.0.1.0/prereqs -J-DORACLE_HOSTNAME=grid.4iapps.com -J-D
[code]...
I have data in point cloud (x,y,z,a,b,c,d (a,b,c,d are some attributes about this point)). i create a point cloud (sdo_pc - geometry), block tables (sdo_geometry - geometry). if i use a function to_geometry, result is only in multi point without attributes. it is way display this 3D data, and at the same time inquire of concerning for a attributes in concrete points?
View 0 Replies View RelatedNow we have 11G grid control on linux x86_64 server and we are planning to upgrade this to 12c Cloud control,
What are the available options,
1) upgrade from 11g to 12c on the same server.
2) Build another linux server and install 12cloud.
which ever is easy to have 12c upgrade. oracle recommended url's to follow the installation.
I have a requirement to fetch the nearest neighbor from a given point coordinates inside a point cloud/georaster data. how can i retrieve a collection of all neighboring points from a given point.
I guess i will have to use sdo_nn operator. how to use the operator to achieve the result.
I am having 2 data centers within 1/2 km distance. And we kept each vote disk in once site. In case of site failure, the cluster needs a 3rd set. We don't have 3rd site.
Last open world, Oracle announced that oracle storage on cloud as announced. If I get the small space on the cloud, can i put my 3rd vote disk on the cloud?
How the loop back entry in /etc/hosts relates to listener?
View 1 Replies View RelatedThe requirement is, the combination of col1,col2,col3 and col4 should always be unique, and wherever the col1, col2,col3 are same then col4 should be the sequence, starting from 1. Likewise the data should be updated back to the table.I'm able to do this using PL/SQL. Can I do the same using a single update statement?
create table tab1 (col1 number(5), col2 number(5), col3 number(5), col4 number(5));
Existing Data:
insert into tab1 values (101,521,3,1);
insert into tab1 values (101,521,3,1);
insert into tab1 values (101,522,3,2);
insert into tab1 values (101,522,3,2);
insert into tab1 values (101,523,3,1);
insert into tab1 values (101,523,3,2);
[code]....
I have deleted all the records from the table.And I have committed.Now I want to get all the records back.
View 16 Replies View RelatedI want a function that'll execute a query and return the whole table record then i need to somehow pick a column in that record and return the data in that column
So like
function something(p_param varchar2)
return table_record
something('blah).employee_number
where employee_number is a column in that table
I'm making a menu in my form, wherein it has FILE, TRANSACTION and REPORT. Under FILE it has BACK, and LOGOUT. In my back menu item, i want to go back to the previous block or previous module. I used previous_block but it's not working in some of my blocks.
View 8 Replies View Relatedcache sequence all my sequence scripts has a cache of 20...here is the script
CREATE SEQUENCE APP_TEMP_SEQ
START WITH 1000400
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;
is there any draw back caching sequence ? I noticed in my tables several sequences are skipped.
I come from a world of MSSQL and have been thrown into doing some Oracle work. Great! Ok, moving on.. I work in an environment where I do not have direct access to the database tables that I need data from. As a workaround, I have been asked to create a stored procedure that will be loaded into our CRM system's production db once it goes through the internal "approval" process.Basically, I need to return a result set back to the client by calling a stored procedure.
Version 1 of this that was already in place was done with the following code.
procedure events_by_day (p_start_date IN OPERATION_LOG.DT%type,
p_end_date IN OPERATION_LOG.DT%type,
p_results OUT SYS_REFCURSOR) IS
BEGIN
OPEN p_results FOR
[code]....
Then the code is executed from the client side like so:
events_by_day(p_start_date => to_date('2012-3-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),
p_end_date => to_date('2012-3-29 23:59:59', 'YYYY-MM-DD HH24:MI:SS'),
p_results => r_cursor);
LOOP
FETCH r_cursor
INTO event_date, event_acct_no, event_type, event_count;
[code]....
As you can see, a SYS_REFCURSOR was used in this case to pass the data back.
When we are running a query it is giving us the result based on the conditions .But to know what exactly is happening in the database when we are running a query against it and how finally it returns the result.
View 1 Replies View Relatedhow to get first word from string.example i have string like:-
Jack Bore American
Mark D'suz Australian
Raj
Deniel indian
Some
i am expecting first word as out put like :-
jack
mark
Raj
Deniel
Some
in the same maner if i want should get two words also.
I have a 3 node RAC server on Windows Server 2008. Last week the hard drive went out on one of the nodes and I have had to rebuild as I could not recover anything.
I went through and deleted the old node and now I have just finished adding the new node back to my cluster via documentation. Once I created the new instance on that server DBCA attempted to start and it failed gaving me a crs error. I found out later that the other 2 nodes went down and the new one that did not start correctly was the only one up!! I went and stopped the new instance and restarted the first 2. The associated services did not start with the instance so I had to start each manually. The trace files show an ORA-29702 error with cluster group service and the instance being stopped on both of the existing nodes. No other error messages stood out.
Now I cannot get any crs services to start on that 3rd node even if I attempt to start manually. I have also tried stopping all and restarting and that does not work. I found another post on this forum from you and followed it. The ASM service was fine the entire time through all the logs and I don't know how to verify LMON in Windows but I didn't see any LMON errors in the alert log. Also, the voting disks are online. Each node has their own and they are mirrored. Where else to look?
here i have an question with oracle database backup strategy.my question is
how to backup my oracle database call DB11G without archived logs while the database is open for user activity and also this should be the base for an incremental backup strategy?
I am trying to generate a software that used VB as the front end and Oracle 10G as the back end. I have noticed that the date format is VB is : m/dd/yyyy whereas the date format in oracle is dd-mm-yyyy. Whenever i try to insert a tuple with either of the date formats, the program halts running and after a long time , i get a message saying a deadlock was encountered. I have never had any formal introduction to either of the two tools
View 1 Replies View RelatedI overwritten the package and want to get the previous version.
Is there a way I can get it using FLASHBACK or any other feature?
My user_recyclebin is showing only tables.
SELECT object_name, original_name, TYPE
FROM user_recyclebin;