Anthonyx82's questions

我正在尝试将完整的数据库转储导入impdp到不同的 Oracle 19c（标准版 2）环境中，但该REMAP_DATAFILE参数似乎不起作用。

我的目标是将转储从名为db_source的源数据库导入到名为db_target的目标数据库中，将所有数据文件重定向到不同的文件夹路径（/opt/oracle/oradata/oradata/DB_TARGET/pdb_target/），因为不同环境的文件系统结构不同。

.par这是我的文件中的内容：

REMAP_DATAFILE=/opt/oracle/oradata/oradata/DB_SOURCE/:/opt/oracle/oradata/oradata/DB_TARGET/pdb_target/

但是，我不断收到如下错误：

ORA-39083: Object type TABLESPACE:"DATOSLOB" failed to create with error:
ORA-01119: error in creating database file '/opt/oracle/oradata/oradata/DB_SOURCE/DATOSLOB_01'
ORA-27038: created file already exists

我已确认我已pdb_target使用 连接到正确的 PDB ( ) SHOW CON_NAME;。

我还使用生成了 SQL 预览SQLFILE=preview.sql并注意到数据文件路径没有被重新映射，它们仍然指向/opt/oracle/oradata/oradata/DB_SOURCE/。

我发现有人在这里遇到同样的问题（仍未解决）：https://forums.oracle.com/ords/apexds/post/data-pump-datafile-remapping-does-not-work-5729

如何REMAP_DATAFILE在 Oracle 19c 上正常工作？是否有其他要求或已知错误？

我正在开发一个 Laravel 项目，并且有以下迁移：

public function up(): void
{
    Schema::create('customers', function (Blueprint $table) {
        $table->id('customer_id');
        $table->string('first_name', 50);
        $table->string('last_name', 50);
        $table->string('address', 100)->nullable();
        $table->string('phone', 15)->nullable();
        $table->string('email', 50)->unique();
        $table->timestamp('registration_date')->default(DB::raw('CURRENT_TIMESTAMP'));
        $table->timestamps();
    });
}

/**
 * Reverse the migrations.
 */
public function down(): void
{
    Schema::dropIfExists('customers');
}

public function up(): void
{
    Schema::create('vehicles', function (Blueprint $table) {
        $table->id('vehicle_id');
        $table->foreignId('customer_id')->constrained('customers')->onDelete('cascade');
        $table->string('make', 50);
        $table->string('model', 50);
        $table->year('year');
        $table->string('license_plate', 15)->unique();
        $table->string('vin', 17)->unique();
        $table->string('color', 20)->nullable();
        $table->timestamp('registration_date')->default(DB::raw('CURRENT_TIMESTAMP'));
        $table->timestamps();
    });
}

/**
 * Reverse the migrations.
 */
public function down(): void
{
    Schema::dropIfExists('vehicles');
}

正如您在表中看到的vehicles，有一个外键引用该customers表。我将向您展示模型中的关系：

class Vehicle extends Model
{
    use HasFactory;

    /**
     * The primary key associated with the table.
     *
     * @var string
     */
    protected $primaryKey = 'vehicle_id';

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'customer_id',
        'make',
        'model',
        'year',
        'license_plate',
        'vin',
        'color',
        'registration_date',
    ];

    public function customer(): BelongsTo
    {
        return $this->belongsTo(Customer::class, 'customer_id');
    }
}

class Customer extends Model
{
    use HasFactory;

    /**
     * The primary key associated with the table.
     *
     * @var string
     */
    protected $primaryKey = 'customer_id';

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'first_name',
        'last_name',
        'address',
        'phone',
        'email',
        'registration_date',
    ];

    public function vehicles(): HasMany
    {
        return $this->hasMany(Vehicle::class, 'customer_id');
    }
}

最后，工厂：

class CustomerFactory extends Factory
{
    protected $model = Customer::class;

    /**
     * Define the model's default state.
     *
     * @return array<string, mixed>
     */
    public function definition(): array
    {
        return [
            'first_name' => fake()->name(),
            'last_name' => fake()->lastName(),
            'address' => fake()->address(),
            'phone' => fake()->phoneNumber(),
            'email' => fake()->email(),
            'registration_date' => fake()->date(),
        ];
    }
}

class VehicleFactory extends Factory
{
    protected $model = Vehicle::class;

    /**
     * Define the model's default state.
     *
     * @return array<string, mixed>
     */
    public function definition(): array
    {
        return [
            'customer_id' => Customer::factory(),
            'make' => fake()->company,
            'model' => fake()->word,
            'year' => fake()->year,
            'license_plate' => strtoupper(fake()->unique()->bothify('???-####')),
            'vin' => strtoupper(fake()->unique()->bothify('?????????????????')),
            'color' => fake()->safeColorName,
            'registration_date' => fake()->date(),
        ];
    }
}

显然，发生了以下错误：

SQLSTATE[HY000]: General error: 1 foreign key mismatch - "vehicles" referencing "customers" (Connection: sqlite, SQL: insert into "vehicles" ("customer_id", "make", "model", "year", "license_plate", "vin", "color", "registration_date", "updated_at", "created_at") values (11, Wilderman Group, nostrum, 1970, VRF-4423, FVKRDKQWQHGDVFWBP, purple, 2019-01-16, 2024-11-13 18:30:33, 2024-11-13 18:30:33))

此错误是由于尝试在vehicles表中为 ID 为 11 的客户添加外键而导致的，但该外键显然不存在，因为只为 15 辆车创建了 10 个客户。我尝试通过循环遍历所有创建的车辆并将它们分配给现有客户来“强制”消除错误，但这导致了另一个错误。我认为这里可能存在问题，修复起来比尝试以框架未设计的方式解决问题要简单得多。如果有人知道可能出了什么问题，我将不胜感激。

PS 我正在使用 Laravel 11