Cloud Service :: Constraints Not Created When Using A Cart?
Oct 16, 2013
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]...
View 0 Replies
ADVERTISEMENT
Jan 14, 2013
I 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 Related
Mar 6, 2013
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 Related
Nov 28, 2012
I 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 Related
Feb 25, 2013
1. 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?
View 7 Replies
View Related
Jul 18, 2013
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 Related
Mar 15, 2013
I 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 Related
Dec 3, 2012
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 ??
View 4 Replies
View Related
Dec 4, 2012
I 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
Oct 3, 2012
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?
View 6 Replies
View Related
Nov 14, 2013
what is the recommended "LINUX" version for 12c cloud controller installation?
View 0 Replies
View Related
Feb 7, 2013
I 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.
View 1 Replies
View Related
May 6, 2013
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]...
View 5 Replies
View Related
Feb 14, 2013
Is there a way to find when was a database role created and who has created?
View 5 Replies
View Related
Aug 17, 2012
tell me if a REFRESH GROUP is automatically created when a materialized view is created?
View 3 Replies
View Related
Jun 13, 2012
I want to create a store procedure to copy data from a source tables(which may not have any constraints defined) to a table which has primary key, foreign key and unique key constraints.
Any records which are rejected due to these constraints not being satisfied need to go another table.
Once the initial data load is done, these procedures need to be automated(through cron) to do the future incremental uploads in the same manner.
View 6 Replies
View Related
Oct 10, 2012
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 Related
May 29, 2013
Now 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.
View 4 Replies
View Related
Mar 9, 2013
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.
View 21 Replies
View Related
Dec 11, 2012
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?
View 1 Replies
View Related
Feb 25, 2008
How do know all the constraints that are present on the data in a table in oracle ??
View 2 Replies
View Related
Nov 1, 2013
I want to display columns along with their constraints using describe command
Is it possible?
SQL> desc dept;
Name Null? Type
----------------------------------------- -------- -------------
DEPTNO NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)
View 1 Replies
View Related
Mar 7, 2010
Basically, I need to fulfil the constraint:
"student cannot have more than 100 points"
I need to use a trigger to do this, but I don't understand how this would work.
Written in plain english I imagine it work work something like:
AFTER UPDATE
WHERE student.lessonid = lesson.lessonid
IF SUM(lesson.points) > 100 then ROLLBACK
lessonid is the only field relating the two tables.
--
How to fulfill that criteria, whether it be using triggers or not.
View 7 Replies
View Related
Mar 21, 2011
How to create any constraints other than NOT NULL in PLSQL RECORD.
View 5 Replies
View Related
Mar 5, 2012
Ive created a scenario to what im trying to achieve here so ignore how its set-up attribute wise.
CREATE TYPE object_obj AS OBJECT (
obj_id NUMBER,
NAME VARCHAR2(20),
age NUMBER) NOT FINAL;
/
CREATE TYPE object_ext UNDER object_obj (
course_name VARCHAR2(20));
/
CREATE TYPE object_ext2 UNDER object_obj (
location VARCHAR2(20);
/
CREATE TABLE object_tab OF object_obj(obj_id PRIMARY KEY);
/
Now for the course_name i need to make sure it can only be on of these three values ('Science','Math','English'). I can't find a way to apply this constraint without making a table. But then that creates another issue of how to insert the data from the main supertype (object_obj) and i only want the object_tab table and view the subtypes via a select query.
View 28 Replies
View Related
Aug 23, 2013
When a table structure is copied from another table.What are the constraints copied and why?Unique keyPrimary keyForeign KeyCheckNot null.
View 10 Replies
View Related
Oct 19, 2006
After creating all the tables and the constraints, and inputting data to the table.. i want to delete everything. i try using drop table but it doesn't get rid of the constraints.
View 10 Replies
View Related
Jul 5, 2012
I was wondering with dba_constraints and i found unexpected result shown as below
select constraints_name, constraint_type from dba_constraints
constraint_name constraint_type
SYS_C00141 c
SYS_C00142 c
SYS_C00143 c
SYS_C00144 c
SYS_C00145 c
SYS_C00146 c
SYS_C00147 c
SYS_C00148 c
SYS_C00149 c
i jst want to know that what is this system generated constraints ?
View 3 Replies
View Related
Jul 1, 2010
I would like to print all the constraints on all columns given a table name.
Example:
SQL>@constrnts
Enter Table Name: emp
empno ---- Primary key
deptno ---- foreign key references Dept(deptno)
View 16 Replies
View Related
Dec 3, 2011
So I'm here creating some tables and if theres a guide where I can take a look at some Constraints Declarations , Mostly cause i have some values on the table that cannot be negative so i need to set constraints to be positive
View 4 Replies
View Related
